Skip site navigation (1) Skip section navigation (2)

Re: Using pg_upgrade on log-shipping standby servers

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Using pg_upgrade on log-shipping standby servers
Date: 2012-07-17 00:29:26
Message-ID: 1342484966.9520.13.camel@sussancws0025 (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, 2012-07-10 at 11:50 -0400, Bruce Momjian wrote:
> I don't think we can assume that because pg_upgrade was run on the
> master and standby that they are binary identical, can we?  Technically
> the user file are identical, but the system catalogs and WAL might be
> different, hence my suggestion to run rsync before allowing the standby
> to rejoin the primary.

Do you have plans to change that in the future?

If we know that the user data files are identical between primary and
replica, it would be nice if we could provide a robust way to avoid
copying them.

Regards,
	Jeff Davis



In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2012-07-17 00:35:46
Subject: Re: CompactCheckpointerRequestQueue versus pad bytes
Previous:From: Samuel VogelDate: 2012-07-16 23:51:08
Subject: b-tree index search algorithms

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group