9.4 recommendations for archive_command vs. replication slots

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.

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

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

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?

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

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

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

On 11/04/2014 01:38 PM, Josh Berkus wrote:

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.

Also, specifically, having replication slots doesn't make having a
shared archive an obsolete approach. In many cases, if the replicas are
offline for a while you don't want to burden the master with helping
them catch up. So its an equal alternative to replication slots.

What's significantly less useful now is wal_keep_segments.

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

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs