GreenPlum删除节点

最新推荐文章于 2023-05-29 10:31:25 发布

原创

最新推荐文章于 2023-05-29 10:31:25 发布 · 1.4k 阅读

本文详细介绍了如何在GreenPlum数据库中删除指定节点，包括数据库状态检查、停止数据库、从配置表中删除节点信息及重启数据库的全过程。

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 inst