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 3926C56918 for ; Mon, 21 Mar 2005 17:00:25 +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 60552-03 for ; Mon, 21 Mar 2005 17:00:23 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id CAE105691E for ; Mon, 21 Mar 2005 17:00:19 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 21 Mar 2005 11:00:15 -0600 Subject: Re: Migration from 7.1.3. to 7.4.7. From: Scott Marlowe To: "Dr. Roger" =?ISO-8859-1?Q?Wie=DFner?= Cc: pgsql-admin@postgresql.org In-Reply-To: <1111420428.26897.51.camel@state.g2switchworks.com> References: <39qlrmF62i3vgU1@individual.net> <1111420428.26897.51.camel@state.g2switchworks.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1111424414.26897.126.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 21 Mar 2005 11:00:15 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/327 X-Sequence-Number: 16825 On Mon, 2005-03-21 at 09:53, Scott Marlowe wrote: > On Wed, 2005-03-16 at 06:07, Dr. Roger Wie=C3=9Fner wrote: > > Can anyone tell me how to successfully migrate from 7.1.3. to 7.4.7.? I= get=20 > > lots of errors... >=20 > Try to have both installed at once (separate dirs, or separate machines) > and dump the 7.1.3 db with the 7.4.7 pg_dump. You might want to do a > file system backup and an upgrade of 7.1.3 to the last version of 7.1.3. In my previous message, I meant the latest version of 7.1, which is , now that I look it up, 7.1.3... sigh, never mind that point there.