X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F1D43D1D26C for ; Sat, 31 Jan 2004 05:32:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 17975-08 for ; Sat, 31 Jan 2004 01:32:07 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 26C81D1D263 for ; Sat, 31 Jan 2004 01:32:06 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i0V5W5sK027156; Sat, 31 Jan 2004 00:32:06 -0500 (EST) To: cgg007@yahoo.com Cc: pgsql-admin@postgresql.org Subject: Re: Dump and Reload process In-reply-to: <20040130172859.3625.qmail@web13806.mail.yahoo.com> References: <20040130172859.3625.qmail@web13806.mail.yahoo.com> Comments: In-reply-to Chris Gamache message dated "Fri, 30 Jan 2004 09:28:59 -0800" Date: Sat, 31 Jan 2004 00:32:05 -0500 Message-ID: <27155.1075527125@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/307 X-Sequence-Number: 12170 Chris Gamache writes: > I'm having some issues dumping a database from 7.2, reloading it to 7.4. > I'm using the 7.4 pg_dump. The problem I'm having is an issue of internal > object dependancies. > ... > There must be a better way! Thoughts? This is (at long last) fixed in development tip. In existing releases, the only good solution is to use pg_restore's features for manually controlling the load order :-( regards, tom lane