Re: Replicating db structure changes - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Replicating db structure changes
Date
Msg-id 20070726095721.GB26612@svr2.hagander.net
Whole thread Raw
In response to Replicating db structure changes  (Robby Russell <robby.lists@planetargon.com>)
List pgsql-general
On Wed, Jul 25, 2007 at 09:08:56PM -0700, Robby Russell wrote:
> Hey all,
>
> I'm catching up the replication options for PostgreSQL and was looking
> at slony, but was wondering if I could get some pointers.
>
> If I understand the slony documentation correctly, it doesn't allow me
> to send CREATE/ALTER TABLE/INDEX statements to the master and have those
> replicate to the slaves. Am I mistaken? If this is the case, are there
> any alternatives to slony that would allow this to happen? We're using
> Rails migrations, which generate the corresponding SQL statements and
> then runs those against the production database. This works great, but
> we're not sure how to go about having those migrations properly affect
> slave databases, without running execute statements through slonik.
>
> Are there any other replication options that might work for what we're
> trying to do?

Are you looking for failover or loadsharing? If it's just failover, PITR
warm standby should have no problem with DDL. But you can't do queries
against the slave until after a failover...

//Magnus


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Replicating db structure changes
Next
From: Denis Gasparin
Date:
Subject: Postgresql over a SAN