Re: Easy upgrade on Cpanel *without* downtime - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Easy upgrade on Cpanel *without* downtime
Date
Msg-id 48B2ADF4.4060304@wildenhain.de
Whole thread Raw
In response to Re: Easy upgrade on Cpanel *without* downtime  (Andrew Sullivan <ajs@commandprompt.com>)
Responses Re: Easy upgrade on Cpanel *without* downtime  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List pgsql-general
Andrew Sullivan wrote:
> On Mon, Aug 25, 2008 at 11:34:00AM +0200, Tino Wildenhain wrote:
>> (e.g. pg_dump | pg_restore to avoid wasting space 2 times)
>> then run slony to permanently update the last bits
>
> If you're going to run slony, then the pg_dump|pg_restore step is
> completely wasted.  Slony will restore all the data again.  You do
> need to run pg_dump -s, of course.

good point :-)

Regards
Tino

Attachment

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Easy upgrade on Cpanel *without* downtime
Next
From: Tom Lane
Date:
Subject: Re: Issue with creation of Partial_indexes (Immutable?)