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 195BD8B9E6E for ; Tue, 22 Feb 2005 17:40:20 +0000 (GMT) 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 43171-10 for ; Tue, 22 Feb 2005 17:40:09 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id A969D8B9C8C for ; Tue, 22 Feb 2005 17:40:08 +0000 (GMT) Received: (qmail 3920 invoked by uid 500); 22 Feb 2005 17:55:28 -0000 Date: Tue, 22 Feb 2005 11:55:28 -0600 From: Bruno Wolff III To: denis moeller Cc: pgsql-admin@postgresql.org Subject: Re: Upgrading 7.3 -> 7.4.5 Message-ID: <20050222175528.GA3507@wolff.to> Mail-Followup-To: denis moeller , pgsql-admin@postgresql.org References: <421B6D96.80900@latrina.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <421B6D96.80900@latrina.de> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/227 X-Sequence-Number: 16395 On Tue, Feb 22, 2005 at 18:36:22 +0100, denis moeller wrote: > > situation: old server backup. Backup of Postgresql data files. Postgres > 7.3.x was running. You can't take file system level backups under a running postmaster and expect to use those to recover a database. You either need to shut the postmaster down or use pg_dump(all) to make a live dump. > New server has version 7.4.5 - how do I get the old data in my new database? > Copying didn't work - complains about different versions. When switching between major versions (such as 7.3.x to 7.4.x) you need to do a dump and restore. If possible you should use the pg_dump client of the newer version to do the dump, as newer versions do a better job of handling dependencies in dumps.