Re: Using pg_upgrade on log-shipping standby servers

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Aidan Van Dyk <aidan(at)highrise(dot)ca>, Jeff Davis <pgsql(at)j-davis(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Using pg_upgrade on log-shipping standby servers
Date: 2012-07-21 08:24:21
Message-ID: 1342859061.29907.1.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox
Thread:
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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2012-07-21 08:55:57 Re: Resetting libpq connections after an app error
Previous Message Bruce Momjian 2012-07-21 07:08:43 9.2 release schedule