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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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