Re: [HACKERS] question on Postgres smart shutdown mode

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Bo Tian <B(dot)Tian(at)F5(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [HACKERS] question on Postgres smart shutdown mode
Date: 2015-02-13 22:33:05
Message-ID: 54DE7BA1.1060908@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 2/12/15 5:46 PM, Bo Tian wrote:
> I have a question on PG smart shutdown mode.
>
> When shutdown Postgres by issuing /Smart Shutdown /mode
> (SIGTERM) request, is there a way for client to be notified of this
> shutdown event? I tried PG_NOTIFY, but I cannot get any
> notification events when this happens. BTW, I am relative new to Postgres.

-hackers is for development of PostgreSQL, not general questions. I'm
moving this to -general.

To answer your question, I don't believe there's any way to get
notification. At least, grepping for shutdown in src/backend doesn't
turn up anything obvious.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2015-02-13 22:56:31 Re: What's a reasonable maximum number for table partitions?
Previous Message Tim Uckun 2015-02-13 22:27:52 Re: What's a reasonable maximum number for table partitions?

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2015-02-13 22:33:35 Re: "multiple backends attempting to wait for pincount 1"
Previous Message Robert Haas 2015-02-13 22:18:20 Re: question on Postgres smart shutdown mode