Skip site navigation (1) Skip section navigation (2)

BUG #3034: FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied

From: "Jessica" <hxq7681(at)cs(dot)rit(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3034: FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
Date: 2007-02-19 21:53:26
Message-ID: 200702192153.l1JLrQhr029858@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3034
Logged by:          Jessica
Email address:      hxq7681(at)cs(dot)rit(dot)edu
PostgreSQL version: 8.2
Operating system:   Unix
Description:        FATAL:  could not open lock file
"/tmp/.s.PGSQL.5432.lock": Permission denied
Details: 

Hi there,

I installed PostgreSQL. It looked fine immediately after installation.
However, when reused it, I always couldn't start server. I had to reinstall
it again and again. This time I got erroe message as below: 
********
bash-3.00$ pg_ctl start -l logfile
server starting
bash-3.00$ pgsql testdb
bash: pgsql: command not found
bash-3.00$ psql testdb
psql: could not connect to server: Connection refused
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
bash-3.00$ pg_ctl stop
pg_ctl: PID file "/home/group/s772/p772-01f/pgsql/CLUST/sys/postmaster.pid"
does not exist
Is server running?
bash-3.00$
********

The logfile showed: 
*********
LOG:  could not bind IPv6 socket: Cannot assign requested address
HINT:  Is another postmaster already running on port 5432? If not, wait a
few seconds and retry.
FATAL:  could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
denied
LOG:  could not bind IPv6 socket: Cannot assign requested address
HINT:  Is another postmaster already running on port 5432? If not, wait a
few seconds and retry.
FATAL:  could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
denied
**********

I really felt unset. It never worked well. What is wrong?

Thanks.

Jessica

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2007-02-19 22:50:36
Subject: Re: "Julian day" date format is off by 12 hours
Previous:From: Bruce MomjianDate: 2007-02-19 21:25:36
Subject: Re: BUG #2969: Inaccuracies in Solaris FAQ

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group