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 18:34:18 |
Message-ID: | c89feb8b-7bdf-fed0-eac3-1200065a4d98@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/08/2017 10:25 AM, John Iliffe wrote:
> On Wednesday 08 March 2017 11:37:27 Adrian Klaver wrote:
>> 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?
>
> Yes:
>
> [postgres(at)prod04 John]$ pg_ctl start -D /usr/pgsql_tablespaces
This is the command to start Postgres.
>
> I tried psql but it won't work, as expected, because socket 5432 is not
> available.
So what is the psql connection command you are using and what is the
error message you are getting?
>
> John
>
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2017-03-08 19:37:52 | Re: too may LWLocks |
Previous Message | John Iliffe | 2017-03-08 18:25:19 | Re: Unable to start postgresql |