Re: Startup Failure (stop failure ?) - Mailing list pgsql-admin

From Michael Holopainen
Subject Re: Startup Failure (stop failure ?)
Date
Msg-id 39698D5F.B9D62EC2@laserle.fi
Whole thread Raw
In response to Startup Failure  (Joel Lansden <joel@bhampc.com>)
List pgsql-admin
A stupid question :
did you see if there was a postmaster process running ?


I had this problem that I was unable to kill the postmaster process
(with 'kill -9 ...')
1. I stooped the postgres with '/etc/rc.d/postgres stop' that reported
that it was done ok. Then when I tried to start it again a got
'postmaster allready running' and 'ps aux | grep postmaster' I found out
that it was still running.
2. I tried with 'kill -9' -> still running.
3. then I tried init 2 -> init 1 -> init S  = still running
4. reboot reported that postgres directory was still in use when it
unmounted it.

!!!??????

It has not reoccurred. it's been week now.


Joel Lansden wrote:
>
> Greetings all -
>
> when I attempt to start my Postgresql-7.0.2 server I receive the following
> error:
>
> FATAL: StreamServerPort: bind() failed: Operation not permitted
>          Is another postmaster already running on that port?
>          If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
> /usr/local/pgsql/bin/postmaster: cannot create UNIX stream port
>
> I am running Mandrake Linux 7.0 with kernel 2.3.50 on a dual Pentium 200
> MMX system, 256Mb RAM.
>
> Thanks in advance for any help!
>
> Joel

--
   --"Would you fly on airplane controlled by MS Windows ?"--
--------------------------------------------------------------------
| Michael Holopainen | Valuraudantie 25 | Tel: +358-(0)9-35093825  |
|                    | 00700 Helsinki   | Fax : +358-(0)9-35093850 |
| Laserle Oy         | Finland          | email: michael@laserle.fi|
--------------------------------------------------------------------

pgsql-admin by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Startup Failure
Next
From: Karl Schmid
Date:
Subject: Problem with installing the data directory