pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Schema comparisons
12+ messages / 8 participants
[nested] [flat]

* Schema comparisons
@ 2004-02-28 03:32 Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 12+ messages in thread

From: Mark Lubratt @ 2004-02-28 03:32 UTC (permalink / raw)
  To: pgsql-admin

Hello!

I have two databases running on separate machines.  One is a production 
server and the other is development.

I've been trying to be careful, but I've gotten out of synch with 
whether or not I've applied the changes I've made to the development 
system to the production system.  Is there a utility that will compare 
the tables, functions, trigger, views, etc. between two systems and 
flag the schema elements that aren't in synch between the two?

If not, and I need to write one, would such a system be of interest to 
anyone else?

Thanks!
Mark




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
@ 2004-02-28 04:28 ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 12+ messages in thread

From: Tom Lane @ 2004-02-28 04:28 UTC (permalink / raw)
  To: Mark Lubratt <mark.lubratt@indeq.com>; +Cc: pgsql-admin

Mark Lubratt <mark.lubratt@indeq.com> writes:
> I've been trying to be careful, but I've gotten out of synch with 
> whether or not I've applied the changes I've made to the development 
> system to the production system.  Is there a utility that will compare 
> the tables, functions, trigger, views, etc. between two systems and 
> flag the schema elements that aren't in synch between the two?

Have you tried diffing pg_dump output?  It's not the greatest tool but
it's helpful.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-02-28 15:39   ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 17:58     ` Re: [ADMIN] Schema comparisons Michael Brusser <michael@synchronicity.com>
  2004-02-28 17:59     ` Re: [ADMIN] Schema comparisons Richard Huxton <dev@archonet.com>
  2004-02-29 02:23     ` Re: [ADMIN] Schema comparisons Alex J. Avriette <alex@posixnap.net>
  0 siblings, 3 replies; 12+ messages in thread

From: Tom Lane @ 2004-02-28 15:39 UTC (permalink / raw)
  To: Mark Lubratt <mark.lubratt@indeq.com>; +Cc: pgsql-hackers@postgreSQL.org

Mark Lubratt <mark.lubratt@indeq.com> writes:
> On Feb 27, 2004, at 10:28 PM, Tom Lane wrote:
>> Mark Lubratt <mark.lubratt@indeq.com> writes:
>>> I've been trying to be careful, but I've gotten out of synch with
>>> whether or not I've applied the changes I've made to the development
>>> system to the production system.  Is there a utility that will compare
>>> the tables, functions, trigger, views, etc. between two systems and
>>> flag the schema elements that aren't in synch between the two?
>> 
>> Have you tried diffing pg_dump output?  It's not the greatest tool but
>> it's helpful.

> Yes, I did.  It was quite cumbersome.  Especially since the OIDs and 
> TOC entry numbers didn't matchup; and, since those didn't always match, 
> the order of objects wasn't quite the same either.  So, diff was 
> throwing a lot of false positives at me.

Yeah.  CVS-tip pg_dump doesn't show OIDs by default, to make it easier
to use for purposes like this.  The ordering issue is the bigger problem
though.  I presume that the object creation history is different in the
two databases and so pg_dump's habit of sorting by OID isn't helpful.

It occurs to me that this could be solved now that we have
dependency-driven ordering in pg_dump.  The ordering algorithm is
presently
	* Order by object type, and by OID within types;
	* Move objects as needed to honor dependencies.
Ordering by OID should no longer be needed for correctness, because
the second phase will take care of any dependency problems.  We
could instead make the initial sort be by object name (within types).
This should ensure that the schema output is identical for logically
equivalent databases, even if their history is different.

(When dumping from a pre-7.3 database, we'd have to stick to the OID
algorithm for lack of dependency info, but of course that case is
getting less interesting as time wears on.)

Comments?  Anyone see a reason not to do this?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-02-28 17:58     ` Michael Brusser <michael@synchronicity.com>
  2 siblings, 0 replies; 12+ messages in thread

From: Michael Brusser @ 2004-02-28 17:58 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; Mark Lubratt <mark.lubratt@indeq.com>; +Cc: pgsql-hackers@postgresql.org

Interestingly I tried to address the same problem few days ago.
I used pg_dump, grep, etc - in the end I got what I needed, but
it was a cumbersome ordeal.

I think ideally it would be great to have a utility that would
give me a clean diff. between the schemas.

Perhaps pg_dump could have a new arg to produce the output
most suitable for this utility.

Mike.


> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Tom Lane
> Sent: Saturday, February 28, 2004 10:40 AM
> To: Mark Lubratt
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] [ADMIN] Schema comparisons
>
>
> Mark Lubratt <mark.lubratt@indeq.com> writes:
> > On Feb 27, 2004, at 10:28 PM, Tom Lane wrote:
> >> Mark Lubratt <mark.lubratt@indeq.com> writes:
> >>> I've been trying to be careful, but I've gotten out of synch with
> >>> whether or not I've applied the changes I've made to the development
> >>> system to the production system.  Is there a utility that will compare
> >>> the tables, functions, trigger, views, etc. between two systems and
> >>> flag the schema elements that aren't in synch between the two?
> >>
> >> Have you tried diffing pg_dump output?  It's not the greatest tool but
> >> it's helpful.
>
> > Yes, I did.  It was quite cumbersome.  Especially since the OIDs and
> > TOC entry numbers didn't matchup; and, since those didn't always match,
> > the order of objects wasn't quite the same either.  So, diff was
> > throwing a lot of false positives at me.
>
> Yeah.  CVS-tip pg_dump doesn't show OIDs by default, to make it easier
> to use for purposes like this.  The ordering issue is the bigger problem
> though.  I presume that the object creation history is different in the
> two databases and so pg_dump's habit of sorting by OID isn't helpful.
>
> It occurs to me that this could be solved now that we have
> dependency-driven ordering in pg_dump.  The ordering algorithm is
> presently
> 	* Order by object type, and by OID within types;
> 	* Move objects as needed to honor dependencies.
> Ordering by OID should no longer be needed for correctness, because
> the second phase will take care of any dependency problems.  We
> could instead make the initial sort be by object name (within types).
> This should ensure that the schema output is identical for logically
> equivalent databases, even if their history is different.
>
> (When dumping from a pre-7.3 database, we'd have to stick to the OID
> algorithm for lack of dependency info, but of course that case is
> getting less interesting as time wears on.)
>
> Comments?  Anyone see a reason not to do this?
>
> 			regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>





^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-02-28 17:59     ` Richard Huxton <dev@archonet.com>
  2004-02-29 02:01       ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2 siblings, 1 reply; 12+ messages in thread

From: Richard Huxton @ 2004-02-28 17:59 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; Mark Lubratt <mark.lubratt@indeq.com>; +Cc: pgsql-hackers@postgresql.org

On Saturday 28 February 2004 15:39, Tom Lane wrote:
> Mark Lubratt <mark.lubratt@indeq.com> writes:
> > On Feb 27, 2004, at 10:28 PM, Tom Lane wrote:
> >> Mark Lubratt <mark.lubratt@indeq.com> writes:
> >>> I've been trying to be careful, but I've gotten out of synch with
> >>> whether or not I've applied the changes I've made to the development
> >>> system to the production system.  Is there a utility that will compare
> >>> the tables, functions, trigger, views, etc. between two systems and
> >>> flag the schema elements that aren't in synch between the two?
> >>
> >> Have you tried diffing pg_dump output?  It's not the greatest tool but
> >> it's helpful.

> Comments?  Anyone see a reason not to do this?

It would help me out too - I have similar problems to Mark with keeping 
various copies in sync.

I've been looking at storing $REVISION$ in comments for each object, so my 
install scripts can halt if there is a problem. Not wanting to use my only 
comment slot for this I was thinking about an extension to the COMMENT ON 
statement:
COMMENT ON TABLE foo IS 'This is where I stroe my foos.';
COMMENT ON TABLE foo SECTION 'default' IS 'I meant store my foos.';
COMMENT ON TABLE foo SECTION 'revision' IS '1.19';
COMMENT ON TABLE foo SECTION 'bar' IS 'baz';



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 17:59     ` Re: [ADMIN] Schema comparisons Richard Huxton <dev@archonet.com>
@ 2004-02-29 02:01       ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-29 14:08         ` Re: [ADMIN] Schema comparisons Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 12+ messages in thread

From: Tom Lane @ 2004-02-29 02:01 UTC (permalink / raw)
  To: Richard Huxton <dev@archonet.com>; +Cc: Mark Lubratt <mark.lubratt@indeq.com>; pgsql-hackers@postgresql.org

Richard Huxton <dev@archonet.com> writes:
> I've been looking at storing $REVISION$ in comments for each object, so my 
> install scripts can halt if there is a problem. Not wanting to use my only 
> comment slot for this I was thinking about an extension to the COMMENT ON 
> statement:
> COMMENT ON TABLE foo IS 'This is where I stroe my foos.';
> COMMENT ON TABLE foo SECTION 'default' IS 'I meant store my foos.';
> COMMENT ON TABLE foo SECTION 'revision' IS '1.19';
> COMMENT ON TABLE foo SECTION 'bar' IS 'baz';

This seems a little, um, specialized.  Why don't you just keep the info
in a user-defined table?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 17:59     ` Re: [ADMIN] Schema comparisons Richard Huxton <dev@archonet.com>
  2004-02-29 02:01       ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-02-29 14:08         ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 12+ messages in thread

From: Richard Huxton @ 2004-02-29 14:08 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Mark Lubratt <mark.lubratt@indeq.com>; pgsql-hackers@postgresql.org

On Sunday 29 February 2004 02:01, Tom Lane wrote:
> Richard Huxton <dev@archonet.com> writes:
> > I've been looking at storing $REVISION$ in comments for each object, so
> > my install scripts can halt if there is a problem. Not wanting to use my
> > only comment slot for this I was thinking about an extension to the
> > COMMENT ON statement:
> > COMMENT ON TABLE foo IS 'This is where I stroe my foos.';
> > COMMENT ON TABLE foo SECTION 'default' IS 'I meant store my foos.';
> > COMMENT ON TABLE foo SECTION 'revision' IS '1.19';
> > COMMENT ON TABLE foo SECTION 'bar' IS 'baz';
>
> This seems a little, um, specialized.  Why don't you just keep the info
> in a user-defined table?

For the same reasons you don't store existing comments in a user-defined 
table:
1. It's convenient to have a standard (across providers) place for them.
2. It's meta-data, not data.
3. It gets dumped along with my table.

If it's just a case of "looks like a waste of time" then I might well waste my 
time and do it. On the other hand, if it's a case of "unnecessary 
complication - don't want it in the code" then I'll not bother.
-- 
  Richard Huxton
  Archonet Ltd



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-02-29 02:23     ` Alex J. Avriette <alex@posixnap.net>
  2004-02-29 03:22       ` Re: [ADMIN] Schema comparisons Tim Larson <tim@keow.org>
  2004-02-29 16:59       ` Re: [ADMIN] Schema comparisons Robert Treat <xzilla@users.sourceforge.net>
  2004-03-03 03:44       ` Re: [ADMIN] Schema comparisons Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  2 siblings, 3 replies; 12+ messages in thread

From: Alex J. Avriette @ 2004-02-29 02:23 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Mark Lubratt <mark.lubratt@indeq.com>; pgsql-hackers@postgreSQL.org

On Sat, Feb 28, 2004 at 10:39:40AM -0500, Tom Lane wrote:

> >> Have you tried diffing pg_dump output?  It's not the greatest tool but
> >> it's helpful.
> 
> > Yes, I did.  It was quite cumbersome.  Especially since the OIDs and 
> > TOC entry numbers didn't matchup; and, since those didn't always match, 
> > the order of objects wasn't quite the same either.  So, diff was 
> > throwing a lot of false positives at me.
> 
> Yeah.  CVS-tip pg_dump doesn't show OIDs by default, to make it easier
> to use for purposes like this.  The ordering issue is the bigger problem
> though.  I presume that the object creation history is different in the
> two databases and so pg_dump's habit of sorting by OID isn't helpful.

I recently had to figure out what was different between the "live" schema
and the schema in cvs at work. This was a really painful process, and it
occurred to me that it wouldn't be terribly hard to write a perl program
to do it (I wound up using vim and diff). Is there interest in such a tool?
I could probably have one written within a day or two.

Alex

--
alex@posixnap.net
Alex J. Avriette, Solaris Systems Masseur
http://envy.posixnap.net/~alex/articles/nro-wahhabi.html



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-29 02:23     ` Re: [ADMIN] Schema comparisons Alex J. Avriette <alex@posixnap.net>
@ 2004-02-29 03:22       ` Tim Larson <tim@keow.org>
  2 siblings, 0 replies; 12+ messages in thread

From: Tim Larson @ 2004-02-29 03:22 UTC (permalink / raw)
  To: pgsql-hackers@postgresql.org

On Sat, Feb 28, 2004 at 09:23:48PM -0500, Alex J. Avriette wrote:
> On Sat, Feb 28, 2004 at 10:39:40AM -0500, Tom Lane wrote:
> 
> > >> Have you tried diffing pg_dump output?  It's not the greatest tool but
> > >> it's helpful.
> > 
> > > Yes, I did.  It was quite cumbersome.  Especially since the OIDs and 
> > > TOC entry numbers didn't matchup; and, since those didn't always match, 
> > > the order of objects wasn't quite the same either.  So, diff was 
> > > throwing a lot of false positives at me.
> > 
> > Yeah.  CVS-tip pg_dump doesn't show OIDs by default, to make it easier
> > to use for purposes like this.  The ordering issue is the bigger problem
> > though.  I presume that the object creation history is different in the
> > two databases and so pg_dump's habit of sorting by OID isn't helpful.
> 
> I recently had to figure out what was different between the "live" schema
> and the schema in cvs at work. This was a really painful process, and it
> occurred to me that it wouldn't be terribly hard to write a perl program
> to do it (I wound up using vim and diff). Is there interest in such a tool?
> I could probably have one written within a day or two.

I sometimes supplement vim/diff with xxdiff, meld, and winmerge.

Hope this helps someone,
--Tim Larson



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-29 02:23     ` Re: [ADMIN] Schema comparisons Alex J. Avriette <alex@posixnap.net>
@ 2004-02-29 16:59       ` Robert Treat <xzilla@users.sourceforge.net>
  2 siblings, 0 replies; 12+ messages in thread

From: Robert Treat @ 2004-02-29 16:59 UTC (permalink / raw)
  To: Alex J. Avriette <alex@posixnap.net>; Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Mark Lubratt <mark.lubratt@indeq.com>; pgsql-hackers@postgreSQL.org

On Saturday 28 February 2004 21:23, Alex J. Avriette wrote:
> On Sat, Feb 28, 2004 at 10:39:40AM -0500, Tom Lane wrote:
> > >> Have you tried diffing pg_dump output?  It's not the greatest tool but
> > >> it's helpful.
> > >
> > > Yes, I did.  It was quite cumbersome.  Especially since the OIDs and
> > > TOC entry numbers didn't matchup; and, since those didn't always match,
> > > the order of objects wasn't quite the same either.  So, diff was
> > > throwing a lot of false positives at me.
> >
> > Yeah.  CVS-tip pg_dump doesn't show OIDs by default, to make it easier
> > to use for purposes like this.  The ordering issue is the bigger problem
> > though.  I presume that the object creation history is different in the
> > two databases and so pg_dump's habit of sorting by OID isn't helpful.
>
> I recently had to figure out what was different between the "live" schema
> and the schema in cvs at work. This was a really painful process, and it
> occurred to me that it wouldn't be terribly hard to write a perl program
> to do it (I wound up using vim and diff). Is there interest in such a tool?
> I could probably have one written within a day or two.
>

I've gone the vim-diff route in the past myself, but a nice command line tool 
to do it written in perl could certianly be nice. If nothing else you could 
toss it up on gborg.  Incidentally I think there is already a tool that does 
this on sourceforge, but it uses tcl and requires a running webserver, so 
it's a little overbearing for most peoples needs imho.

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-29 02:23     ` Re: [ADMIN] Schema comparisons Alex J. Avriette <alex@posixnap.net>
@ 2004-03-03 03:44       ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  2004-03-03 08:14         ` Re: [ADMIN] Schema comparisons Richard Huxton <dev@archonet.com>
  2 siblings, 1 reply; 12+ messages in thread

From: Christopher Kings-Lynne @ 2004-03-03 03:44 UTC (permalink / raw)
  To: Alex J. Avriette <alex@posixnap.net>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Mark Lubratt <mark.lubratt@indeq.com>; pgsql-hackers@postgresql.org

> I recently had to figure out what was different between the "live" schema
> and the schema in cvs at work. This was a really painful process, and it
> occurred to me that it wouldn't be terribly hard to write a perl program
> to do it (I wound up using vim and diff). Is there interest in such a tool?
> I could probably have one written within a day or two.

Someone wrote a utility called 'pgdiff' that generated the SQL commands 
necessary to transform on db in to another IIRC.

Chris




^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: [ADMIN] Schema comparisons
  2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
  2004-02-28 04:28 ` Re: Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-28 15:39   ` Re: [ADMIN] Schema comparisons Tom Lane <tgl@sss.pgh.pa.us>
  2004-02-29 02:23     ` Re: [ADMIN] Schema comparisons Alex J. Avriette <alex@posixnap.net>
  2004-03-03 03:44       ` Re: [ADMIN] Schema comparisons Christopher Kings-Lynne <chriskl@familyhealth.com.au>
@ 2004-03-03 08:14         ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 12+ messages in thread

From: Richard Huxton @ 2004-03-03 08:14 UTC (permalink / raw)
  To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; Alex J. Avriette <alex@posixnap.net>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Mark Lubratt <mark.lubratt@indeq.com>; pgsql-hackers@postgresql.org

On Wednesday 03 March 2004 03:44, Christopher Kings-Lynne wrote:
> > I recently had to figure out what was different between the "live" schema
> > and the schema in cvs at work. This was a really painful process, and it
> > occurred to me that it wouldn't be terribly hard to write a perl program
> > to do it (I wound up using vim and diff). Is there interest in such a
> > tool? I could probably have one written within a day or two.
>
> Someone wrote a utility called 'pgdiff' that generated the SQL commands
> necessary to transform on db in to another IIRC.

I think it was started, but didn't reach completion (if we're thinking about 
the same thing).

-- 
  Richard Huxton
  Archonet Ltd



^ permalink  raw  reply  [nested|flat] 12+ messages in thread


end of thread, other threads:[~2004-03-03 08:14 UTC | newest]

Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-28 03:32 Schema comparisons Mark Lubratt <mark.lubratt@indeq.com>
2004-02-28 04:28 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-02-28 15:39   ` Tom Lane <tgl@sss.pgh.pa.us>
2004-02-28 17:58     ` Michael Brusser <michael@synchronicity.com>
2004-02-28 17:59     ` Richard Huxton <dev@archonet.com>
2004-02-29 02:01       ` Tom Lane <tgl@sss.pgh.pa.us>
2004-02-29 14:08         ` Richard Huxton <dev@archonet.com>
2004-02-29 02:23     ` Alex J. Avriette <alex@posixnap.net>
2004-02-29 03:22       ` Tim Larson <tim@keow.org>
2004-02-29 16:59       ` Robert Treat <xzilla@users.sourceforge.net>
2004-03-03 03:44       ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2004-03-03 08:14         ` Richard Huxton <dev@archonet.com>

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