Search Postgresql Archives

Re: pg_upgrade + streaming replication ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux