Re: Can you help me - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Can you help me
Date
Msg-id 20050606203610.GA13651@wolff.to
Whole thread Raw
In response to Re: Can you help me  (Michelle Konzack <linux4michelle@freenet.de>)
List pgsql-admin
On Mon, Jun 06, 2005 at 19:34:24 +0200,
  Michelle Konzack <linux4michelle@freenet.de> wrote:
>
> I am using Debian GNU/Linux 3.0 with pgsql 7.4 (backport)
> and want to upgrade to SARGE 3.1 and pgsql 8.0
>
> Because I can not upgrade my production system to SARGE,
> I need to install SARGE on a new system with pgsql 8.0.
>
> Now, is it possibel to copy only pg_dumpall from SARGE
> to the WOODY Server to dump it ?

You can run pg_dumpall on the new server connecting to the old server.

> Please note, that my postgresql AFTER vacumization is
> over 120 GByte in size and locates on a Raid-5 Server
> with 4 x 147 GByte which mean, I have 420 GByte diskspace.

If you can't afford to be down for the time it will take to dump and
reload 120 GB, you can look at using Slony to help with the conversion.

pgsql-admin by date:

Previous
From: Michelle Konzack
Date:
Subject: Re: Can you help me
Next
From: "Joel Fradkin"
Date:
Subject: 8.0.3. binaries for fedora core 3