Re: Connection slots reserved for replication - Mailing list pgsql-hackers

From Oleksii Kliukin
Subject Re: Connection slots reserved for replication
Date
Msg-id DE372F7B-8703-4B24-9BB6-CCF9B9F611CC@hintbits.com
Whole thread Raw
In response to Re: Connection slots reserved for replication  (Alexander Kukushkin <cyberdemn@gmail.com>)
Responses Re: Connection slots reserved for replication  (Petr Jelinek <petr.jelinek@2ndquadrant.com>)
List pgsql-hackers
> On 30. Nov 2018, at 13:58, Alexander Kukushkin <cyberdemn@gmail.com> wrote:
>
> attaching the new version of the patch.
> Now it simply reserves max_wal_senders slots in the ProcGlobal, what
> guarantees that only walsender process could use them.

With this patch It looks like InitProcess will trigger the generic error about 'too many clients' before the more
specificerror message in InitWalSenderSlot when exceeding the number of max_wal_senders. 

Does excluding WAL senders from the max_connections limit and including max_wal_senders in MaxBackends also imply that
weneed to add max_wal_senders to the list at xlog.c: CheckRequiredParameterValues, requiring its value on the replica
tobe not lower than the one on the primary?  

Cheers,
Oleksii

pgsql-hackers by date:

Previous
From: Julien Demoor
Date:
Subject: Re: NOTIFY and pg_notify performance when deduplicating notifications
Next
From: Alvaro Herrera
Date:
Subject: Re: don't mark indexes invalid unnecessarily