Обсуждение: question on Postgres smart shutdown mode

Поиск
Список
Период
Сортировка

question on Postgres smart shutdown mode

От
wei sun
Дата:
<p class="MsoNormal" style="margin:0in 0in 0.0001pt"><font><span style="background-color:rgba(255,255,255,0)">Hi
All,</span></font><pclass="MsoNormal" style="margin:0in 0in 0.0001pt"><font> </font><p class="MsoNormal"
style="margin:0in0in 0.0001pt"><font><span style="background-color:rgba(255,255,255,0)">I have a question on PG smart
shutdownmode.</span></font><p class="MsoNormal" style="margin:0in 0in 0.0001pt"><font><span
style="background-color:rgba(255,255,255,0)">Whenshutdown Postgres by issuing <i>Smart Shutdown </i>mode
(SIGTERM) request,is there a way for client to be notified of this shutdown event? I tried PG_NOTIFY, but I cannot get
anynotification events when this happens. BTW, I am relative new to Postgres.</span></font><p class="MsoNormal"
style="margin:0in0in 0.0001pt"><font> </font><p class="MsoNormal" style="margin:0in 0in 0.0001pt"><font><span
style="background-color:rgba(255,255,255,0)">Thanks,</span></font><pclass="MsoNormal" style="margin:0in 0in
0.0001pt"><font><spanstyle="style">Wei</span></font> 

Re: question on Postgres smart shutdown mode

От
Robert Haas
Дата:
On Fri, Feb 13, 2015 at 2:15 AM, wei sun <wei.sun.ws@gmail.com> 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.

Unfortunately, no, there isn't a way for the client to be notified.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company