Re: Defaults for replication/backup - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Defaults for replication/backup
Date
Msg-id CAB7nPqSFzsO6bEknEQ8yidwXOOUUeCc05NKsPQFhMWBFPv3Smg@mail.gmail.com
Whole thread Raw
In response to Defaults for replication/backup  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Defaults for replication/backup
Re: Defaults for replication/backup
List pgsql-hackers
On Sat, Feb 13, 2016 at 10:15 PM, Magnus Hagander wrote:
> So, I suggest the following changes to the defaults:
> wal_level=hot_standby
> max_wal_senders=10
> max_replication_slots=10

10 seems a bit high. I would think that max_wal_senders and
max_replication_slots set at 3 are sufficient enough, giving enough
room for simple deployments willing to use replication.

> And in pg_hba.conf, we enable the replication connections by default for the
> superuser on local/localhost.

+1 on that.
-- 
Michael



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: extend pgbench expressions with functions
Next
From: Andres Freund
Date:
Subject: Re: Defaults for replication/backup