pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hannes Dorbath <light@theendofthetunnel.de>
To: pgsql-admin@postgresql.org
Subject: Re: replication for hot-standby?
Date: Tue, 05 Jul 2005 10:00:06 +0200
Message-ID: <42ca35fb$0$22442$8fe63b2a@news.disputo.net> (raw)
In-Reply-To: <42C98FF3.80400@ca.afilias.info>
References: <42c54261$0$22444$8fe63b2a@news.disputo.net>
	<42C98FF3.80400@ca.afilias.info>

Yes, it does in /some way/, but it's quite hackish and error prone.. :/

> If there is anything broken about the script, or about how it executes on a particular node, this will cause the slon daemon for that node to panic and crash. If you restart the node, it will, more likely than not, try to repeat the DDL script, which will, almost certainly, fail the second time just as it did the first time.

> Unfortunately, this nonetheless implies that the use of the DDL facility is somewhat fragile and fairly dangerous.

> If your applications do not have fairly stable SQL schemas, then using Slony-I for replication is likely to be fraught with trouble and frustration.

Sorry, this really doesn't sound like something I'd like to use in a 
production environment..


On 04.07.2005 21:37, Brad Nicholson wrote:
> Slony handles schema changes:
> http://gborg.postgresql.org/project/slony1/genpage.php?slonik_commands#stmt_ddl_script 
> 



view thread (6+ messages)  latest in thread

Message-ID: <42ca35fb$0$22442$8fe63b2a@news.disputo.net>
Permalink:  ../42ca35fb$0$22442$8fe63b2a@news.disputo.net/
Also on:    postgresql.org/message-id/42ca35fb$0$22442$8fe63b2a@news.disputo.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: light@theendofthetunnel.de
  Subject: Re: replication for hot-standby?
  In-Reply-To: <42ca35fb$0$22442$8fe63b2a@news.disputo.net>
  References: <42c54261$0$22444$8fe63b2a@news.disputo.net> <42C98FF3.80400@ca.afilias.info> <42ca35fb$0$22442$8fe63b2a@news.disputo.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox