Postgres Database Startup Parameters

Source: Internet
Author: User
Tags sessions postgres database
  1. SIGTERM

  2. New connections are no longer allowed, but all active sessions are allowed to complete their work properly, and are closed only after all sessions have completed the task. This is smart off.

  3. SIGINT

  4. No new connections are allowed, send SIGTERM to all active servers (let them exit immediately), and wait for all child processes to exit and close the database. This is quick to close.

  5. Sigquit

  6. Causes Postgres to send sigquit to all child processes and exits immediately (all child processes also exit immediately) without properly shutting down the database system. This is immediately closed. Doing so causes a recovery at the next startup (by replaying the WAL log). We recommend using this method only in case of emergency.

  7. SIGKILL

  8. This option is not used as much as possible, which prevents the server from cleaning up shared memory and beacon resources, so you can do it manually before you start the server. In addition, SIGKILL directly kills the postgres without waiting for it to relay the signal to its sub-processes, so we also need to manually kill each individual child process.


Postgres Database Startup Parameters

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.