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.