添加到⼯程的 BUILD PATH。 ⽰例程序1，java连接UDW，执⾏建表，插⼊操作 PostgreSQLJDBC1.java import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class PostgreSQLJDBC1 { public static } } ⽰例程序⼆：java连接UDW，执⾏查询操作 PostgreSQLJDBC2.java import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class PostgreSQLJDBC2 { greenplum-client.tar.gz 2）配置udw客⼾端 进⼊ greenplum-client 安装⽬录，编辑 greenplum_client_path.sh 修改UDW_HOME(export UDW_HOME= client安装⽬录)（如/root/greenplum-client） 3） 使配置⽣效 在~/.bashrc中添加如下配置 source /data/greenp

Description 1456 Parameters 1458 Notes 1460 Examples 1461 Compatibility 1462 See Also 1462 IMPORT FOREIGN SCHEMA 1462 Synopsis 1462 Description 1462 Parameters 1463 Examples 1463 Compatibility Information 1645 About the Remote Execution Options 1645 About the Updatability Option 1646 About the Import Options 1646 About the Cost Estimation Options 1646 About Connection Management 1646 About Transaction over B-tree indexes. The SELECT SQL command now supports the SKIP LOCKED option. The new command IMPORT FOREIGN SCHEMA provides support for importing a complete schema from an external database. The

2065 Options 2065 gpv base 2065 Synopsis 2065 Description 2065 Sub-commands 2065 deploy 2065 import 2066 VMware Greenplum 6 Documentation VMware, Inc. 122 Examples 2066 gpv config 2066 Synopsis caused Assertion failure. (Resolved by PR- 13472.) n/a : Adds distributed snapshot support to pg_export_snapshot. (Resolved by PR-13470.) n/a : Allows LOCK TABLE to be conducted on MASTER ONLY to improve config list Importing the Base Template as a Virtual Machine Import the base template by running the following command: gpv base import -t This command clones the base template as

2107 Options 2108 gpv base 2108 Synopsis 2108 Description 2108 Sub-commands 2108 deploy 2108 import 2108 Examples 2109 gpv config 2109 Synopsis 2109 Description 2109 Required Inputs 2109 Sub-commands caused Assertion failure. (Resolved by PR- 13472.) n/a : Adds distributed snapshot support to pg_export_snapshot. (Resolved by PR-13470.) n/a : Allows LOCK TABLE to be conducted on MASTER ONLY to improve MASTER_DATA_DIRECTORY environment variable. For example: source /usr/local/greenplum-db/greenplum_path.sh export MASTER_DATA_DIRECTORY=/data/master/gpseg-1 3. (Optional) You may also want to set some client session

caused Assertion failure. (Resolved by PR- 13472.) n/a Adds distributed snapshot support to pg_export_snapshot. (Resolved by PR-13470.) n/a Allows LOCK TABLE to be conducted on MASTER ONLY to improve VMware Greenplum 6 Documentation VMware, Inc 371 $ echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bashrc $ ssh smdw 'echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bash Greenplum master and standby master environment variables, and load the master variables: $ echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bashrc $ source ~/.bashrc Next Steps Now that

caused Assertion failure. (Resolved by PR- 13472.) n/a Adds distributed snapshot support to pg_export_snapshot. (Resolved by PR-13470.) n/a Allows LOCK TABLE to be conducted on MASTER ONLY to improve Tanzu Greenplum 6 Documentation VMware, Inc 361 $ echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bashrc $ ssh smdw 'echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bash Greenplum master and standby master environment variables, and load the master variables: $ echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bashrc $ source ~/.bashrc Next Steps Now that

caused Assertion failure. (Resolved by PR- 13472.) n/a : Adds distributed snapshot support to pg_export_snapshot. (Resolved by PR-13470.) n/a : Allows LOCK TABLE to be conducted on MASTER ONLY to improve environment variables, and load the master variables: $ echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bashrc $ ssh smdw 'echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bash Greenplum master and standby master environment variables, and load the master variables: $ echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bashrc $ source ~/.bashrc Next Steps Now that

caused Assertion failure. (Resolved by PR- 13472.) n/a Adds distributed snapshot support to pg_export_snapshot. (Resolved by PR-13470.) n/a Allows LOCK TABLE to be conducted on MASTER ONLY to improve environment variables, and load the master variables: $ echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bashrc $ ssh smdw 'echo export MASTER_DATA_DIRECTORY=/gpdata/master/gpseg-1 >> ~/.bash MASTER_DATA_DIRECTORY environment variable. For example: source /usr/local/greenplum-db/greenplum_path.sh export MASTER_DATA_DIRECTORY=/data/master/gpseg-1 3. (Optional) You may also want to set some client session

Greenplum v6.18 Documentation VMware, Inc. 266 source /usr/local/greenplum-db/greenplum_path.sh export MASTER_DATA_DIRECTORY=/data/master/gpseg-1 3. (Optional) You may also want to set some client session variables such as PGPORT, PGUSER and PGDATABASE for convenience. For example: export PGPORT=5432 export PGUSER=gpadmin export PGDATABASE=gpadmin 4. (Optional) If you use RHEL 7 or CentOS 7, add the following the end of the .bashrc file to enable using the ps command in the greenplum_path.sh environment: export LD_PRELOAD=/lib64/libz.so.1 ps 5. Save and close the file. 6. After editing the profile file, source

MASTER_DATA_DIRECTORY environment variable. For example: source /usr/local/greenplum-db/greenplum_path.sh export MASTER_DATA_DIRECTORY=/data/master/gpseg-1 3. (Optional) You may also want to set some client session variables such as PGPORT, PGUSER and PGDATABASE for convenience. For example: export PGPORT=5432 export PGUSER=gpadmin export PGDATABASE=gpadmin 4. (Optional) If you use RHEL 7 or CentOS 7, add the following the end of the .bashrc file to enable using the ps command in the greenplum_path.sh environment: export LD_PRELOAD=/lib64/libz.so.1 ps 5. Save and close the file. 6. After editing the profile file, source