I'm looking for somepackage/library/plugintoexecute DDLacross multiple serversin an automated manner.
This covers a lot of ground. Could you be more specific:
1) Do you have a preferred programmng/scripting language?
No, I don't have a preferred language. I thought in a package similar the pgbouncer.
So something where you point at a database proxy and it would distribute the changes to all the databases behind it?
I don't know of such a thing, but maybe someone else does.
2) Are you trying to schema versioning or are you rolling out complete packages?
Well, a schema versioning is interesting. Exists any package to postgresql?
I just finished a schema version change using Sqitch(http://sqitch.org/) It is not Postgres specific, but that is what I am deploying against. My needs are simple and I am not deploying against two hundred servers. There may be way to make that work using Sqitch, but that would probably be a question for the Sqitch list:
"Thejudokaiswhathas:humilitytolearnwhatyouteach,patienceto teachwhat theylearnedtotheir fellow manandfaithtobelieve in whatyou don't understand.Learna little more every dayanduse it every dayfor the good"(Jigoro Kano)