How to update catalog table in maintenance mode in Greenplum Database 4.2

Post date: Oct 05, 2012 2:11:11 PM

In Greenplum 4.2, updating the gp_segment_configuration and other catalog tables directly is not allowed. Because this action is very critical, EMC Greenplum Support must be engaged.

Follow these steps:

Start cluster in maintenance mode

gpstart -U maintenance

Note: Only superuser can connect in maintenance mode.

PGOPTIONS='-c gp_maintenance_conn=true' psql <database_name>

gptest=# show allow_system_table_mods;

allow_system_table_mods

-------------------------

DML

gptest=# show allow_segment_DML;

allow_segment_DML

-------------------

gptest=# show gp_maintenance_conn;

gp_maintenance_conn

---------------------