| 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: | Whole Thread | Raw Message | 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"
| 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? |