Postgres Pro
Downloads
Home   >   mailing lists

Thread: Startup Failure

Startup Failure

From
Joel Lansden
Date:
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

Re: Startup Failure

From
Lamar Owen
Date:
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

Is another postmaster running? (ps ax|grep postmaster)

Are the PostgreSQL RPM's that come with Mandrake 7 installed?
(rpm -qa|grep postgresql)

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Re: Startup Failure (stop failure ?)

From
Michael Holopainen
Date:
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|
--------------------------------------------------------------------