2015-08-28 13:40 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com>:
> On 08/28/2015 07:09 AM, Anderson Abreu wrote: > >> >> 2015-08-28 10:55 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com >> <mailto:adrian.kla...@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. >> > > 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 >> andersonab...@gmail.com <mailto:andersonab...@gmail.com> >> <mailto:andersonab...@gmail.com <mailto:andersonab...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> >> >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
