Add note on hawq stop -u -M fast
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/56a046dc Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/56a046dc Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/56a046dc Branch: refs/heads/tutorial-proto Commit: 56a046dc0a8be0d52d4c667a103528fe1aaa4a73 Parents: e169704 Author: Jane Beckman <[email protected]> Authored: Wed Oct 19 16:15:08 2016 -0700 Committer: Jane Beckman <[email protected]> Committed: Wed Oct 19 16:15:08 2016 -0700 ---------------------------------------------------------------------- admin/startstop.html.md.erb | 6 ++++++ reference/cli/admin_utilities/hawqstop.html.md.erb | 1 + 2 files changed, 7 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/56a046dc/admin/startstop.html.md.erb ---------------------------------------------------------------------- diff --git a/admin/startstop.html.md.erb b/admin/startstop.html.md.erb index 5c07f96..0cc7539 100644 --- a/admin/startstop.html.md.erb +++ b/admin/startstop.html.md.erb @@ -147,6 +147,12 @@ For best results in using `hawq start` and `hawq stop` to manage your HAWQ syste $ hawq stop master -M fast $ hawq stop master -M immediate ``` +- If you want to reload server parameter setting on a HAWQ database where there are active connections, use the command: + + + ```shell + $ hawq stop master -u -M fast + ``` - When stopping a segment or all segments, you can use the default mode of smart mode. Using fast or immediate mode on segments will have no effect since segments are stateless. http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/56a046dc/reference/cli/admin_utilities/hawqstop.html.md.erb ---------------------------------------------------------------------- diff --git a/reference/cli/admin_utilities/hawqstop.html.md.erb b/reference/cli/admin_utilities/hawqstop.html.md.erb index a5ba297..67ced1c 100644 --- a/reference/cli/admin_utilities/hawqstop.html.md.erb +++ b/reference/cli/admin_utilities/hawqstop.html.md.erb @@ -23,6 +23,7 @@ The `hawq stop` utility is used to stop the database servers that comprise a HAW By default, you are not allowed to shut down HAWQ 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. With the `-u` option, the utility uploads changes made to the master `pg_hba.conf` file or to *runtime* configuration parameters in the master `hawq-site.xml` file without interruption of service. Note that any active sessions will not pick up the changes until they reconnect to the database. +When active connections to the database are present, use the command `hawq stop cluster -u -M fast` to ensure that changes to the parameters are reloaded. ## Objects
