Create Red Hat-family Linux VMware Template for PostgreSQL 13

[kayiwa]

Our current Ubuntu Bionic PostgreSQL 13 server is past its end-of-life. To ensure continued support and security, we need to migrate to a new server based on a supported operating system. This issue outlines the creation of a Red Hat Linux VMware template to facilitate deployment of a replacement PostgreSQL 13 server in our vSphere environment.

Tasks:

• Create a Red Hat Linux VM (local)
• Convert the VM to a Template:
• Use the latest supported Red Hat Enterprise Linux release.
• Install and Configure PostgreSQL 13:
• Install the PostgreSQL 13 server software.
• Configure PostgreSQL for optimal performance and security, considering factors like:
• Authentication methods
• Database encoding
• Connection limits
• Documentation:
• Create documentation outlining the steps to deploy a new PostgreSQL 13 server from the template.

Acceptance Criteria:

• A Red Hat Linux VMware template is available in vSphere.
• The template includes a fully installed and configured PostgreSQL 13 server.

Benefits:

• Simplified Deployment: Streamlines the process of deploying new PostgreSQL 13 servers.
• Consistency: Ensures all new servers are configured identically, reducing potential for errors.
• Maintainability: Provides a centralized template for updates and modifications.
• Security: Utilizes a supported operating system with the latest security updates.

[acozine]

Confirmed today that Rocky Linux also installs PostgreSQL 13 by default, so we can use our existing Rocky template for this work.

[kayiwa]

Change names of db and role to avoid dashes

[acozine]

We also need to clean up the artifacts of the migration - we have records for ansible-db1 and postgres-prod-bionic, make sure both are gone.