Wal receiver process listens to physical IP

From: Mariya Rampurawala <Mariya(dot)Rampurawala(at)veritas(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Wal receiver process listens to physical IP
Date: 2020-03-20 11:27:24
Message-ID: E63F940F-BE75-4ABD-ADAA-F4F58EBF2854@veritas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2020-03-20 12:39:01 Re: Could postgres12 support millions of sequences? (like 10 million)
Previous Message Gergely Riskó 2020-03-20 11:22:51 promise postgres that I will only ROLLBACK