环境配置
地址:https://hub.docker.com/r/lhrbest/greenplum/tags
1docker rm -f gpdb7
2docker run -itd --name gpdb7 -h gpdb7 \
3 -p 5436:5432 -p 28086:28080 \
4 -v /sys/fs/cgroup:/sys/fs/cgroup \
5 --privileged=true lhrbest/greenplum:7.0.0 \
6 /usr/sbin/init
7
8
9docker exec -it gpdb7 bash
10su - gpadmin
11gpstart -a
12gpcc start
13
14gpcc status
15gpstate
此docker包括1个master,1个standby master,2个segment,2个mirror实例。
示例:
1[root@gpdb7 /]# su - gpadmin
2Last login: Fri Jul 21 16:42:55 CST 2023 on pts/1
3[gpadmin@gpdb7 ~]$
4[gpadmin@gpdb7 ~]$
5[gpadmin@gpdb7 ~]$ gpstart -a
620230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting gpstart with args: -a
720230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Gathering information and validating the environment...
820230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source'
920230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Greenplum Catalog Version: '302306121'
1020230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance in admin mode
1120230721: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
1220230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Greenplum Coordinator catalog information
1320230721:16:45:00:001025 gpstart:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator...
1420230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Setting new coordinator era
1520230721:16:45:01:001025 gpstart:gpdb7:gpadmin-[INFO]:-Coordinator Started...
1620230721:16:45:02:001025 gpstart:gpdb7:gpadmin-[INFO]:-Shutting down coordinator
1720230721:16:45:05:001025 gpstart:gpdb7:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait...
1820230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Process results...
1920230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-
2020230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
2120230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:- Successful segment starts = 4
2220230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:- Failed segment starts = 0
2320230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
2420230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
2520230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Successfully started 4 of 4 segment instances
2620230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
2720230721:16:45:06:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting Coordinator instance gpdb7 directory /opt/greenplum/data/master/gpseg-1
2820230721: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
2920230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Command pg_ctl reports Coordinator gpdb7 instance active
3020230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Connecting to db template1 on host localhost
3120230721:16:45:10:001025 gpstart:gpdb7:gpadmin-[INFO]:-Starting standby coordinator
3220230721: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
3320230721: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
3420230721:16:45:12:001025 gpstart:gpdb7:gpadmin-[INFO]:-Database successfully started
35
36[gpadmin@gpdb7 ~]$ gpstate -e
3720230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Starting gpstate with args: -e
3820230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 7.0.0-beta.4 build commit:f3782c6dd89c9b6565a84518174ed4dd448f3293 Open Source'
3920230721: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.'
4020230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Obtaining Segment details from coordinator...
4120230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Gathering data from segments...
4220230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
4320230721:16:55:56:005067 gpstate:gpdb7:gpadmin-[INFO]:-Segment Mirroring Status Report
4420230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:-----------------------------------------------------
4520230721:16:55:57:005067 gpstate:gpdb7:gpadmin-[INFO]:-All segments are running normally
46[gpadmin@gpdb7 ~]$
47
GreenPlum使用
1[gpadmin@gpdb7 ~]$ psql
2psql (12.12)
3Type "help" for help.
4
5postgres=# select * from gp_segment_configuration order by 1,3 ;
6 dbid | content | role | preferred_role | mode | status | port | hostname | address | datadir
7------+---------+------+----------------+------+--------+------+----------+---------+--------------------------------------------
8 1 | -1 | p | p | n | u | 5432 | gpdb7 | gpdb7 | /opt/greenplum/data/master/gpseg-1
9 2 | 0 | p | p | s | u | 6000 | gpdb7 | gpdb7 | /opt/greenplum/data/primary/gpseg0
10 3 | 1 | p | p | s | u | 6001 | gpdb7 | gpdb7 | /opt/greenplum/data/primary/gpseg1
11 4 | 0 | m | m | s | u | 7000 | gpdb7 | gpdb7 | /opt/greenplum/data/mirror/gpseg0
12 5 | 1 | m | m | s | u | 7001 | gpdb7 | gpdb7 | /opt/greenplum/data/mirror/gpseg1
13 6 | -1 | m | m | s | u | 5433 | gpdb7 | gpdb7 | /opt/greenplum/data/master_standby/gpseg-1
14(6 rows)
15
16postgres=# select version();
17 version
18-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
19 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.
20(1 row)
21
22postgres=# \q
23
总结
1、需要rhel8
2、需要python 3.9
3、gpcc 6.9版本不支持GP7
参考
https://www.xmmup.com/greenplum7danjianzhuang.html
https://www.xmmup.com/greenplum-6-danjianzhuang.html
https://www.xmmup.com/yitiaominglingkuaisuqidonggreenplum.html
https://www.xmmup.com/mppjiagouzhigreenplumdeanzhuangpeizhigaojiban.html
https://www.xmmup.com/greenplumguanfangjiankonggongjugpccjianjiejishiyong.html
https://www.xmmup.com/greenplumguanfangjiankonggongjugpcc-6deanzhuanghexiezai.html