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
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? |