From: Stéphane KANSCHINE <stephane@hexack.fr>
To: Pierre Ochsenbein <pierreochsenbein@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pgsql auto
Date: Wed, 13 Mar 2019 11:16:14 +0100
Message-ID: <20190313101613.tlmvr2pg3lwbbft6@office.hexack.fr> (raw)
In-Reply-To: <CABG8FoM6su3RYFY-45P7z+joTWmUL3ef25s8gQurRV6uTC7u1w@mail.gmail.com>
References: <CABG8FoM6su3RYFY-45P7z+joTWmUL3ef25s8gQurRV6uTC7u1w@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stephane@hexack.fr, pierreochsenbein@gmail.com
Subject: Re: pgsql auto
In-Reply-To: <20190313101613.tlmvr2pg3lwbbft6@office.hexack.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox