Re: Easy upgrade on Cpanel *without* downtime

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Andrew Sullivan <ajs(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Easy upgrade on Cpanel *without* downtime
Date: 2008-08-25 13:04:52
Message-ID: 48B2ADF4.4060304@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-08-25 14:18:24 Re: Issue with creation of Partial_indexes (Immutable?)
Previous Message Andrew Sullivan 2008-08-25 12:53:15 Re: Easy upgrade on Cpanel *without* downtime