alainvanhoof.alpine_postgresql
Role Name
This role creates a running PostgreSQL instance or a running PostgreSQL cluster (2 nodes) on Alpine Linux
Requirements
To run the "agent-less" ansible against Alpine Linux it needs python3, sudo and iproute2 install (use apk).
Role Variables
- pg_primary: undefined
- pg_standby_addr: undefined
- pg_standby: undefined
- pg_primary_addr: undefined
- pg_version: "13"
- pg_db_name: "example"
- pg_db_user: "example"
- pg_db_pass: "example"
- pg_db_priv: "ALL"
- pg_db_encoding: "UTF8"
- pg_listen_addr: "'*'"
- pg_data_dir: "/var/lib/postgresql/{{ pg_version}}/data"
- pg_repl_user: "repl"
- pg_repl_pass: "repl"
Dependencies
Example Playbook
Create a cluster on dev-postgresql-01 and dev-postgresql-02 with a initial database test:
- hosts: dev-postgresql-01
become: true
roles:
- { role: alpine_postgresql, pg_primary: true, pg_standdy_addr: "IP or HOSTNAME of standby", pg_db_name: test, pg_db_user: testuser, pg_db_pass: testpass }
- hosts: dev-postgresql-02
become: true
roles:
- { role: alpine_postgresql, pg_standby: true, pg_primary_addr: "IP or HOSTNAME of primary" }
Create a standalone postgreSQL on dev-postgresql-03 listing only on localhost
- hosts: dev-postgresql-03
become: true
roles:
- { role: alpine_postgresql, pg_listen_addr: localhost, pg_db_name: test2, pg_db_user: test2user, pg_db_pass: test2pass }
License
BSD
Author Information
Alain van Hoof : alain+ansible@lafeberhof.nl
Install
ansible-galaxy install alainvanhoof.alpine_postgresql
License
Unknown
Downloads
60
Owner