How to make replica pods as read replicas as I am using postgresql operator

PostgreSQL Percona Operator for PostgreSQL
1

We are having some performance issue as all request go to one one pod which is acting primary how I can make replica pods as read replicas. Is it something which can be done through pgbouncer?

2

Hi Ali,
You can check the following documentation page for more on this suject:

In particular, let me briefly do a partial quote here:

You can connect to the cluster without a proxy. […]
The cluster1-ha service points to the active primary. In case of failover to the replica node, will change the endpoint automatically. Also, you can use cluster1-replicas service to make read requests to PostgreSQL replica instances.

3

@alifaraz7178, in PGO 2.4.0, you will have the possibility to expose this service if needed. We will have a release tomorrow.