一个GP数据操作范例（国外英文资料）.doc

一个GP数据操作范例（国外英文资料） (data import and export on virtual machine) #huang chunbao writes The # gpadmin user is a superuser of greenplum Gp started: Switch to gpadmin user and execute gpstart Gp closed: Execute under gpadmin users gpstart 【 note 】 Before you close the virtual machine, you must execute the gpstop to close gp. There are three users in the virtual machine: bonc, gpadmin, root and their passwords are gpadmin = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = Create daily operating users, libraries, schemas, external tables: Step 1, create the user [gpadmin @wmd etl_data] $ [gpadmin @wmd etl_data] $psql-d template1 - use the gpadmin user to log in PSQL (8.2.15) Type help for help. Template1 = # create role user1 with password user1 login createdb; NOTICE: resource queue required -- using default resource queue pg_default CREATE ROLE Template1 = # \ q [gpadmin @wmd etl_data] $ - you may need to configure pg_hba.conf Step 2, create the library [gpadmin @wmd etl_data] $psql-d template1 - U user1-h WMD - use the GPS library user to log in The Password for user user1: PSQL (8.2.15) Type help for help. Template1 = Template1 = create database bi_ods_all; The CREATE DATABASE Template1 = Template1 = \ q - you may need to configure pg_hba.conf Step 3, to create a schema [gpadmin @wmd etl_data] $psql-d bi_ods_all-u user1-h 192.168.170.180 - the machine alias cant be used for IP The Password for user user1: PSQL (8.2.15) Type help for help. Bi_ods_all = create schema stage; The CREATE SCHEMA Bi_ods_all = create schema ods; The CREATE SCHEMA Bi_ods_all = \ q Step 4, authorize the user to use the external table [gpadmin @mdw gpseg - 1] $psql-d bi_ods_all-u gpadmin-h 192.168.170.180 - using the gpadmin user to authorize the user to use an external table PSQL (8.2.15) Type help for help. The bi_ods_all = # alter role user1 with createexttable (type = readable, pro