When Postgres stopped running abnormaly, it didnt remove the file
/tmp/.s.PGSQL.5432
When you start Postgres it checks to see if this file exists.
If it finds it, it asks you to verify that postgres is not already running
If it is not, delete the file
Is another postmaster already running on that port?
If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
rm /tmp/.s.PGSQL.5432
Vince
> -----Original Message-----
> From: owner-pgsql-general@postgresql.org
> [mailto:owner-pgsql-general@postgresql.org]On Behalf Of Manuel Cabido
> Sent: Monday, January 24, 2000 4:59 PM
> To: pgsql-general@hub.org
> Cc: pgsql-general-digest@hub.org
> Subject: [GENERAL] Re: pgsql-general-digest V1 #614
>
>
> Sir,
>
> I encountered a problem when my postgres 6.5.3 stop running. I
> attempted to run the postmaster but an error was displayed on
> my screen
> which goes like this:
>
> [root@hindang bin]# /etc/rc.d/init.d/postgresql restart
> Stopping postgresql service:
> [FAILED]
> Checking postgresql installation: looks good!
> Starting postgresql service: FATAL: StreamServerPort: bind() failed:
> Permission
> Is another postmaster already running on that port?
> If not, remove socket node (/tmp/.s.PGSQL.5432) and retry.
> /usr/bin/postmaster: cannot create UNIX stream port
> failed.
>
> I would appreciate it very much if you can help me fix
> this problem.
>
> Manny C. Cabido
> ====================================
> e-mail:manny@tinago.msuiit.edu.ph
> manny@sun.msuiit.edu.ph
> =====================================
>
>
>
> ************
>