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|
--------------------------------------------------------------------