Date: Wed, 13 Mar 2019 11:16:14 +0100
From: =?utf-8?B?U3TDqXBoYW5l?= KANSCHINE <stephane@hexack.fr>
To: Pierre Ochsenbein <pierreochsenbein@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pgsql auto
Message-ID: <20190313101613.tlmvr2pg3lwbbft6@office.hexack.fr>
References: 
 <CABG8FoM6su3RYFY-45P7z+joTWmUL3ef25s8gQurRV6uTC7u1w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CABG8FoM6su3RYFY-45P7z+joTWmUL3ef25s8gQurRV6uTC7u1w@mail.gmail.com>
Organization: HexACK
User-Agent: NeoMutt/20180716
Precedence: bulk

Le mar. 12 mars, vers 19:00, Pierre Ochsenbein exprimait :

> Hi,

Hey !

> I would like to build PostgreSQL (automation) with script like DbaaS
> (ansible).
> You recognize to create one database cluster per VM or multiple database
> clusters per VM, if yes how many?

You can do whatever you want, 1 cluster per database, 1 cluster per VM
or all in one according to your load or something in between.

I'm basically using a list of databases either in host_vars or inventories
and include_vars: dir: to create clusters and databases per host or per
environment.

To be more specific, this list is for a cluster name (default is main
on Debian) and this cluster is combined to a port variables to make
more clusters per host with 1 or more databases per host.

All this with streaming replication+wal shipping, backup and restore
configured properly for each cluster.

So what's your question about ansible ? :-)

Regards,
-- 
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
＠ stephane@hexack.fr
  +33 6 64 31 72 52