Re: The state of PG replication in 2008/Q2? - Mailing list pgsql-performance

From Mathias Stjernström
Subject Re: The state of PG replication in 2008/Q2?
Date
Msg-id F17C0F9D-E851-471D-85DC-5F9EDBD68E1B@globalinn.com
Whole thread Raw
In response to Re: The state of PG replication in 2008/Q2?  (salman <salmanb@quietcaresystems.com>)
List pgsql-performance
Yup, but sometimes you are not in charge of the DDL changes. You may
have many different users that make changes or for example if you are
working with Ruby On Rails you have something thats called Migrations
that handles all DDL changes in those situations it can get really
complicated with those slony scripts. My experience is that automatic
handling of DDL changes is a very important feature of a replication
system of curse not in all systems but in many.

I am also very interested in the WAL replication that David Lang asked
about.

Best regards,
Mathias Stjernström

http://www.pastbedti.me/



On 21 aug 2008, at 23.26, salman wrote:

>
>
> Mathias Stjernström wrote:
>> Yes thats true. It does support DDL changes but not in a automatic
>> way. You have to execute all DDL changes with a separate script.
>
> That's true, but it's quite simple to do with the provided perl
> script(s) - slonik_execute_script. I've had to make use of it a few
> times and have had no problems.
>
> -salman


Attachment

pgsql-performance by date:

Previous
From: RW
Date:
Subject: Re: The state of PG replication in 2008/Q2?
Next
From: Moritz Onken
Date:
Subject: Re: Slow query with a lot of data