Re: Patch for reserved connections for replication users - Mailing list pgsql-hackers

From Gibheer
Subject Re: Patch for reserved connections for replication users
Date
Msg-id 20130730091001.6abce68f@linse.fritz.box
Whole thread Raw
In response to Patch for reserved connections for replication users  (Gibheer <gibheer@zero-knowledge.org>)
Responses Re: Patch for reserved connections for replication users
List pgsql-hackers
Hi,

here is an update off my patch based on the discussion with Marko
Tiikkaja and Andres Freund.

Marko and I had the idea of introducing reserved connections based on
roles as it would create a way to garantuee specific roles to connect
when other roles use up all connections for whatever reason. But
Andreas said, that it would make connecting take much too long.

So to just fix the issue at hand, we decided that adding
max_wal_senders to the pool of reserved connections is better. With
that, we are sure that streaming replication can connect to the master.

So instead of creating a new configuration option I added
max_wal_senders to the reserved connections and changed the check for
new connections.

The test.pl is a small script to test, if the patch does what it should.

regards,

Stefan Radomski
Attachment

pgsql-hackers by date:

Previous
From: "Arulappan, Arul Shaji"
Date:
Subject: Re: Proposal - Support for National Characters functionality
Next
From: Cédric Villemain
Date:
Subject: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])