Re: Execute DDL across multiple servers in an automated manner

On 08/28/2015 07:09 AM, Anderson Abreu wrote:

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

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

        ---

        Anderson Abreu
        andersonabreu@gmail.com <mailto:andersonabreu@gmail.com>
        <mailto: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 <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com