Re: Database schema & data synchronizer software for PostgreSQL?

From: Együd Csaba <csegyud(at)gmail(dot)com>
To: "'ries van Twisk'" <pg(at)rvt(dot)dds(dot)nl>
Cc: "'Robert Treat'" <xzilla(at)users(dot)sourceforge(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database schema & data synchronizer software for PostgreSQL?
Date: 2009-01-21 05:51:40
Message-ID: 00f601c97b8c$55a89800$00f9c800$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>dbsolo does a decent job.
>I think they main thing here is to check for inconsistencies and see
>what they are, rather
>then a tool that takes over the administrative task.
>
>We all understand David's point of view, but it can't hurt to have a
>tool in place that can verify the consistency of both schema's.
>
>Ries
>
Ries,
I meant definitely this, thanks.
DB Solo is really does a nice job. I found only two minor problems in the
sync script:
1. It put a create trigger... statement before it created the
trigger function itself -
moved to the end of the script
2. I tried to alter column a time column to timestampz which
resulted in an error
message.

I corrected these two things and the database is OK now. I'm absolutely
happy with this level of automation.

Thank you all for your suggestions,

--Csaba

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-01-21 07:03:03 Re: Custom type, operators and operator class not sorting/indexing correctly
Previous Message ries van Twisk 2009-01-21 05:10:21 Re: Database schema & data synchronizer software for PostgreSQL?