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 280C15691B for ; Mon, 21 Mar 2005 16:55:48 +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 58897-02 for ; Mon, 21 Mar 2005 16:55:46 +0000 (GMT) Received: from mail.valleypres.org (mail.valleypres.org [63.196.151.90]) by svr1.postgresql.org (Postfix) with ESMTP id B471756918 for ; Mon, 21 Mar 2005 16:55:45 +0000 (GMT) Received: from valleypres.org (mail.valleypres.org [172.16.12.253]) by mail.valleypres.org (Postfix) with ESMTP id 5868193657; Mon, 21 Mar 2005 08:55:45 -0800 (PST) Received: from [172.16.14.58] (helo=clamav.valleypres.org) by valleypres.org with esmtp (Exim 3.13 #3) id 1DDQBt-00076A-00; Mon, 21 Mar 2005 08:55:45 -0800 Received: from AT10111 (unknown [172.16.30.202]) by clamav.valleypres.org (Postfix) with SMTP id 77BEF17C407; Mon, 21 Mar 2005 08:55:39 -0800 (PST) Reply-To: From: "Bryan Encina" To: =?UTF-8?Q?'Dr._Roger_Wie=C3=9Fner'?= Cc: Subject: Re: Migration from 7.1.3. to 7.4.7. Date: Mon, 21 Mar 2005 08:54:17 -0800 Message-ID: <001401c52e36$9f538610$ca1e10ac@AT10111> MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <1111420428.26897.51.camel@state.g2switchworks.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-VPH-MailScanner-Information: Please contact the ISP for more information X-VPH-MailScanner: Found to be clean X-MailScanner-From: bryan.encina@valleypres.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.56 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/326 X-Sequence-Number: 16824 > 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.=20 > to 7.4.7.? I get=20 > > lots of errors... >=20 > Try to have both installed at once (separate dirs, or=20 > 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=20 > version of 7.1.3. >=20 > On rare occasions, an intermediate upgrade to something in between may > help, but I've not used 7.1 in a VERY long time. >=20 If for some reason you can't dump with the 7.4.7 pg_dump one of the = problems you might be having is with literal carriage returns within = your data. I was able to use sed to help with getting it into a proper = format. -Bryan