README.md

init_dbserver

This Ansible Galaxy Role Initializes Postgres or EnterpriseDB Postgresql Advanced Server versions: 10, 11, 12, 13 and 14 on instances previously configured.

Not all Distribution or versions are supported on all the operating systems available.

For more details refer to the: Database engines supported section.

Note: The role does not configure Postgres nor EnterpriseDB Postgres Advanced Server for replication it only installs Postgres or EnterpriseDB Postgres Advanced Server across multiple nodes: Main and Standby. Should there be a need to configure a Postgres or EnterpriseDB Postgres Advanced Server Cluster for replication you can utilize the setup_replication role.

The ansible playbook must be executed under an account that has full privileges.

Requirements

The only dependencies required for this ansible galaxy role are:

1. Ansible
2. community.general Ansible Module - Utilized when creating aditional users during a Postgres Install. Only on primary nodes.
3. edb_devops.edb_postgres -> setup_repo - for repository installation
4. edb_devops.edb_postgres -> install_dbserver - for installation of PostgreSQL/EPAS binaries.

Role variables

When executing the role via ansible there are three required variables:

• pg_version

Postgres Versions supported are: 10, 11, 12, 13 and 14

• pg_type

Database Engine supported are: PG and EPAS

These and other variables can be assigned in the pre_tasks definition of the section: How to include the init_dbserver role in your Playbook

The rest of the variables can be configured and are available in the:

• roles/init_dbserver/vars/EPAS_Debian.yml
• roles/init_dbserver/vars/EPAS_RedHat.yml
• roles/init_dbserver/vars/PG_Debian.yml
• roles/init_dbserver/vars/PG_RedHat.yml

Dependencies

The init_dbserver role does not have any dependencies on any other roles.

Example Playbook

Inventory file content

Content of the inventory.yml file:

---
all:
  children:
    pemserver:
      hosts:
        pemserver1:
          ansible_host: xxx.xxx.xxx.xxx
          private_ip: xxx.xxx.xxx.xxx
    primary:
      hosts:
        primary1:
          ansible_host: xxx.xxx.xxx.xxx
          private_ip: xxx.xxx.xxx.xxx
          pem_agent: true
          pem_server_private_ip: xxx.xxx.xxx.xxx
    standby:
      hosts:
        standby1:
          ansible_host: xxx.xxx.xxx.xxx
          private_ip: xxx.xxx.xxx.xxx
          upstream_node_private_ip: xxx.xxx.xxx.xxx
          replication_type: synchronous
          pem_agent: true
          pem_server_private_ip: xxx.xxx.xxx.xxx
        standby2:
          ansible_host: xxx.xxx.xxx.xxx
          private_ip: xxx.xxx.xxx.xxx
          upstream_node_private_ip: xxx.xxx.xxx.xxx
          replication_type: asynchronous
          pem_agent: true
          pem_server_private_ip: xxx.xxx.xxx.xxx

How to include the init_dbserver role in your Playbook

Below is an example of how to include the init_dbserver role:

---
- hosts: primary,pemserver
  name: Initialize Postgres instances
  become: yes
  gather_facts: yes

  collections:
    - edb_devops.edb_postgres

  pre_tasks:
    - name: Initialize the user defined variables
      set_fact:
        pg_version: 14
        pg_type: "PG"

  roles:
    - initdb_dbserver

Defining and adding variables is done in the set_fact of the pre_tasks.

All the variables are available at:

• roles/init_dbserver/defaults/main.yml
• roles/init_dbserver/vars/EPAS_RedHat.yml
• roles/init_dbserver/vars/EPAS_Debian.yml
• roles/init_dbserver/vars/PG_RedHat.yml
• roles/init_dbserver/vars/PG_Debian.yml
• roles/init_dbserver/vars/edb-ssl.yml

Database engines supported

PostgreSQL

Distribution	10	11	12	13	14
CentOS 7	✅	✅	✅	✅	✅
Red Hat Linux 7	✅	✅	✅	✅	✅
RockyLinux 8	✅	✅	✅	✅	✅
Red Hat Linux 8	✅	✅	✅	✅	✅
Ubuntu 20.04 LTS (Focal) - x86_64	✅	✅	✅	✅	✅
Debian 9 (Stretch) - x86_64	✅	✅	✅	✅	✅
Debian 10 (Buster) - x86_64	✅	✅	✅	✅	✅

EnterpriseDB Postgres Advanced Server

Distribution	10	11	12	13	14
CentOS 7	✅	✅	✅	✅	✅
Red Hat Linux 7	✅	✅	✅	✅	✅
RockyLinux 8	❌	❌	✅	✅	✅
Red Hat Linux 8	❌	❌	✅	✅	✅
Ubuntu 20.04 LTS (Focal) - x86_64	❌	❌	❌	✅	✅
Debian 9 (Stretch) - x86_64	❌	✅	✅	✅	✅
Debian 10 (Buster) - x86_64	❌	❌	✅	✅	✅

• ✅ - Tested and supported

Playbook execution examples

# To deploy community Postgres version 13 with the user centos
$ ansible-playbook playbook.yml \
  -i inventory.yml \
  -u centos \
  --private-key <key.pem> \
  --extra-vars="pg_version=13 pg_type=PG"

# To deploy EPAS version 12 with the user ec2-user
$ ansible-playbook playbook.yml \
  -i inventory.yml \
  -u ec2-user \
  --private-key <key.pem> \
  --extra-vars="pg_version=12 pg_type=EPAS"

License

BSD

Author information

Author:

• Doug Ortiz
• Julien Tachoires
• Vibhor Kumar
• EDB Postgres
• DevOps
• edb-devops@enterprisedb www.enterprisedb.com