On Sun, Mar 6, 2011 at 5:02 PM, Yeb Havinga <yebhavi...@gmail.com> wrote: > On Sun, Mar 6, 2011 at 8:58 AM, Fujii Masao <masao.fu...@gmail.com> wrote: >> >> If unfortunately all connection slots are used by backends waiting for >> replication, we cannot execute such a function. So it makes more sense >> to introduce something like "pg_ctl standalone" command? > > If it is only for shutdown, maybe pg_ctl stop -m standalone?
It's for not only shutdown but also running the primary in standalone mode. So something like "pg_ctl standalone" is better. For now I think that pg_ctl command is better than built-in function because sometimes we might want to wake waiters up even during shutdown in order to cause shutdown to end. During shutdown, the server doesn't accept any new connection (even from the standby). So, without something like "pg_ctl standalone", there is no way to cause shutdown to end. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
