GreenPlum删除节点

最新推荐文章于 2022-07-08 07:15:09 发布
最新推荐文章于 2022-07-08 07:15:09 发布
阅读量1.1k 收藏 1
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Explorren/article/details/103636269
版权

GreenPlum删除节点

查看数据库当前状态
[gpadmin@server04 greenplum]$ gpstate
20191106:23:08:35:006912 gpstate:server04:gpadmin-[INFO]:-Starting gpstate with args: 
20191106:23:08:36:006912 gpstate:server04:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.21.3 build commit:3d56d131a82082e5f1c69ecee50177f6484ed6a4'
20191106:23:08:36:006912 gpstate:server04:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.21.3 build commit:3d56d131a82082e5f1c69ecee50177f6484ed6a4) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Aug 29 2019 17:19:21'
20191106:23:08:36:006912 gpstate:server04:gpadmin-[INFO]:-Obtaining Segment details from master...
20191106:23:08:36:006912 gpstate:server04:gpadmin-[INFO]:-Gathering data from segments...
.. 
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-Greenplum instance status summary
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-----------------------------------------------------
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Master instance                                = Active
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Master standby                                 = No master standby configured
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total segment instance count from metadata     = 15
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-----------------------------------------------------
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Primary Segment Status
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-----------------------------------------------------
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total primary segments                         = 15
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total primary segment valid (at master)        = 15
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total primary segment failures (at master)     = 0
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total number of postmaster.pid files missing   = 0
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total number of postmaster.pid files found     = 15
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs missing    = 0
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total number of postmaster.pid PIDs found      = 15
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total number of /tmp lock files missing        = 0
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total number of /tmp lock files found          = 15
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total number postmaster processes missing      = 0
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Total number postmaster processes found        = 15
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-----------------------------------------------------
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Mirror Segment Status
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-----------------------------------------------------
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-   Mirrors not configured on this array
20191106:23:08:38:006912 gpstate:server04:gpadmin-[INFO]:-----------------------------------------------------
​
关闭当前数据库
[gpadmin@server04 greenplum]$ gpstop -M fast
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-Starting gpstop with args: -M fast
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-Gathering information and validating the environment...
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-Obtaining Segment details from master...
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 5.21.3 build commit:3d56d131a82082e5f1c69ecee50177f6484ed6a4'
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:---------------------------------------------
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-Master instance parameters
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:---------------------------------------------
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   Master Greenplum instance process active PID   = 16688
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   Database                                       = template1
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   Master port                                    = 5432
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   Master directory                               = /data1/greenplum/data/master/gpseg-1
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   Shutdown mode                                  = fast
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   Timeout                                        = 120
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   Shutdown Master standby host                   = Off
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:---------------------------------------------
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-Segment instances that will be shutdown:
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:---------------------------------------------
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   Host               Datadir                                 Port   Status
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server04.novalocal   /data1/greenplum/data/primary/gpseg0    6000   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server04.novalocal   /data1/greenplum/data/primary/gpseg1    6001   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server04.novalocal   /data1/greenplum/data/primary/gpseg2    6002   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server12.novalocal   /data1/greenplum/data/primary/gpseg3    6000   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server12.novalocal   /data1/greenplum/data/primary/gpseg4    6001   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server12.novalocal   /data1/greenplum/data/primary/gpseg5    6002   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server14.novalocal   /data1/greenplum/data/primary/gpseg6    6000   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server14.novalocal   /data1/greenplum/data/primary/gpseg7    6001   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server14.novalocal   /data1/greenplum/data/primary/gpseg8    6002   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server16.novalocal   /data1/greenplum/data/primary/gpseg9    6000   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server16.novalocal   /data1/greenplum/data/primary/gpseg10   6001   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server16.novalocal   /data1/greenplum/data/primary/gpseg11   6002   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server04.novalocal   /data1/greenplum/data/primary/gpseg12   6003   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server04.novalocal   /data1/greenplum/data/primary/gpseg13   6004   u
20191106:23:10:58:008777 gpstop:server04:gpadmin-[INFO]:-   server04.novalocal   /data1/greenplum/data/primary/gpseg14   6005   u
​
Continue with Greenplum instance shutdown Yy|Nn (default=N):
> y
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-There are 5 connections to the database
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='fast'
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-Master host=172.16.0.4
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-Detected 5 connections to database
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-Switching to WAIT mode
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-Will wait for shutdown to complete, this may take some time if
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-there are a large number of active complex transactions, please wait...
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=fast
20191106:23:10:59:008777 gpstop:server04:gpadmin-[INFO]:-Master segment instance directory=/data1/greenplum/data/master/gpseg-1
20191106:23:11:00:008777 gpstop:server04:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process
20191106:23:11:00:008777 gpstop:server04:gpadmin-[INFO]:-Terminating processes for segment /data1/greenplum/data/master/gpseg-1
20191106:23:11:00:008777 gpstop:server04:gpadmin-[INFO]:-No standby master host configured
20191106:23:11:00:008777 gpstop:server04:gpadmin-[INFO]:-Targeting dbid [2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17] for shutdown
20191106:23:11:00:008777 gpstop:server04:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
20191106:23:11:00:008777 gpstop:server04:gpadmin-[INFO]:-0.00% of jobs completed
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-100.00% of jobs completed
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-----------------------------------------------------
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-   Segments stopped successfully      = 15
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-   Segments with errors during stop   = 0
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-----------------------------------------------------
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-Successfully shutdown 15 of 15 segment instances 
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-Cleaning up leftover gpmmon process
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-No leftover gpmmon process found
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-Cleaning up leftover gpsmon processes
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts
20191106:23:11:03:008777 gpstop:server04:gpadmin-[INFO]:-Cleaning up leftover shared memory
​
以管理模式启动数据库
[gpadmin@server04 greenplum]$ gpstart -m
20191106:23:12:11:009614 gpstart:server04:gpadmin-[INFO]:-Starting gpstart with args: -m
20191106:23:12:11:009614 gpstart:server04:gpadmin-[INFO]:-Gathering information and validating the environment...
20191106:23:12:11:009614 gpstart:server04:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 5.21.3 build commit:3d56d131a82082e5f1c69ecee50177f6484ed6a4'
20191106:23:12:11:009614 gpstart:server04:gpadmin-[INFO]:-Greenplum Catalog Version: '301705051'
20191106:23:12:11:009614 gpstart:server04:gpadmin-[INFO]:-Master-only start requested in configuration without a standby master.
​
Continue with master-only startup Yy|Nn (default=N):
> y
20191106:23:12:13:009614 gpstart:server04:gpadmin-[INFO]:-Starting Master instance in admin mode
20191106:23:12:15:009614 gpstart:server04:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20191106:23:12:15:009614 gpstart:server04:gpadmin-[INFO]:-Obtaining Segment details from master...
20191106:23:12:15:009614 gpstart:server04:gpadmin-[INFO]:-Setting new master era
20191106:23:12:15:009614 gpstart:server04:gpadmin-[INFO]:-Master Started...
登录管理数据库
PGOPTIONS="-c gp_session_role=utility" psql -d postgres

删除segment

 select * from gp_segment_configuration;
 
 postgres=#  select * from gp_segment_configuration;
 dbid | content | role | preferred_role | mode | status | port |     hostname     |  address   | replication_port 
------+---------+------+----------------+------+--------+------+------------------+------------+------------------
    2 |       0 | p    | p              | s    | u      | 6000 | server04.novalocal | sdw0       |                 
    5 |       3 | p    | p              | s    | u      | 6000 | server12.novalocal | sdw1       |                 
    8 |       6 | p    | p              | s    | u      | 6000 | server14.novalocal | sdw2       |                 
   11 |       9 | p    | p              | s    | u      | 6000 | server16.novalocal | sdw3       |                 
    3 |       1 | p    | p              | s    | u      | 6001 | server04.novalocal | sdw0       |                 
    6 |       4 | p    | p              | s    | u      | 6001 | server12.novalocal | sdw1       |                 
    9 |       7 | p    | p              | s    | u      | 6001 | server14.novalocal | sdw2       |                 
   12 |      10 | p    | p              | s    | u      | 6001 | server16.novalocal | sdw3       |                 
    4 |       2 | p    | p              | s    | u      | 6002 | server04.novalocal | sdw0       |                 
    7 |       5 | p    | p              | s    | u      | 6002 | server12.novalocal | sdw1       |                 
   10 |       8 | p    | p              | s    | u      | 6002 | server14.novalocal | sdw2       |                 
   13 |      11 | p    | p              | s    | u      | 6002 | server16.novalocal | sdw3       |                 
   15 |      12 | p    | p              | s    | u      | 6003 | server04.novalocal | sdw0       |                 
   16 |      13 | p    | p              | s    | u      | 6004 | server04.novalocal | sdw0       |                 
   17 |      14 | p    | p              | s    | u      | 6005 | server04.novalocal | sdw0       |                 
    1 |      -1 | p    | p              | s    | u      | 5432 | 172.16.0.4       | 172.16.0.4 |                 
(16 rows)
​
postgres=#  select * from gp_segment_configuration where hostname='server04.novalocal';
 dbid | content | role | preferred_role | mode | status | port |     hostname     | address | replication_port 
------+---------+------+----------------+------+--------+------+------------------+---------+------------------
    2 |       0 | p    | p              | s    | u      | 6000 | server04.novalocal | sdw0    |                 
    3 |       1 | p    | p              | s    | u      | 6001 | server04.novalocal | sdw0    |                 
    4 |       2 | p    | p              | s    | u      | 6002 | server04.novalocal | sdw0    |                 
   15 |      12 | p    | p              | s    | u      | 6003 | server04.novalocal | sdw0    |                 
   16 |      13 | p    | p              | s    | u      | 6004 | server04.novalocal | sdw0    |                 
   17 |      14 | p    | p              | s    | u      | 6005 | server04.novalocal | sdw0    |                 
(6 rows)
​
postgres=#  select * from gp_segment_configuration where hostname!='server04.novalocal';
 dbid | content | role | preferred_role | mode | status | port |     hostname     |  address   | replication_port 
------+---------+------+----------------+------+--------+------+------------------+------------+------------------
    5 |       3 | p    | p              | s    | u      | 6000 | server12.novalocal | sdw1       |                 
    8 |       6 | p    | p              | s    | u      | 6000 | server14.novalocal | sdw2       |                 
   11 |       9 | p    | p              | s    | u      | 6000 | server16.novalocal | sdw3       |                 
    6 |       4 | p    | p              | s    | u      | 6001 | server12.novalocal | sdw1       |                 
    9 |       7 | p    | p              | s    | u      | 6001 | server14.novalocal | sdw2       |                 
   12 |      10 | p    | p              | s    | u      | 6001 | server16.novalocal | sdw3       |                 
    7 |       5 | p    | p              | s    | u      | 6002 | server12.novalocal | sdw1       |                 
   10 |       8 | p    | p              | s    | u      | 6002 | server14.novalocal | sdw2       |                 
   13 |      11 | p    | p              | s    | u      | 6002 | server16.novalocal | sdw3       |                 
    1 |      -1 | p    | p              | s    | u      | 5432 | 172.16.0.4       | 172.16.0.4 | 
    
    
    postgres=# select * from pg_filespace_entry ;
 fsefsoid | fsedbid |              fselocation              
----------+---------+---------------------------------------
     3052 |       2 | /data1/greenplum/data/primary/gpseg0
     3052 |       5 | /data1/greenplum/data/primary/gpseg3
     3052 |       8 | /data1/greenplum/data/primary/gpseg6
     3052 |      11 | /data1/greenplum/data/primary/gpseg9
     3052 |       3 | /data1/greenplum/data/primary/gpseg1
     3052 |       6 | /data1/greenplum/data/primary/gpseg4
     3052 |       9 | /data1/greenplum/data/primary/gpseg7
     3052 |      12 | /data1/greenplum/data/primary/gpseg10
     3052 |       4 | /data1/greenplum/data/primary/gpseg2
     3052 |       7 | /data1/greenplum/data/primary/gpseg5
     3052 |      10 | /data1/greenplum/data/primary/gpseg8
     3052 |      13 | /data1/greenplum/data/primary/gpseg11
     3052 |      15 | /data1/greenplum/data/primary/gpseg12
     3052 |      16 | /data1/greenplum/data/primary/gpseg13
     3052 |      17 | /data1/greenplum/data/primary/gpseg14
     3052 |       1 | /data1/greenplum/data/master/gpseg-1
​
设置操作权限
set allow_system_table_mods='dml';
删除节点
delete from gp_segment_configuration where dbid in (2,3,4,15,16,17);
delete from pg_filespace_entry where fsedbid in (2,3,4,15,16,17);  
postgres=#  select * from gp_segment_configuration;
 dbid | content | role | preferred_role | mode | status | port |     hostname     |  address   | replication_port 
------+---------+------+----------------+------+--------+------+------------------+------------+------------------
    5 |       3 | p    | p              | s    | u      | 6000 | server12.novalocal | sdw1       |                 
    8 |       6 | p    | p              | s    | u      | 6000 | server14.novalocal | sdw2       |                 
   11 |       9 | p    | p              | s    | u      | 6000 | server16.novalocal | sdw3       |                 
    6 |       4 | p    | p              | s    | u      | 6001 | server12.novalocal | sdw1       |                 
    9 |       7 | p    | p              | s    | u      | 6001 | server14.novalocal | sdw2       |                 
   12 |      10 | p    | p              | s    | u      | 6001 | server16.novalocal | sdw3       |                 
    7 |       5 | p    | p              | s    | u      | 6002 | server12.novalocal | sdw1       |                 
   10 |       8 | p    | p              | s    | u      | 6002 | server14.novalocal | sdw2       |                 
   13 |      11 | p    | p              | s    | u      | 6002 | server16.novalocal | sdw3       |                 
    1 |      -1 | p    | p              | s    | u      | 5432 | 172.16.0.4       | 172.16.0.4 |
gpstart报错
gpstop -m
​
[gpadmin@server04 greenplum]$ gpstart
20191106:23:33:24:019409 gpstart:server04:gpadmin-[INFO]:-Starting gpstart with args: 
20191106:23:33:24:019409 gpstart:server04:gpadmin-[INFO]:-Gathering information and validating the environment...
20191106:23:33:25:019409 gpstart:server04:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 5.21.3 build commit:3d56d131a82082e5f1c69ecee50177f6484ed6a4'
20191106:23:33:25:019409 gpstart:server04:gpadmin-[INFO]:-Greenplum Catalog Version: '301705051'
20191106:23:33:25:019409 gpstart:server04:gpadmin-[INFO]:-Starting Master instance in admin mode
20191106:23:33:26:019409 gpstart:server04:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20191106:23:33:26:019409 gpstart:server04:gpadmin-[INFO]:-Obtaining Segment details from master...
20191106:23:33:26:019409 gpstart:server04:gpadmin-[INFO]:-Setting new master era
20191106:23:33:26:019409 gpstart:server04:gpadmin-[INFO]:-Master Started...
20191106:23:33:26:019409 gpstart:server04:gpadmin-[CRITICAL]:-gpstart failed. (Reason=''NoneType' object has no attribute 'hostname'') exiting...
​
联系节点
postgres=# update gp_segment_configuration set content=content-3 where content!=-1;
ERROR:  operator does not exist: smallint !=- integer
LINE 1: ...gment_configuration set content=content-3 where content!=-1;
                                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
postgres=# update gp_segment_configuration set content=content-3 where dbid!=1;
UPDATE 9
postgres=# select * from gp_segment_configuration;
 dbid | content | role | preferred_role | mode | status | port |     hostname     |  address   | replication_port 
------+---------+------+----------------+------+--------+------+------------------+------------+------------------
    1 |      -1 | p    | p              | s    | u      | 5432 | 172.16.0.4       | 172.16.0.4 |                 
    5 |       0 | p    | p              | s    | u      | 6000 | server12.novalocal | sdw1       |                 
    8 |       3 | p    | p              | s    | u      | 6000 | server14.novalocal | sdw2       |                 
   11 |       6 | p    | p              | s    | u      | 6000 | server16.novalocal | sdw3       |                 
    6 |       1 | p    | p              | s    | u      | 6001 | server12.novalocal | sdw1       |                 
    9 |       4 | p    | p              | s    | u      | 6001 | server14.novalocal | sdw2       |                 
   12 |       7 | p    | p              | s    | u      | 6001 | server16.novalocal | sdw3       |                 
    7 |       2 | p    | p              | s    | u      | 6002 | server12.novalocal | sdw1       |                 
   10 |       5 | p    | p              | s    | u      | 6002 | server14.novalocal | sdw2       |                 
   13 |       8 | p    | p              | s    | u      | 6002 | server16.novalocal | sdw3       |
重启节点
gpstop -m
gpstart
Explorren
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
Greenplum清除mirror
12-03
可以作为greenplummirror的参考，注意脚本内容和实际环境的区别，注意关注数据完整性。
greenplum6单机版gpstart失败【已解决】
DBMS_OUTPUT666的博客
06-16 652
greenplum6单机版gpstart失败【已解决】
记一次Greenplum出现崩溃的问题
小海绵的博客
10-25 1454
时间：2019年10月25日星期五 问题描述： 数据入库程序报错，提示数据库链接失败，远程连接至数据库服务器，发现gp服务未启动 解决方案： 首先尝试使用gpstate命令查看数据库服务，之后尝试停止数据库，但提示如下，提示空间不足： 20191025:07:42:28:162755 gpstate:default-[CRITICAL]:-gpstate failed....
gpstart failed (reason=‘‘) exiting... 报错不显示原因
qq_40906612的博客
07-02 1145
注意修改文件所在地址为自己的地址
报错: 后端报 AttributeError: ‘NoneType‘ object has no attribute ‘get‘ 原因
weixin_69282446的博客
05-12 7658
报错信息 错误代码 原因 获取前端数据时错误, 可能前端提交的是一个’coupons’列表. 但出现AttributeError: 'NoneType' object has no attribute 'get'报错时, 我们直接获取’coupons’下的具体字段就可以了
Greenplum【问题 03】6.13.0单机版重启实录（5次报错问题及解决的避坑指南+日志文件查看方法）
Java与大数据相关实践内容分享！
09-01 2555
Greenplum【问题记录 03】6.13.0单机版重启实录（5次报错问题及解决的避坑指南+日志文件查看方法）
greenplum的驱动
05-19
gP驱动包，可以应用在datagrip等，哈哈哈哈，非常好用
greenplum 集群Master 增加Standby 节点
05-14
greenplum 集群Master 增加Standby 节点
greenplum jdbc driver
08-24
greenplum jdbc driver
greenplum数据库jdbc驱动下载
11-04
greenplum数据库jdbc驱动下载 版本：greenplum-jdbc-5.1.4.jar
Greenplum搭建问题汇总
小海绵的博客
05-26 2096
1. http://greenplum.org/install-greenplum-oss-on-ubuntu/ 单机版官网安装过程，比较简单，但是按照这个过程安装不出来，在安装过程中还参考另外一篇文档，https://blog.csdn.net/doctor_who2004/article/details/43372963。 2. 安装过程中，报错： 20180403:16:03:50:...
Greenplum 激活standby master失败后的异常修复
我的Oracle DBA之路
03-09 2261
Greenplum 激活standby master失败后的异常修复https://m.aliyun.com/yunqi/articles/263激活standby master失败后，主库和备库都起不来了。如下，修改了MASTER_DATA_DIRECTORY和PGPORT环境变量为新的主库，启动主库。$gpstart -a20151222:16:49:41:073138 gpstart:dig...
greenplum修改参数导致无法启动
ckqq46580的博客
10-20 643
修改参数share_buffer gpconfig -c shared_buffers -v 1536MB 重启使内存参数生效 [gpadmin@gp-master ~]$ gpstop -M fast ......
GreenPlum集群安装
雅冰石的专栏
03-29 1349
1.1 GreemPlum架构 正常情况下只有primary master接受用户连接请求，standby master通过gpsyncagent进程（运行在standby master上）利用事务日志保持与primary master的同步。 segment崩溃时正在运行的事务会全部失败。 mirror会自动接管服务而无需人工干预，接管过程中会有几...
已解决AttributeError: ‘NoneType‘ object has no attribute ‘group‘
努力让自己发光，对的人才能迎着光而来
07-08 1万+
已解决（Python正则匹配报错）AttributeError: 'NoneType' object has no attribute 'group'
Greenplum移除节点
weixin_34101229的博客
05-16 1388
基于某某原因，我们的Greenplum需要卸载一个节点（测试环境的Greenplum集群），由于该集群使用了很久，里面有许多开发所需要的数据，所以在卸掉一个节点后，还要保证数据不会丢失。 经过搜索，在以下站点找到了解决方案1）https://gp-docs-cn.github.io/docs/admin_guide/managing/restore-diff-system.html 2）https...
greenplum的扩容（4）-删除数据节点
aabc012的博客
05-12 3757
greenplum中的数据节点也是可以删除减少的。 现删除增加的1组主备节点。
greenplum常见问题及解决方法
热门推荐
q936889811的博客
01-02 4万+
文章目录1、错误：数据库初始化：gpinitsystem -c gpconfigs/gpinitsystem_config -h list2、错误 ：执行检查：gpcheck -f list3、错误：gpadmin-[CRITICAL]:-gpstate failed. (Reason='Environment Variable MASTER_DATA_DIRECTORY not set!') e...
greenplum如何删除segment节点
DreamDB的专栏
04-20 2781
环境信息： Red Hat Enterprise Linux Server release 7.5 (Maipo) Greenplum Database 5.16.0 [gpadmin@rhmdw gpadata]$ cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdo...
greenplum 单节点部署
最新发布
06-09
Greenplum 通常用于分布式部署，但也可以在单节点上部署。以下是 Greenplum 单节点部署的步骤： 1. 下载和安装 Greenplum：从官方网站下载 Greenplum 软件包，并在单节点上解压和安装。 2. 配置环境变量：设置 Greenplum 软件的环境变量，包括 PATH、GPHOME、GPDATA 等。可以在 ~/.bashrc 或者 ~/.bash_profile 文件中设置环境变量。 3. 创建数据库实例：使用 Greenplum 提供的命令创建数据库实例。可以使用命令行工具或者 gpmctl 工具创建数据库实例。 4. 初始化数据库：使用 initdb 命令初始化数据库。可以使用 -D 选项指定数据库实例的目录。 5. 启动数据库：使用 gpstart 命令启动数据库实例，并检查数据库的运行状态。 6. 测试数据库：连接到数据库实例并运行一些 SQL 命令，测试数据库的性能和功能。 需要注意的是，在单节点部署中，Greenplum 的性能可能不如分布式部署，因为所有的数据都存储在单个节点上。因此，单节点部署主要用于测试和开发环境，而对于生产环境还是推荐使用分布式部署。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值