Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2CE069FB569 for ; Fri, 13 Apr 2007 21:51:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17972-03 for ; Fri, 13 Apr 2007 21:51:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 95ACA9FB464 for ; Fri, 13 Apr 2007 21:51:46 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l3E0pitu027271; Fri, 13 Apr 2007 20:51:44 -0400 (EDT) To: "Brooks, Jason" cc: pgsql-admin@postgresql.org Subject: Re: Restoring from older pg_dump files In-reply-to: <796EF5B39103EE45A04CC2FFFCF130B9D80790@ala-mail08.corp.ad.wrs.com> References: <796EF5B39103EE45A04CC2FFFCF130B9D80790@ala-mail08.corp.ad.wrs.com> Comments: In-reply-to "Brooks, Jason" message dated "Fri, 13 Apr 2007 16:04:54 -0700" Date: Fri, 13 Apr 2007 20:51:44 -0400 Message-ID: <27270.1176511904@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/133 X-Sequence-Number: 25197 "Brooks, Jason" writes: > The original file was created with pg_dump -cou. One thing that's probably biting you is that 8.1 defaults to WITHOUT OIDS, which is not an option 7.1 pg_dump even knows exists, so it's not going to say WITH OIDS in the create commands, and then the COPY WITH OIDS commands will fail ... I concur with Josh's to use the newer version's pg_dump, but if you can't, setting default_with_oids = true will probably help. There might be some lesser gotchas too --- what sorts of errors do you get exactly after fixing that? regards, tom lane