Re: Execute DDL across multiple servers in an automated manner

2015-08-28 10:55 GMT-03:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> On 08/28/2015 06:35 AM, Anderson Abreu wrote:
>
>> Hi all,
>>
>> I usePostgreSQL9.4
>>
>> 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.

>
> 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?

>
> 3) What Oses are you dealing with and what method of remote connection?
>

My OS is ubuntu 14.04 in two hundred servers

>
> 4) Are the servers all the same version of Postgres(or are they even all
> Postgres servers), so do you have to take into account version differences?
>

All servers are in same version, PostgreSQL 9.4.

Thanks & Regards,
Anderson Abreu

>
>
>
>> Can do thiswithshellscript.
>>
>> I would like to knowifthis is the only way?
>>
>
> No, that is the problem:)
>
>
>>
>> Thanks & Regards
>>
>>
>> ---
>>
>> Anderson Abreu
>> andersonabreu(at)gmail(dot)com <mailto:andersonabreu(at)gmail(dot)com>
>>
>> "Thejudokaiswhathas:humilitytolearnwhatyouteach,patienceto teachwhat
>> theylearnedtotheir fellow manandfaithtobelieve in whatyou don't
>> understand.Learna little more every dayanduse it every dayfor the
>> good"(Jigoro Kano)
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>