From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unable to start postgresql |
Date: | 2017-03-08 16:37:27 |
Message-ID: | f0d5a55b-29ec-1fac-5553-8e7e77b5fe5a@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/08/2017 07:37 AM, John Iliffe wrote:
> On Wednesday 08 March 2017 00:01:32 Tom Lane wrote:
>> John Iliffe <john(dot)iliffe(at)iliffe(dot)ca> writes:
>>> Now, running as user postgres I try and start as stated in the manual
>>> postgres -D /usr/pgsql_tablespaces
>>>
>>> The result is:
>>> [postgres(at)prod04 postgresql-9.6.2]$ postgres -D /usr/pgsql_tablespaces
>>> LOG: could not bind IPv4 socket: Cannot assign requested address
>>> HINT: Is another postmaster already running on port 5432? If not,
>>> wait a few seconds and retry.
>>> LOG: database system was shut down at 2017-03-07 22:22:57 EST
>>> LOG: MultiXact member wraparound protections are now enabled
>>> LOG: database system is ready to accept connections
>>> LOG: autovacuum launcher started
>>
>> To clarify: the postmaster *is* starting here. It failed to bind to the
>> IPv4 port 5432, but it must have succeeded in binding to at least one
>> other port (IPv6 and/or a Unix socket), else it would have stopped and
>> you'd have not seen the last four log lines.
>>
>> It might be helpful to check with lsof to see what the postmaster
>> process has open after you do this.
>>
> I noticed that when I deleted the postmaster.pid file as suggested by
> another answer and restarted that process issued a lot more messages before
> crashing :-( Still couldn't connect to port 5432 though.
Meant to ask before, can you show the command you are using to connect?
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2017-03-08 16:45:09 | Re: import CSV file to a table |
Previous Message | Karl Czajkowski | 2017-03-08 16:36:25 | Re: import CSV file to a table |