|
Hi, I have been working on a project where I need to virtualize the postgresql standby server.
The wal receiver process listens to the Physical IP and a random port.
How can I configure it to listen to a VIP that the wal sender process can connect to? Also, Is there a way I can configure the port number for this? $ /usr/pgsql-12/bin/postgres -V postgres (PostgreSQL) 12.2 postgresql.conf: listen_addresses = '10.209.57.17'
This is the VIP $ ps -ef | grep post postgres 2945 1 0 05:37 ? 00:00:00 /usr/pgsql-12/bin/postgres
-D /pg_mnt/pg-12/data -h 10.209.57.17 postgres 2946 2945 0 05:37 ? 00:00:00
postgres: logger postgres 2947 2945 0 05:37 ? 00:00:00
postgres: startup recovering 000000010000000000000007 postgres 2952 2945 0 05:37 ? 00:00:00
postgres: checkpointer postgres 2953 2945 0 05:37 ? 00:00:00
postgres: background writer postgres 2954 2945 0 05:37 ? 00:00:00
postgres: stats collector postgres 2955 2945 0 05:37 ? 00:00:04
postgres: walreceiver $ netstat -anp | grep 55656 tcp 0 0
10.209.57.15:55656 10.209.57.16:5432
ESTABLISHED 2955/postgres: walr 10.209.57.15 is the physical IP $ ps -ef | grep 2955 postgres
2955 2945 0 05:37 ? 00:00:04 postgres: walreceiver Regards, Mariya |
