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

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 (view raw or flat)
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

pgsql-hackers by date

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

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