pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql auto 2+ messages / 2 participants [nested] [flat]
* pgsql auto @ 2019-03-12 18:00 Pierre Ochsenbein <pierreochsenbein@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Pierre Ochsenbein @ 2019-03-12 18:00 UTC (permalink / raw) To: pgsql-admin Hi, 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? Example: postgresql1 > host1 postgresql2 > host1 postgresql3 > host2 postgresql4 > host2 or postgresql1 > host1 postgresql2 > host2 postgresql3 > host3 postgresql4 > host4 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgsql auto @ 2019-03-13 10:16 Stéphane KANSCHINE <stephane@hexack.fr> parent: Pierre Ochsenbein <pierreochsenbein@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Stéphane KANSCHINE @ 2019-03-13 10:16 UTC (permalink / raw) To: Pierre Ochsenbein <pierreochsenbein@gmail.com>; +Cc: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2019-03-13 10:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2019-03-12 18:00 pgsql auto Pierre Ochsenbein <pierreochsenbein@gmail.com> 2019-03-13 10:16 ` Stéphane KANSCHINE <stephane@hexack.fr>
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