Stops or restarts a Greenplum Database system.
gpstop [-d <master_data_directory>] [-B <parallel_processes>] [-M smart | fast | immediate] [-t <timeout_seconds>] [-r] [-y] [-a] [-l <logfile_directory>] [-v | -q] gpstop -m [-d <master_data_directory>] [-y] [-l <logfile_directory>] [-v | -q] gpstop -u [-d <master_data_directory>] [-l <logfile_directory>] [-v | -q] gpstop --host <host_name> [-d <master_data_directory>] [-l <logfile_directory>] [-t <timeout_seconds>] [-a] [-v | -q] gpstop --version gpstop -? | -h | --help
gpstop utility is used to stop the database servers that comprise a Greenplum Database system. When you stop a Greenplum Database system, you are actually stopping several
postgres database server processes at once (the master and all of the segment instances). The
gpstop utility handles the shutdown of the individual instances. Each instance is shutdown in parallel.
By default, you are not allowed to shut down Greenplum Database if there are any client connections to the database. Use the
-M fast option to roll back all in progress transactions and terminate any connections before shutting down. If there are any transactions in progress, the default behavior is to wait for them to commit before shutting down.
-u option, the utility uploads changes made to the master
pg_hba.conf file or to runtime configuration parameters in the master
postgresql.conf file without interruption of service. Note that any active sessions will not pickup the changes until they reconnect to the database.
$MASTER_DATA_DIRECTORYwill be used.
The utility shuts down the Greenplum Database segment instances on the specified host to allow maintenance on the host. Each primary segment instance on the host is shut down and the associated mirror segment instance is promoted to a primary segment if the mirror segment is on another host. Mirror segment instances on the host are shut down.
The segment instances are not shut down and the utility returns an error in these cases:
This option cannot be specified with the
gprecoverseg utility restores segment instances. Run
gprecoverseg commands to start the segments as mirrors and then to return the segments to their preferred role (primary segments).
Immediate shut down. Any transactions in progress are aborted.
postgresprocesses without allowing the database server to complete transaction processing or clean up any temporary or in-process work files.
gpstopdisplays a message indicating that one or more segments are still in the process of shutting down and that you cannot restart Greenplum Database until the segment instance(s) are stopped. This option is useful in situations where
gpstopis executed and there are very large transactions that need to rollback. These large transactions can take over a minute to rollback and surpass the default timeout period of 600 seconds.
pg_hba.conffiles of the master and segments and the runtime parameters of the
postgresql.conffiles but does not shutdown the Greenplum Database array. Use this option to make new configuration settings active after editing
pg_hba.conf. Note that this only applies to configuration parameters that are designated as runtime parameters.
Stop a Greenplum Database system in smart mode:
Stop a Greenplum Database system in fast mode:
gpstop -M fast
Stop all segment instances and then restart the system:
Stop a master instance that was started in maintenance mode:
pg_hba.conf files after making configuration changes but do not shutdown the Greenplum Database array: