Re: [GENERAL] Unable to start postgresql

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@iliffe.ca> 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@aklaver.com