Starts a Greenplum Database system.
gpstart [-d <coordinator_data_directory>] [-B <parallel_processes>] [-R] [-m] [-y] [-a] [-t <timeout_seconds>] [-l <logfile_directory>] [--skip-heap-checksum-validation] [-v | -q] gpstart -? | -h | --help gpstart --version
gpstart utility is used to start the Greenplum Database server processes. When you start a Greenplum Database system, you are actually starting several
postgres database server listener processes at once (the coordinator and all of the segment instances). The
gpstart utility handles the startup of the individual instances. Each instance is started in parallel.
As part of the startup process, the utility checks the consistency of heap checksum setting among the Greenplum Database coordinator and segment instances, either enabled or deactivated on all instances. If the heap checksum setting is different among the instances, an error is returned and Greenplum Database does not start. The validation can be deactivated by specifying the option
--skip-heap-checksum-validation. For more information about heap checksums, see Enabling High Availability and Data Consistency Features in the Greenplum Database Administrator Guide.
Before you can start a Greenplum Database system, you must have initialized the system using
gpinitsystem. Enabling or deactivating heap checksums is set when you initialize the system and cannot be changed after initialization.
If the Greenplum Database system is configured with a standby coordinator, and
gpstart does not detect it during startup,
gpstart displays a warning and lets you cancel the startup operation.
-a option (deactivate interactive mode prompts) is not specified,
gpstart displays and logs these messages:
Standby host is unreachable, cannot determine whether the standby is currently acting as the coordinator. Received error: <error> Continue only if you are certain that the standby is not acting as the coordinator.
It also displays this prompt to continue startup:
Continue with startup Yy|Nn (default=N):
-a option is specified, the utility does not start the system. The messages are only logged, and
gpstart adds this log message:
Non interactive mode detected. Not starting the cluster. Start the cluster in interactive mode.
If the standby coordinator is not accessible, you can start the system and troubleshoot standby coordinator issues while the system is available.
$COORDINATOR_DATA_DIRECTORYwill be used.
PGOPTIONS='-c gp_role=utility' psql
The consistency of the heap checksum setting on coordinator and segment instances is not checked.
Starting Greenplum Database without this validation could lead to data loss. Use this option to start Greenplum Database only when it is necessary to ignore the heap checksum verification errors to recover data or to troubleshoot the errors.
postgresdatabase listener process, for example), it may take longer to start up due to the database recovery and validation process. If not specified, the default timeout is 600 seconds.
Start a Greenplum Database system:
Start a Greenplum Database system in restricted mode (only allow superuser connections):
Start the Greenplum coordinator instance only and connect in utility mode:
gpstart -m PGOPTIONS='-c gp_role=utility' psql