Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Streaming replication document improvements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-docs(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Streaming replication document improvements
Date: 2010-04-20 23:53:36
Message-ID: 7978.1271807616@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> Current logic says we hit the connection limit if:

>         if (!am_superuser &&
>                 ReservedBackends > 0 &&
>                 !HaveNFreeProcs(ReservedBackends))

> Couldn't we just change this to:

>         if ((!am_superuser || am_walsender) &&
>                 ReservedBackends > 0 &&
>                 !HaveNFreeProcs(ReservedBackends))

As of the patch I just committed, that code is not reached anymore by a
walsender process.  However, it shouldn't be hard to put a similar test
into the walsender code path.

			regards, tom lane

In response to

Responses

pgsql-docs by date

Next:From: Fujii MasaoDate: 2010-04-21 01:40:09
Subject: Re: [HACKERS] Streaming replication document improvements
Previous:From: Jim NasbyDate: 2010-04-20 23:34:00
Subject: Inconsistency in docs for OVERLAPS

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-04-21 01:03:53
Subject: Re: Move tablespace
Previous:From: Robert HaasDate: 2010-04-20 23:49:24
Subject: Re: Should database = all in pg_hba.conf match a replication connection?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group