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

About

PostgreSQL for Alpine Linux

Install
ansible-galaxy install alainvanhoof.alpine_postgresql
GitHub repository
License
Unknown
Downloads
60