X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AC6E39FA226 for ; Wed, 17 May 2006 12:41:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 36834-09 for ; Wed, 17 May 2006 12:41:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id DE70C9F9C18 for ; Wed, 17 May 2006 12:41:32 -0300 (ADT) Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by svr4.postgresql.org (Postfix) with ESMTP id EC3845B56D6 for ; Wed, 17 May 2006 15:41:31 +0000 (GMT) Received: by noel.decibel.org (Postfix, from userid 1001) id DEDDA56427; Wed, 17 May 2006 10:41:20 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 17 May 2006 10:41:20 -0500 Date: Wed, 17 May 2006 10:41:20 -0500 From: "Jim C. Nasby" To: Bruce Momjian Cc: "Jim C. Nasby" , PostgreSQL-documentation Subject: Re: Mention pg_dump version portability Message-ID: <20060517154120.GQ26212@decibel.org> References: <20060515202354.GM26212@pervasive.com> <200605152343.k4FNhK703441@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200605152343.k4FNhK703441@candle.pha.pa.us> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060517:pgman@candle.pha.pa.us::xilHKC4CgPgNn8RD:000000000000000 0000000000000000000000003u/s X-Hashcash: 1:20:060517:jnasby@pervasive.com::vF4Fx03Ad/EOk4Hp:00000000000000000 0000000000000000000000001o7V X-Hashcash: 1:20:060517:pgsql-docs@postgresql.org::Cu0g8JJLq55wfP01:000000000000 00000000000000000000000005Bp X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/32 X-Sequence-Number: 3559 Grr, deleted Tom's email before I replied... pg_dump -Fc | pg_restore will only match the output of pg_dump if everything's the same version though, right? Or wrong? What happens if pg_dump -Fc is and older version and pg_restore is the current version? Or is the custom format the same as the text/SQL dump, just with some fancy wrappers around it? -- Jim C. Nasby, Database Architect decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"