How to configure PostgreSQL primary-standby configuration in Percona-pmm server.

Percona Monitoring and Management (PMM) PMM 2.x
1

Hi Team,

We are planning to use Pmm-Percona as monitoring for our Postgres servers. I could see service creation for standalone Postgres instance only. But our requirement is we have Primary PostgreSQL instance ( docker container - docker host1) and Standby PostgreSQL instance ( docker container - docker host2). How we can configure both as single cluster (primary-standby), so if any failover or switchover cases monitoring will be efficient.

2

Hello @vasu PMM does not support the creation of primary-standby PostgreSQL servers. You must do this externally. Check out Avi’s blog post, https://www.percona.com/blog/2019/10/11/how-to-set-up-streaming-replication-in-postgresql-12/