Re: 9.4 recommendations for archive_command vs. replication slots

On 11/04/2014 10:20 AM, Peter Eisentraut wrote:
> On 10/29/14 6:47 PM, Josh Berkus wrote:
>> On 10/20/2014 11:04 AM, Peter Eisentraut wrote:
>>> The 9.4 documentation for streaming replication still starts out by
>>> making you set up archive_command and restore_command. Isn't that
>>> obsolete now with replication slots? Shouldn't the first step be to set
>>> up replication slots and then go from there?
>>
>> Well, bluntly, our replication docs should be taken out behind the barn
>> with an axe. They tell you more about the development history of
>> PostgreSQL than they tell you about how to replicate.
>
> That's true, but can we come to a consensus of what the preferred
> advertised method should be?

We should do this tutorial-style, taking things through increasingly
complex replication setups:

1) simple two-server with pg_basebackup, no archiving, no slots
(i.e. "replication in 5 minutes")
2) replication with archiving
3) replication with replication slots
including "wal_keep_segments vs. replication slots"
4) synchronous replication
5) cascading replication
6) archiving-only replication
7) replication performance tuning

I could write this if I *don't* need to do it as a patch against the
existing docs.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com