Re: Can you help me

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Michelle Konzack <linux4michelle(at)freenet(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Can you help me
Date: 2005-06-06 20:36:10
Message-ID: 20050606203610.GA13651@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Jun 06, 2005 at 19:34:24 +0200,
Michelle Konzack <linux4michelle(at)freenet(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Joel Fradkin 2005-06-07 12:30:32 8.0.3. binaries for fedora core 3
Previous Message Michelle Konzack 2005-06-06 17:34:24 Re: Can you help me