X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 17A84528AA for ; Mon, 6 Jun 2005 17:37:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95319-07 for ; Mon, 6 Jun 2005 20:36:57 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 2A15C52879 for ; Mon, 6 Jun 2005 17:36:56 -0300 (ADT) Received: (qmail 14382 invoked by uid 500); 6 Jun 2005 20:36:10 -0000 Date: Mon, 6 Jun 2005 15:36:10 -0500 From: Bruno Wolff III To: Michelle Konzack Cc: pgsql-admin@postgresql.org Subject: Re: Can you help me Message-ID: <20050606203610.GA13651@wolff.to> Mail-Followup-To: Bruno Wolff III , Michelle Konzack , pgsql-admin@postgresql.org References: <000001c569aa$f3084750$393ca8c0@riy.norconsult.com.sa> <20050606165841.GB30453@wolff.to> <20050606173424.GW693@freenet.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050606173424.GW693@freenet.de> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/29 X-Sequence-Number: 17784 On Mon, Jun 06, 2005 at 19:34:24 +0200, Michelle Konzack 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.