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

Using pg_upgrade on log-shipping standby servers

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Using pg_upgrade on log-shipping standby servers
Date: 2012-07-10 15:50:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
I occasionally get questions about how to run pg_upgrade on log-shipping
standby servers.  The attached documentation patch outlines how to do

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.

  Bruce Momjian  <bruce(at)momjian(dot)us>

  + It's impossible for everything to be true. +

Attachment: pg_upgrade.diff
Description: text/x-diff (833 bytes)


pgsql-hackers by date

Next:From: Tom LaneDate: 2012-07-10 16:00:06
Subject: Re: [PATCH] psql \n shortcut for set search_path =
Previous:From: Tom LaneDate: 2012-07-10 15:49:49
Subject: Re: expression evaluation with expected datatypes

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