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 605FA9FA3A6 for ; Tue, 16 May 2006 15:46:59 -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 67582-06-5 for ; Tue, 16 May 2006 15:46:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id A31FE9F9C9E for ; Tue, 16 May 2006 15:46:37 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id C097B56431; Tue, 16 May 2006 13:46:33 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 16 May 2006 13:46:33 -0500 Date: Tue, 16 May 2006 13:46:33 -0500 From: "Jim C. Nasby" To: Bruce Momjian Cc: PostgreSQL-documentation Subject: Re: Mention pg_dump version portability Message-ID: <20060516184633.GM26212@pervasive.com> 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:060516:pgman@candle.pha.pa.us::y6UyxwXE5KRfd8JS:000000000000000 000000000000000000000000019e X-Hashcash: 1:20:060516:pgsql-docs@postgresql.org::PpZZwDSvTSDralMK:000000000000 0000000000000000000000002MUA X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/30 X-Sequence-Number: 3557 On Mon, May 15, 2006 at 07:43:20PM -0400, Bruce Momjian wrote: > Jim C. Nasby wrote: > > On Sat, May 13, 2006 at 12:21:06PM -0400, Bruce Momjian wrote: > > > I have applied this patch that mentions pg_dump portability to 8.1.X and > > > CVS HEAD. > > > > Would it be worth recommending using the custom format over plain? I see > > plenty of issues with incompatabilities in the plain version, but I > > don't think I've ever seen problem with the custom format (though this > > could just be because everyone uses the default...) > > Right, it is just because it is the default. But shouldn't the custom format deal better with version changes, or does the format of custom change just as often? Though, even if it did change just as often, pg_restore should be able to deal better with it than psql, since pg_restore knows it's a dump and knows what version it's coming from... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461