在Docker中快速体验GreenPlum 7.0.0

docker rm -f gpdb7
docker run -itd --name gpdb7 -h gpdb7 \
  -p 5436:5432 -p 28086:28080  \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true lhrbest/greenplum:7.0.0 \
  /usr/sbin/init


docker exec -it gpdb7 bash
su - gpadmin
gpstart -a
gpcc start

gpcc status
gpstate 

[root@gpdb7 /]# su - gpadmin
Last login: Fri Jul 21 16:42:55 CST 2023 on pts/1
[gpadmin@gpdb7 ~]$ 
[gpadmin@gpdb7 ~]$ 
[gpadmin@gpdb7 ~]$ gpstart -a
20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting gpstart with args: -a
20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Gathering information and validating the environment...
20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source'
20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Catalog Version: '302306121'
20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance in admin mode
20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-CoordinatorStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /opt/greenplum/data/master/gpseg-1 -l /opt/greenplum/data/master/gpseg-1/log/startup.log -w -t 600 -o " -c gp_role=utility " start
20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Greenplum Coordinator catalog information
20230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator...
20230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Setting new coordinator era
20230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Coordinator Started...
20230721:16:45:02:001025 gpstart:gpdb7:gpadmin-[INFO]:-Shutting down coordinator
20230721:16:45:05:001025 gpstart:gpdb7:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Process results...
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Successful segment starts                                            = 4
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Failed segment starts                                                = 0
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Successfully started 4 of 4 segment instances 
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance gpdb7 directory /opt/greenplum/data/master/gpseg-1 
20230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-CoordinatorStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=cbcbcc7d30fa4b35_230721164501 $GPHOME/bin/pg_ctl -D /opt/greenplum/data/master/gpseg-1 -l /opt/greenplum/data/master/gpseg-1/log/startup.log -w -t 600 -o " -c gp_role=dispatch " start
20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Command pg_ctl reports Coordinator gpdb7 instance active
20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Connecting to db template1 on host localhost
20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting standby coordinator
20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Checking if standby coordinator is running on host: gpdb7  in directory: /opt/greenplum/data/master_standby/gpseg-1
20230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-CoordinatorStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=cbcbcc7d30fa4b35_230721164501 $GPHOME/bin/pg_ctl -D /opt/greenplum/data/master_standby/gpseg-1 -l /opt/greenplum/data/master_standby/gpseg-1/log/startup.log -t 600 -o " -c gp_role=dispatch " start
20230721:16:45:12:001025 gpstart:gpdb7:gpadmin-[INFO]:-Database successfully started

[gpadmin@gpdb7 ~]$ gpstate -e
20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Starting gpstate with args: -e
20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source'
20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-coordinator Greenplum Version: 'PostgreSQL 12.12 (Greenplum Database 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit compiled on Jun 15 2023 01:11:10 Bhuvnesh C.'
20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator...
20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Gathering data from segments...
20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
20230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Segment Mirroring Status Report
20230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
20230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:-All segments are running normally
[gpadmin@gpdb7 ~]$ 

[gpadmin@gpdb7 ~]$ psql
psql (12.12)
Type "help" for help.

postgres=# select * from gp_segment_configuration order by 1,3 ;
 dbid | content | role | preferred_role | mode | status | port | hostname | address |                  datadir                   
------+---------+------+----------------+------+--------+------+----------+---------+--------------------------------------------
    1 |      -1 | p    | p              | n    | u      | 5432 | gpdb7    | gpdb7   | /opt/greenplum/data/master/gpseg-1
    2 |       0 | p    | p              | s    | u      | 6000 | gpdb7    | gpdb7   | /opt/greenplum/data/primary/gpseg0
    3 |       1 | p    | p              | s    | u      | 6001 | gpdb7    | gpdb7   | /opt/greenplum/data/primary/gpseg1
    4 |       0 | m    | m              | s    | u      | 7000 | gpdb7    | gpdb7   | /opt/greenplum/data/mirror/gpseg0
    5 |       1 | m    | m              | s    | u      | 7001 | gpdb7    | gpdb7   | /opt/greenplum/data/mirror/gpseg1
    6 |      -1 | m    | m              | s    | u      | 5433 | gpdb7    | gpdb7   | /opt/greenplum/data/master_standby/gpseg-1
(6 rows)

postgres=# select version();
                                                                                                                          version                                                                                                                          
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 12.12 (Greenplum Database 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit compiled on Jun 15 2023 01:11:10 Bhuvnesh C.
(1 row)

postgres=# \q