mannemsolutions / pgvillage Goto Github PK

Routing cluster with

• keepalived for VIP management (optional)
• haproxy and PgRoute66 for ReadOnly scalablity

Most Ansible-Galaxy roles are still private and should become public, posted on Ansible Galaxy.
Additionally, some Ansible-Galaxy roles have received (minor) edits that should be upstreamed.

Integrate PgQuartz:

• Create Ansible Galaxy Role
• Add to Playbook

Inspect existing Ansible Galaxy roles, or create your own
Implement in playbook

Use PgFga to manage authorization and Fine Grained Access with an LDAP.
This means:

• Create RPM
• Create an Ansible Galaxy Role
• Add to Ansible Playbook

The PgVillage Ansible playbook is internally available on private repos.
And it contains inventory information that should nog be public.
The playbook should be made public in this repo.

Mannem Solutions will provide all RPM's for tools that are not available as RPM just yet.
The repo will be publicly available. Fpr support, please reach out to us ([email protected]).

Create a HELM deployment for

• Stolon and Postgres
  • pgroute66 sidecar
• pgwatch2
• haproxy (optional)
• openldap (optionally)

• Create Ansible Galaxy role for PgWatch2
• Add grafana and PgWatch2 role to Ansible

Run with docker-compose on docker images:

• create docker images
• create docker-compose
• create docker-compose-test.sh
• part of CI/CD (github pipeline / git-flow: feature merge to dev branch)

Make #10 part of CI/CD in final release process:

• gitflow merge with release branch into master

For dev and demonstration purposes run front to back with AWS EC2 instances:

• stage the EC2 instances
• run Ansible to setup an environment