Re: pg_upgrade + streaming replication ? - Mailing list pgsql-general

From Jeff Davis
Subject Re: pg_upgrade + streaming replication ?
Date
Msg-id 1332366866.1762.6.camel@sussancws0025
Whole thread Raw
In response to Re: pg_upgrade + streaming replication ?  (Henk Bronk <hb@101-factory.eu>)
List pgsql-general
On Wed, 2012-03-21 at 09:12 +0100, Henk Bronk wrote:
> On linux, you can also do a
>
>
> cp -rpuv. source destination

My point was that we should not take shortcuts that avoid the work of a
full base backup for the replicas until we've determined a safe way to
do that.

As far as I know, nobody has successfully and safely done a pg_upgrade
of a set of replicas without the need for full base backups (which need
to copy all of the user data).

Until someone determines that it's safe, adds the necessary
functionality to pg_upgrade and/or replication, and documents it; then I
do _not_ recommend such a thing for any production system.

Regards,
    Jeff Davis



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Large PostgreSQL servers
Next
From: John R Pierce
Date:
Subject: Re: Large Databases redux