2015-08-28 13:40 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 08/28/2015 07:09 AM, Anderson Abreu wrote:
2015-08-28 10:55 GMT-03:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>:
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.
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:
https://groups.google.com/forum/#!forum/sqitch-users
Other schema version systems I know of are Alembic(Python) Rails(ruby).
3) What Oses are you dealing with and what method of remote connection?
My OS is ubuntu 14.04 in two hundred servers
Probably should take a look at one of the automated deployment packages:
Chef https://www.chef.io/chef/
Puppet https://puppetlabs.com/
Salt http://saltstack.com/
There are probably others, these are just the ones I know about. They are general purpose tools but have Postgres specific features. As an examples:
http://docs.saltstack.com/en/latest/ref/modules/all/salt.modules.postgres.html
https://github.com/puppetlabs/puppetlabs-postgresql#custom-resource-postgresql_psql
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
Thanks all,
I try your suggestions
Regras
---
Anderson Abreu
andersonabreu@xxxxxxxxx <mailto:andersonabreu@xxxxxxxxx>
<mailto:andersonabreu@xxxxxxxxx <mailto:andersonabreu@xxxxxxxxx>>
"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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
