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 553169FA2C8 for ; Wed, 17 May 2006 13:14:28 -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 46690-01 for ; Wed, 17 May 2006 13:14:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5D0A89F944D for ; Wed, 17 May 2006 13:14:16 -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 k4HGDnsJ020776; Wed, 17 May 2006 12:13:50 -0400 (EDT) To: "Jim C. Nasby" cc: Bruce Momjian , "Jim C. Nasby" , PostgreSQL-documentation Subject: Re: Mention pg_dump version portability In-reply-to: <20060517154120.GQ26212@decibel.org> References: <20060515202354.GM26212@pervasive.com> <200605152343.k4FNhK703441@candle.pha.pa.us> <20060517154120.GQ26212@decibel.org> Comments: In-reply-to "Jim C. Nasby" message dated "Wed, 17 May 2006 10:41:20 -0500" Date: Wed, 17 May 2006 12:13:49 -0400 Message-ID: <20775.1147882429@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/33 X-Sequence-Number: 3560 "Jim C. Nasby" writes: > 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? There would probably be some small differences, but 99% of pg_restore's output is just regurgitating SQL it finds in the dump file. regards, tom lane