Greenplum数据库的基本操作
1、数据库的关闭
[gpadmin@mdw ~]$ gpstop 20190506:16:16:39:053775 gpstop:mdw:gpadmin-[INFO]:-Starting gpstop with args: 20190506:16:16:39:053775 gpstop:mdw:gpadmin-[INFO]:-Gathering information and validating the environment... 20190506:16:16:39:053775 gpstop:mdw:gpadmin-[CRITICAL]:-gpstop failed. (Reason='[Errno 2] No such file or directory: '/home/gpadmin/gpadata/gpmaster/gpseg-1/postgresql.conf'') exiting...
原因：因该是找不到MASTER_DATA_DIRECTORY目录，
我们可以指定数据目录 -d ，避免这种问题
[gpadmin@mdw ~]$ gpstop -M fast -v -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -l /home/gpadmin/gpAdminLogs
gpstop -M fast ： 以快速模式关闭Greenplum数据库系统
2、数据库的启动
[gpadmin@mdw ~]$ gpstart -a -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -l /home/gpadmin/gpAdminLogs/ 20190506:16:24:55:054484 gpstart:mdw:gpadmin-[INFO]:-Starting gpstart with args: -a -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -l /home/gpadmin/gpAdminLogs/ 20190506:16:24:55:054484 gpstart:mdw:gpadmin-[INFO]:-Gathering information and validating the environment... 20190506:16:24:55:054484 gpstart:mdw:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 5.0.0 build dev' 20190506:16:24:55:054484 gpstart:mdw:gpadmin-[INFO]:-Greenplum Catalog Version: '301705051' 20190506:16:24:55:054484 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance in admin mode 20190506:16:24:56:054484 gpstart:mdw:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20190506:16:24:56:054484 gpstart:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20190506:16:24:56:054484 gpstart:mdw:gpadmin-[INFO]:-Setting new master era 20190506:16:24:56:054484 gpstart:mdw:gpadmin-[INFO]:-Master Started... 20190506:16:24:56:054484 gpstart:mdw:gpadmin-[INFO]:-Shutting down master 20190506:16:24:58:054484 gpstart:mdw:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait... .... 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:-Process results... 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:----------------------------------------------------- 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:- Successful segment starts = 12 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:- Failed segment starts = 0 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:----------------------------------------------------- 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:-Successfully started 12 of 12 segment instances 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:----------------------------------------------------- 20190506:16:25:02:054484 gpstart:mdw:gpadmin-[INFO]:-Starting Master instance mdw directory /home/gpadmin/gpdata/gpmaster/gpseg-1 20190506:16:25:03:054484 gpstart:mdw:gpadmin-[INFO]:-Command pg_ctl reports Master mdw instance active 20190506:16:25:03:054484 gpstart:mdw:gpadmin-[INFO]:-No standby master configured. skipping... 20190506:16:25:03:054484 gpstart:mdw:gpadmin-[INFO]:-Database successfully started
3、查看数据库集群的状态
[gpadmin@mdw ~]$ gpstate -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -f 20190506:16:34:27:056024 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -f 20190506:16:34:27:056024 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.0.0 build dev' 20190506:16:34:27:056024 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.0.0 build dev) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit compiled on Apr 26 2019 01:46:58 (with assert checking)' 20190506:16:34:27:056024 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20190506:16:34:28:056024 gpstate:mdw:gpadmin-[INFO]:-Standby master instance not configured 20190506:16:34:28:056024 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20190506:16:34:28:056024 gpstate:mdw:gpadmin-[INFO]:--pg_stat_replication 20190506:16:34:28:056024 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20190506:16:34:28:056024 gpstate:mdw:gpadmin-[INFO]:-No entries found. 20190506:16:34:28:056024 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- [gpadmin@mdw ~]$ gpstate -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -m 20190506:16:34:31:056066 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -m 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.0.0 build dev' 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.0.0 build dev) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit compiled on Apr 26 2019 01:46:58 (with assert checking)' 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:--Current GPDB mirror list and status 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:--Type = Group 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:-------------------------------------------------------------- 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:- Mirror Datadir Port Status Data Status 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:- sdw1 /home/gpadmin/gpdata/gpdatam1/gpseg0 53000 Passive Synchronized 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:- sdw1 /home/gpadmin/gpdata/gpdatam2/gpseg1 53001 Passive Synchronized 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:- sdw2 /home/gpadmin/gpdata/gpdatam1/gpseg2 53000 Passive Synchronized 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:- sdw2 /home/gpadmin/gpdata/gpdatam2/gpseg3 53001 Passive Synchronized 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:- mdw /home/gpadmin/gpdata/gpdatam1/gpseg4 53000 Passive Synchronized 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:- mdw /home/gpadmin/gpdata/gpdatam2/gpseg5 53001 Passive Synchronized 20190506:16:34:32:056066 gpstate:mdw:gpadmin-[INFO]:--------------------------------------------------------------
[gpadmin@mdw ~]$ gpstate -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -e 20190506:17:36:28:057823 gpstate:mdw:gpadmin-[INFO]:-Starting gpstate with args: -d /home/gpadmin/gpdata/gpmaster/gpseg-1 -e 20190506:17:36:28:057823 gpstate:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.0.0 build dev' 20190506:17:36:28:057823 gpstate:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.0.0 build dev) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit compiled on Apr 26 2019 01:46:58 (with assert checking)' 20190506:17:36:28:057823 gpstate:mdw:gpadmin-[INFO]:-Obtaining Segment details from master... 20190506:17:36:28:057823 gpstate:mdw:gpadmin-[INFO]:-Gathering data from segments... .. 20190506:17:36:30:057823 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20190506:17:36:30:057823 gpstate:mdw:gpadmin-[INFO]:-Segment Mirroring Status Report 20190506:17:36:30:057823 gpstate:mdw:gpadmin-[INFO]:----------------------------------------------------- 20190506:17:36:30:057823 gpstate:mdw:gpadmin-[INFO]:-All segments are running normally
