question on Postgres smart shutdown mode

Started by Bo Tianalmost 11 years ago2 messages
#1Bo Tian
B.Tian@F5.com

Hi All,

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.

Thanks,
Bo

#2Jim Nasby
Jim.Nasby@BlueTreble.com
In reply to: Bo Tian (#1)
Re: [HACKERS] question on Postgres smart shutdown mode

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general