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