Horton
Menu

Re: Using pg_upgrade on log-shipping standby servers

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Bruce Momjian <bruce@momjian.us>
Cc: Aidan Van Dyk <aidan@highrise.ca>, Jeff Davis <pgsql@j-davis.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2012-07-21T08:24:21Z
Lists: pgsql-hackers 
On fre, 2012-07-20 at 13:11 -0400, Bruce Momjian wrote:
> I think the commands to run after pg_upgrade --link completes on both
> primary and standby might be as easy as:
> 
>         cd /u/pg/pgsql.old/data
>         find . -links 1 -exec cp {} /u/pgsql/data \;
> 
> Why would we want anything more complicated than this?

In practice these are on different machines, and the way the machines
are connected could vary wildly.  So an automated solution might be
difficult to find.