上的。 Greenplum数据库是基于PostgreSQL数据库的，所以 可以用PostgreSQL数据库的工具来连接Greenplum数 据库，如java程序可以使用PostgreSQL的jdbc驱动来 访问Greenplum数据库，也可以使用psql工具或 pgadminII来管理Greenplum。 Greenplum架构: Master介绍 Greenplum的Master数据库也是一个被改造过的 ary与 mirror端的数据不同步了，所以恢复的时候需要花比较 长的时间。对于Greenplum 3.X的版本，恢复时，需要 把好的节点上的所有数据都copy到坏的机器上。而 Greenplum4.0版本增加了功能，当备份节点坏的时 候，主节点可以把增量数据记下来，这样当备份节点的 主机恢复时，只需要恢复增量数据就可以了。 要让原先已offline的节点再加入集群中，需要重启集 群。 Greenplum中的高可用方案 对于Greenplum 3.X的版本，segment 的primary与 mirror之间是做的逻辑同步，mirror端的数据库实际上 也是可以读写的。而Greenplum4.0版本后，primary与 mirror实际上是物理同步，这时mirror一直处于恢复状 态，不能读也不能写。 高可用之Master Mirroring 对于Greenplum Maste

type> 448 Using the ResultSetProvider Interface 449 Using the ResultSetHandle Interface 450 Using JDBC 451 Exception Handling 451 Savepoints 452 VMware Greenplum v6.19 Documentation VMware, Inc. 22 Kerberos Authentication 0 Mapping Kerberos Principals to Greenplum Database Roles 656 Configuring JDBC Kerberos Authentication for Greenplum Database 0 Installing and Configuring a Kerberos KDC Server DataDirect Driver Documentation 1969 DataDirect JDBC Driver for VMware Tanzu Greenplum 1970 VMware Greenplum v6.19 Documentation VMware, Inc. 137 DataDirect JDBC Driver for VMware Tanzu Greenplum 0 Prerequisites

Using the ResultSetHandle Interface 440 VMware Greenplum v6.18 Documentation VMware, Inc. 21 Using JDBC 441 Exception Handling 442 Savepoints 442 Logging 442 Security 0 Installation 443 Trusted Language Kerberos Authentication 0 Mapping Kerberos Principals to Greenplum Database Roles 647 Configuring JDBC Kerberos Authentication for Greenplum Database 0 Installing and Configuring a Kerberos KDC Server Documentation 1956 DataDirect JDBC Driver for VMware Tanzu Greenplum 1957 DataDirect JDBC Driver for VMware Tanzu Greenplum 0 Prerequisites 1957 Downloading the DataDirect JDBC Driver 1957 Obtaining Version

SETOF 443 Using the ResultSetProvider Interface 443 Using the ResultSetHandle Interface 444 Using JDBC 445 Exception Handling 446 Savepoints 446 Logging 446 Security 447 Installation 447 Trusted Kerberos Authentication 644 Mapping Kerberos Principals to Greenplum Database Roles 646 Configuring JDBC Kerberos Authentication for Greenplum Database 647 Installing and Configuring a Kerberos KDC Server 1984 DataDirect Driver Documentation 1986 DataDirect JDBC Driver for VMware Tanzu Greenplum 1986 Prerequisites 1986 Downloading the DataDirect JDBC Driver 1987 Obtaining Version Details for the Driver

type> 374 Using the ResultSetProvider Interface 374 Using the ResultSetHandle Interface 375 Using JDBC 376 Exception Handling 377 Savepoints 377 Logging 377 Security 0 Installation 378 Trusted Language Kerberos Authentication 0 Mapping Kerberos Principals to Greenplum Database Roles 579 Configuring JDBC Kerberos Authentication for Greenplum Database 0 Installing and Configuring a Kerberos KDC Server Documentation 1890 DataDirect JDBC Driver for VMware Tanzu Greenplum 1891 DataDirect JDBC Driver for VMware Tanzu Greenplum 0 Prerequisites 1891 Downloading the DataDirect JDBC Driver 1891 Obtaining Version

type> 977 Using the ResultSetProvider Interface 978 Using the ResultSetHandle Interface 979 Using JDBC 980 Exception Handling 980 Savepoints 981 Logging 981 Security 981 Installation 982 Trusted Kerberos Authentication 1054 Mapping Kerberos Principals to Greenplum Database Roles 1055 Configuring JDBC Kerberos Authentication for Greenplum Database 1056 Installing and Configuring a Kerberos KDC Server 2416 DataDirect Driver Documentation 2417 DataDirect JDBC Driver for VMware Tanzu Greenplum 2418 Prerequisites 2418 Downloading the DataDirect JDBC Driver 2418 Obtaining Version Details for the Driver

VMware Greenplum 6 Documentation VMware, Inc. 42 Using the ResultSetHandle Interface 947 Using JDBC 948 Exception Handling 949 Savepoints 949 Logging 950 Security 950 Installation 950 Trusted Kerberos Authentication 1023 Mapping Kerberos Principals to Greenplum Database Roles 1024 Configuring JDBC Kerberos Authentication for Greenplum Database 1025 Installing and Configuring a Kerberos KDC Server 2371 DataDirect Driver Documentation 2372 DataDirect JDBC Driver for VMware Tanzu Greenplum 2373 Prerequisites 2373 Downloading the DataDirect JDBC Driver 2373 VMware Greenplum 6 Documentation VMware

SETOF 813 Using the ResultSetProvider Interface 813 Using the ResultSetHandle Interface 814 Using JDBC 815 Exception Handling 815 Savepoints 815 Logging 815 Security 816 Installation 816 VMware Tanzu Kerberos Authentication 878 Mapping Kerberos Principals to Greenplum Database Roles 880 Configuring JDBC Kerberos Authentication for Greenplum Database 881 Installing and Configuring a Kerberos KDC Server 1999 DataDirect Driver Documentation 2000 DataDirect JDBC Driver for VMware Tanzu Greenplum 2001 Prerequisites 2001 Downloading the DataDirect JDBC Driver 2001 Obtaining Version Details for the Driver

SETOF 965 Using the ResultSetProvider Interface 965 Using the ResultSetHandle Interface 966 Using JDBC 967 Exception Handling 967 Savepoints 968 Logging 968 Security 969 Installation 969 Trusted Kerberos Authentication 1040 Mapping Kerberos Principals to Greenplum Database Roles 1042 Configuring JDBC Kerberos Authentication for Greenplum Database 1043 Installing and Configuring a Kerberos KDC Server 2345 DataDirect Driver Documentation 2346 DataDirect JDBC Driver for VMware Tanzu Greenplum 2346 Prerequisites 2346 Downloading the DataDirect JDBC Driver 2347 Obtaining Version Details for the Driver

SETOF 935 Using the ResultSetProvider Interface 935 Using the ResultSetHandle Interface 936 Using JDBC 937 Exception Handling 937 Savepoints 938 Logging 938 Security 938 Installation 938 Trusted Kerberos Authentication 1009 Mapping Kerberos Principals to Greenplum Database Roles 1011 Configuring JDBC Kerberos Authentication for Greenplum Database 1012 Installing and Configuring a Kerberos KDC Server 2269 DataDirect Driver Documentation 2270 DataDirect JDBC Driver for VMware Tanzu Greenplum 2271 Prerequisites 2271 Downloading the DataDirect JDBC Driver 2271 Obtaining Version Details for the Driver