Re: Unable to start postgresql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to start postgresql
Date: 2017-03-08 15:00:01
Message-ID: 21002.1488985201@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Iliffe <john(dot)iliffe(at)iliffe(dot)ca> writes:
> When the programme exited it left another postmaster.pid file so I deleted
> that one too.

You haven't shown us the program actually exiting, and basically the only
way to get the postmaster to exit without removing its pid file is to
kill -9 it. Now I am suspicious that you in fact haven't killed any
postmasters, but only removed their pidfiles out from under them, which is
an incredibly dangerous thing to do. Check "ps ax" output to see if any
postgres processes are lurking in background.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-03-08 15:11:44 Re: Unable to start postgresql
Previous Message John McKown 2017-03-08 14:53:16 Re: import CSV file to a table