Re: Replication options?

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Replication options?
Date: 2004-08-12 16:23:48
Message-ID: m3acx04963.fsf@wolfe.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

After a long battle with technology, JanWieck(at)Yahoo(dot)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"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-08-12 16:23:49 Re: Clustering, mirroriing, or replication?
Previous Message Jon Brisbin 2004-08-12 16:03:46 Re: Clustering, mirroriing, or replication?