Re: Execute DDL across multiple servers in an automated manner - Mailing list pgsql-general

From Anderson Abreu
Subject Re: Execute DDL across multiple servers in an automated manner
Date
Msg-id CANVXwmnHVkjyfNzVryh5FStFghkJhRj6hjP1ZdSos=jW66Yb1Q@mail.gmail.com
Whole thread Raw
In response to Re: Execute DDL across multiple servers in an automated manner  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Execute DDL across multiple servers in an automated manner
List pgsql-general

2015-08-28 10:55 GMT-03:00 Adrian Klaver <adrian.klaver@aklaver.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@gmail.com <mailto:andersonabreu@gmail.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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Execute DDL across multiple servers in an automated manner
Next
From: Nima Azizzadeh
Date:
Subject: Define two factor authentication for Postgresql Server