PostgreSQL 发展而来，用户端可以如同访问 PostgreSQL 那样与 GP 进行交互。可以通过 PostgreSQL 客户端程序(如 psql、pgAdminIII)和应用程序 接口(APIs(如 JDBC、ODBC))连接 GP。不过，GP 在 5 版本和 6 版本中，因为 PostgreSQL 版本的不断合并，有不少系统表的发生了变化，所以，原有适用的客户 端，可能需要一定的适配开发工作，才能适用新的 18616691889) 编写：陈淼 - 13 - Master 的连接数是有限的，缺省值为 250 个，如果要大规模提升连接的可用数 量，可以配置使用 GP 自带的 pgbouncer 连接池，这对于一些应用场景会很有帮助， 例如 SAS 等软件连接 GP 时，由于这些软件自身无法严格限制连接数，pgbouncer 会 是一个有效的缓解连接数过大的方案，例如按照如下方式进行配置： 容 5 版本和 6 版本。  使用标准数据库应用接口，例如 ODBC 和 JDBC，用户可以开发出自己的客户端程 序。由于 GP 基于 PostgreSQL 而来，可以直接使用 PostgreSQL 驱动访问 GP。  使用标准数据库应用接口的客户端程序，例如使用 ODBC 和 JDBC 的客户端程序， 可以通过配置的方式连接到 GP。 GP 的客户端应用程序

组成。基本组成部分的功能如下： 产品架构 Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 7/206 1. Client：访问 UDW 的客⼾端 ⽀持通过 JDBC、ODBC、PHP、Python、命令⾏ Sql 等⽅式访问 UDW 2. Master Node：访问 UDW 数据仓库的⼊⼝ 接收客⼾端的连接请求 负责权限认证 处理 SQL 命令 调度分发执⾏计划 如上图所⽰客⼾端访问管理，提供了客⼾端下载和数据加载⼯具和⽂档的下载。 JDBC连接 连接 Linux操作系统 快速上⼿ Greenplum数据仓库 UDW Copyright © 2012-2021 UCloud 优刻得 17/206 yum install postgresql-jdbc.noarch –y Windows 环境下 JDBC 驱动，将 jar 添加到⼯程的 BUILD PATH。 Statement stmt = null; try { Class.forName("org.postgresql.Driver"); c = DriverManager.getConnection("jdbc:postgresql://hostIP:port/dbname",”UserName”,”Password”); stmt = c.createStatement(); String sql

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> 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