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
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 |