X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6AB6B56392 for ; Mon, 21 Mar 2005 21:49:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79861-10 for ; Mon, 21 Mar 2005 21:49:41 +0000 (GMT) Received: from hal9000.jaa.iki.fi (gw.jaa.iki.fi [64.81.100.231]) by svr1.postgresql.org (Postfix) with ESMTP id 42736563A5 for ; Mon, 21 Mar 2005 21:49:40 +0000 (GMT) Received: by hal9000.jaa.iki.fi (Postfix, from userid 500) id 1F7863457C; Mon, 21 Mar 2005 14:49:40 -0700 (MST) Date: Mon, 21 Mar 2005 14:49:40 -0700 From: Jani Averbach To: pgsql-admin@postgresql.org Subject: pg_dump, custom format and changes in the dump file Message-ID: <20050321214940.GI9590@jaa.iki.fi> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/335 X-Sequence-Number: 16833 Hello, We have a system where we take periodic dumps from PgSQL 8.0.1 database and put those dumps under version control (Subversion). Now the problem is that when we take a custom format dump with: pg_dump --format=c --compress=0 --column-inserts \ --use-set-session-authorization \ db_name > db_dump_file The dump file has been changed when at the same time taken ASCII dump (--format=p) is identical to the previous one. So, Is there any way to stabilize pg_dump with custom format so that the dump file won't change without real db changes? Thank you for your help, Jani -- Jani Averbach