DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=P4eBXZX3s5LYPTC5+TT+yM394hUcakACURbrGApPnrM+l83oq9ZPvcbCLutr82GTli
	6Ge3JwdkjimeB8BuY80Uzh9xHvN4r+bYq/Cf4hdPDJIK8PLZlwWDknL4482k6IHj99e+
	LviW2qC2SurDtrvcLF2NrdJ7n7L0lHKB5c6Xo=
MIME-Version: 1.0
In-Reply-To: <200903201431.n2KEVZj04033@momjian.us>
References: <81bfc67a0903192135v1caa41abtd4618f3df0642834@mail.gmail.com>
	<200903201431.n2KEVZj04033@momjian.us>
Date: Fri, 20 Mar 2009 15:47:16 -0400
Message-ID: <81bfc67a0903201247l3ddabf14p3e7d2bfd9206cfe7@mail.gmail.com>
Subject: Re: pg_dump formatting
From: Caleb Cushing <xenoterracide@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

On Fri, Mar 20, 2009 at 10:31 AM, Bruce Momjian <bruce@momjian.us> wrote:
>
> No, but there are database comparison tools to do that, pgdiff being one
> of them:

after reading a bit on it (docs seem a bit light but I also looked at
the mysql one), I don't think it solves my problem at all. it solves a
similar one. the way it reads suggests I have access to both
databases, I don't. I only have access to 1 (set up on my box from the
dump) and the dump from the other.

at work we dump our databases and add them to the git repository. and
pass the source back and forth, (I think it's a bit inefficient, but
I'm not the boss).

the problem is 2 fold, 1 it's impossible to get a human readable dump
diff, 2 the same reason is going to 'cause the git repository to get
large than it should because it stores blobs and these long lines
would each end up as a blob even though the character difference might
be like 1 character.

I suppose I could write a regex script that reformats the dump,
personally that scares me a bit.

it'd be great if pg could have the option to dump in a more 'diff-able' way.
-- 
Caleb Cushing

http://xenoterracide.blogspot.com