From: Caleb Cushing <xenoterracide@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump formatting
Date: Fri, 20 Mar 2009 15:47:16 -0400
Message-ID: <81bfc67a0903201247l3ddabf14p3e7d2bfd9206cfe7@mail.gmail.com> (raw)
In-Reply-To: <200903201431.n2KEVZj04033@momjian.us>
References: <81bfc67a0903192135v1caa41abtd4618f3df0642834@mail.gmail.com>
<200903201431.n2KEVZj04033@momjian.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: xenoterracide@gmail.com, bruce@momjian.us
Subject: Re: pg_dump formatting
In-Reply-To: <81bfc67a0903201247l3ddabf14p3e7d2bfd9206cfe7@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox