Using pg_upgrade on log-shipping standby servers - Mailing list pgsql-hackers

From Bruce Momjian
Subject Using pg_upgrade on log-shipping standby servers
Date
Msg-id 20120710155018.GB31941@momjian.us
Whole thread Raw
Responses Re: Using pg_upgrade on log-shipping standby servers  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Using pg_upgrade on log-shipping standby servers  (Jeff Davis <pgsql@j-davis.com>)
List 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
it.

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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: expression evaluation with expected datatypes
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] psql \n shortcut for set search_path =