Re: RFC tool to support development / operations work with slony replicated databases

From: Kenneth Downs <ken(at)secdat(dot)com>
To: Andrew Hammond <andrew(dot)george(dot)hammond(at)gmail(dot)com>
Cc: slony1-general(at)gborg(dot)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: RFC tool to support development / operations work with slony replicated databases
Date: 2007-03-06 13:44:11
Message-ID: 45ED702B.5040105@secdat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2007-03-06 13:48:05 Re: M:M table conditional delete for parents
Previous Message senges 2007-03-06 13:05:18 Re: Re : Re : COPY form stdin and file