Configuration Parameter Categories
These parameters control how clients connect and authenticate to Greenplum Database.
Connection and Authentication Parameters
System Resource Consumption Parameters
Query Tuning Parameters
Error Reporting and Logging Parameters
System Monitoring Parameters
Runtime Statistics Collection Parameters
Automatic Statistics Collection Parameters
Client Connection Default Parameters
Lock Management Parameters
Workload Management Parameters
External Table Parameters
Past PostgreSQL Version Compatibility Parameters
Greenplum Array Configuration Parameters
You can use pgoptions to set the configuration parameter.
Connect to the master in utility mode to do catalog maintenance. For example:
$ PGOPTIONS='-c gp_session_role=utility' psql template1
$ PGOPTIONS='-c gp_session_role=utility' psql template1
Uploading Configuration File Changes Only
The gpstop utility can upload changes to the pg_hba.conf configuration file and to runtime parameters in the master postgresql.conf file without service interruption.
Active sessions pick up changes when they reconnect to the database.
Many server configuration parameters require a full system restart (gpstop -r) to activate. For information about server configuration parameters, see the Greenplum Database Reference Guide.
To upload runtime configuration file changes without restarting
$ gpstop -u
see also gpconfig