Re: [HACKERS] Replication/backup defaults - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Replication/backup defaults
Date
Msg-id ae854caa-7986-18e5-bfe5-0b65ed606cab@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] Replication/backup defaults  (Magnus Hagander <magnus@hagander.net>)
Responses Re: [HACKERS] Replication/backup defaults  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On 12/31/16 10:00 AM, Magnus Hagander wrote:
> max_wal_senders=10
> max_replication_slots=20

How about we default max_replication_slots to -1, which means to use the
same value as max_wal_senders?

I think this would address the needs of 99% of users.  If we do like you
suggest, there are going to be very many users who forget to adjust
these two values together, and very many who will do it but will be
puzzled and annoyed by it.  Since we're now pushing the use of
replication slots even more (your pg_basebackup change, upcoming logical
replication), I think this could be a major source of misconfigurations.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [HACKERS] [PATCH] Rename pg_switch_xlog to pg_switch_wal
Next
From: Magnus Hagander
Date:
Subject: Re: [HACKERS] Replication/backup defaults