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