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
