Gpstop waits for active user connections to disconnect and then proceeds with the shutdown. This mode kills all postgres processes without allowing the database server to complete transaction processing or clean up any temporary or in-process work files. Any transactions in progress are cancelled. Any transactions in progress are interrupted and rolled back. Shuts down a Greenplum coordinator instance that was started in maintenance mode.įast shut down. Run gprecoverseg commands to start the segments as mirrors and then to return the segments to their preferred role (primary segments). The gprecoverseg utility restores segment instances. This option cannot be specified with the -m, -r, -u, or -y options. Both a primary segment instance and its mirror are on the host.The coordinator or standby coordinator is on the host.Segment mirroring is not enabled for the system.The segment instances are not shut down and the utility returns an error in these cases: Mirror segment instances on the host are shut down. 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. The utility shuts down the Greenplum Database segment instances on the specified host to allow maintenance on the host. $COORDINATOR_DATA_DIRECTORY will be used. If not specified, the utility will start up to 64 parallel processes depending on how many segment instances it needs to stop. The number of segments to stop in parallel. Note that any active sessions will not pick up the changes until they reconnect to the database. With the -u option, the utility uploads changes made to the coordinator pg_hba.conf file or to runtime configuration parameters in the coordinator nf file without interruption of service.
Specify the -M fast shutdown mode to roll back all in-progress transactions and terminate any connections before shutting down. The default timeout period is 120 seconds and can be changed with the -t timeout\_seconds option. If any connections remain open after the timeout period, or if you interrupt with CTRL-C, gpstop lists the open connections and prompts whether to continue waiting for connections to finish, or to perform a fast or immediate shutdown. The default shutdown mode ( -M smart) waits for current client connections to finish before completing the shutdown. The gpstop utility handles the shutdown of the individual instances. When you stop a Greenplum Database system, you are actually stopping several postgres database server processes at once (the coordinator and all of the segment instances). The gpstop utility is used to stop the database servers that comprise a Greenplum Database system. Stops or restarts a Greenplum Database system.
0 kommentar(er)
