Re: [HACKERS] Streaming replication document improvements
Kevin Grittner <kevin.grittner@wicourts.gov>
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Robert Haas" <robertmhaas@gmail.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Josh Berkus" <josh@agliodbs.com>, "Heikki Linnakangas" <heikki.linnakangas@enterprisedb.com>, "Fujii Masao" <masao.fujii@gmail.com>, <pgsql-docs@postgresql.org>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2010-04-20T14:24:38Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote: > Robert Haas <robertmhaas@gmail.com> writes: >> Fujii Masao <masao.fujii@gmail.com> wrote: >>> 3. Your proposal >>> Treat superuser replication connection like non-superuser one > >> Well, only for this one very specific purpose. I would adjust >> the docs like this: > >> Determines the number of connection "slots" that are reserved for >> connections by PostgreSQL superusers. At most max_connections >> connections can ever be active simultaneously. Whenever the >> number of active concurrent connections is at least >> max_connections minus superuser_reserved_connections, new >> connections will be accepted only for superusers, and no new >> replication connections will be accepted. > >> I think that's pretty simple and clear. > > +1. I'm not sure about the consequences of converting walsender > to non-superuser across the board, and would prefer not to > experiment with it at this stage of the release cycle. +1 -Kevin