On Thu, Apr 1, 2010 at 11:00 AM, Robert Haas <robertmh...@gmail.com> wrote: > On Wed, Mar 31, 2010 at 9:58 PM, Fujii Masao <masao.fu...@gmail.com> wrote: >> On Thu, Apr 1, 2010 at 10:52 AM, Robert Haas <robertmh...@gmail.com> wrote: >>> On Wed, Mar 31, 2010 at 9:50 PM, Fujii Masao <masao.fu...@gmail.com> wrote: >>>>> That's an interesting point, do streaming replication connections >>>>> consume superuser_reserved_connections slots? >>>> >>>> Yes. Since SR connection is superuser connection, setting >>>> superuser_reserved_connections appropriately would be useful >>>> to prevent non-superuser connections from blocking the connection >>>> from the standby. >>> >>> I think this is wacky, especially since we'd someday like to have >>> replication be a separate privilege from superuser. I think we should >>> change this. >> >> You mean that we should change replication connection not to consume >> superuser_reserved_connections slots in 9.0? > > Yes.
Preventing superuser connections from consuming superuser_reserved_connections slots seems strange for me. So I'm leaning toward just removing superuser privilege from replication connection again. Thought? 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
