Lock file "/tmp/.s.PGSQL.5432.lock" already exists.
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
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:
Show quoted text
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 portDoes 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)