X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E075F9DC87A for ; Sat, 25 Mar 2006 17:26:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19699-05 for ; Sat, 25 Mar 2006 17:26:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 928F69DC86E for ; Sat, 25 Mar 2006 17:26:41 -0400 (AST) Received: from evim.gunduz.org (dsl.static8121514250.ttnet.net.tr [81.215.14.250] (may be forged)) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k2PLQiN6015728; Sat, 25 Mar 2006 13:26:45 -0800 Subject: Re: Core 5 Upgrade From: Devrim GUNDUZ To: Rick Ellis Cc: "pgsql-admin@postgresql.org" In-Reply-To: <1143319583.549307@localhost.localdomain> References: <1143319583.549307@localhost.localdomain> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Sat, 25 Mar 2006 23:26:51 +0200 Message-Id: <1143322011.3974.10.camel@evim.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-22) Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Sat, 25 Mar 2006 13:26:46 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.179 required=5 tests=[AWL=0.179] X-Spam-Score: 0.179 X-Spam-Level: X-Archive-Number: 200603/262 X-Sequence-Number: 21019 Hi, On Sat, 2006-03-25 at 20:46 +0000, Rick Ellis wrote: > I forgot to dump before I upgraded to Fedora Core 5 (Postgresql > 8.0.x to 8.1.x). Is there an easy way to bring up an 8.0.x server > long enough to dump the data? Do a source 8.0 installation, and start pg_ctl with /var/lib/pgsql/data. Dump your data, and then stop existing postmaster, and go on with the upgrade. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/