On 03/09/2017 08:14 AM, John Iliffe wrote:
On Thursday 09 March 2017 09:17:51 Adrian Klaver wrote:
On 03/08/2017 09:28 PM, Tom Lane wrote:
John Iliffe <john.iliffe@xxxxxxxxx> writes:
Comparing my results with Adrian's example, I notice that we both have the
Unix domain socket 5432 running (1) and we both have an IPv4 and an IPv6
socket open for postgres (3) and (5) BUT he has a couple of TCP sockets
that I don't have.(4) and (6) that are assigned specifically to 5442 in his
case. Shouldn't I have these same lines but assigned to 5432?
I'm assuming that there are two instances of postgresql running on his
machine (?) on sockets 5432 and 5442 (?).
My mistake, I should have mentioned there are indeed two instances of
Postgres running.
Here is my matching ss output
------------------------------
[root@prod04 John]# ss -l -p | grep post
u_str LISTEN 0 128 /tmp/.s.PGSQL.5432 69422 *
0 users:(("postgres",pid=2760,fd=5))
tcp LISTEN 0 128 127.0.0.1:postgres *:*
users:(("postgres",pid=2760,fd=4))
tcp LISTEN 0 128 ::1:postgres :::*
users:(("postgres",pid=2760,fd=3))
[root@prod04 John]#
---------------------------------
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
