Re: The state of PG replication in 2008/Q2?

[Mathias Stjernström <mathias@xxxxxxxxxxxxx>]

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: PGP.sig
Description: This is a digitally signed message part