This is usually what happens after an unclean shutdown.
1) Make sure there are no postgres-owned processes running
2) remove the file
3) Restart PostgreSQL
Jon
On Mon, 14 Jul 2003, Zengfa Gao wrote:
> All,
>
> I am using PgSQL 7.3.1. After I application shutdown
> and restart, I can't get PgSQL restart again.
>
> Lock file "/tmp/.s.PGSQL.5432.lock" already exists.
> Is another postmaster (pid 1979) using
> "/tmp/.s.PGSQL.5432"?
> /opt/iexpress/postgresql/bin/postmaster: cannot create
> UNIX stream port
>
>
> Does anyone know what kind of operation can cause this
> error?
>
> Thanks a lot!
>
> Zengfa
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>