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


Log in to the database using maintenance connection

Note: Only superuser can connect in maintenance mode.

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

gptest=# show allow_system_table_mods;




gptest=# show allow_segment_DML;




gptest=# show gp_maintenance_conn;