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 8978F565E0 for ; Mon, 21 Mar 2005 15:53:47 +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 37583-02 for ; Mon, 21 Mar 2005 15:53:45 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 23EE4540C9 for ; Mon, 21 Mar 2005 15:53:44 +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 09:53:48 -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: <39qlrmF62i3vgU1@individual.net> References: <39qlrmF62i3vgU1@individual.net> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1111420428.26897.51.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 21 Mar 2005 09:53:48 -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/324 X-Sequence-Number: 16822 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 g= et=20 > lots of errors... 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. On rare occasions, an intermediate upgrade to something in between may help, but I've not used 7.1 in a VERY long time.