Re: Replication options? - Mailing list pgsql-general

From Christopher Browne
Subject Re: Replication options?
Date
Msg-id m3acx04963.fsf@wolfe.cbbrowne.com
Whole thread Raw
In response to Re: Replication options?  ("Liam Lesboch" <liamlesboch@hotmail.com>)
List pgsql-general
After a long battle with technology, JanWieck@Yahoo.com (Jan Wieck), an earthling, wrote:
> Another important difference is automatic replication of schema
> changes. This is a feature often asked for, and I have no idea where
> that wish comes from.

It actually looks like quite a positive thing to apply "univeral
schema" changes via something like the following:

EXECUTE SCRIPT (
    SET ID = 1,
    FILENAME = '2004-08-21-add-two-tables-and-7-indices.sql',
    EVENT NODE = 1
);

This approach imposes a certain amount of "discipline" on how things
are done, which seems like a feature, as opposed to a bug...
--
output = reverse("gro.gultn" "@" "enworbbc")
http://www.ntlug.org/~cbbrowne/linux.html
There is a theory that states: "If anyone finds  out what the universe
is for, it will disappear and  be replaced by something more bizarrely
inexplicable." There is another theory  that states: "This has already
happened..." -Douglas Adams, "Hitch-Hikers Guide to the Galaxy"

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Access restrictions on rows depending on value of the a column
Next
From: Robby Russell
Date:
Subject: Re: upgrading in RH 8