Re: RFC tool to support development / operations work with slony replicated databases - Mailing list pgsql-general

From Kenneth Downs
Subject Re: RFC tool to support development / operations work with slony replicated databases
Date
Msg-id 45ED702B.5040105@secdat.com
Whole thread Raw
In response to RFC tool to support development / operations work with slony replicated databases  ("Andrew Hammond" <andrew.george.hammond@gmail.com>)
Responses Re: RFC tool to support development / operations work with slony replicated databases
List pgsql-general
Andrew Hammond wrote:
> Each release will include a directory that has the same name as the
> full release tag. This directory must contain all the scripts to be
> applied.

Have you considered using a data dictionary instead, so that you can
simply diff the structures and generate DDL to bring a database to its
current state?

If your scripts contain data modification code, they can be preserved,
but using a dictionary smooths over a lot of the quirkiness of the
scripts-based approach.


--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
Office: 631-689-7200   Cell: 631-379-0010

::Think you may have a problem with programming? Ask yourself this
::question: do you worry about how to throw away a garbage can?


pgsql-general by date:

Previous
From: "senges"
Date:
Subject: Re: Re : Re : COPY form stdin and file
Next
From: Kenneth Downs
Date:
Subject: Re: M:M table conditional delete for parents