Page 1 of 1
Postgresql won't start
Posted: Sun Mar 31, 2013 12:50 am
by justine
All service are running after restart except for Postresql.
Error found in /var/lib/pgsql/data/pgstartup.log is FATAL: could not open lock file '/tmp/.s/PGSQL.5432.lock": Permission denied
Please help on how to resolve this.
Thanks
Re: Postgresql won't start
Posted: Mon Apr 01, 2013 6:47 am
by scottwilkerson
Can you verify the drive isn't full
Re: Postgresql won't start
Posted: Mon Apr 01, 2013 8:36 pm
by justine
Here's the result.
df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
127G 36G 85G 30% /
/dev/sda1 99M 13M 82M 13% /boot
tmpfs 2.0G 0 2.0G 0% /dev/shm
tmpfs 250M 6.8M 244M 3% /var/nagiosramdisk
df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/mapper/VolGroup00-LogVol00
34308096 166696 34141400 1% /
/dev/sda1 26104 35 26069 1% /boot
tmpfs 219998 1 219997 1% /dev/shm
tmpfs 219998 54 219944 1% /var/nagiosramdisk
It still have enough space.
It occurred after shutting down the machine. Permissions has been lost after restart.
What could have caused this?
Re: Postgresql won't start
Posted: Tue Apr 02, 2013 10:19 am
by lmiltchev
This is strange. Can you run the following commands and show the output?
Code: Select all
ls -ld /tmp
chkconfig --list | grep postgres
Re: Postgresql won't start
Posted: Fri May 10, 2013 4:04 am
by justine
Here it is.
drwxrwxrwt 13 root root 20480 May 10 16:35 /tmp
and
postgresql 0:off 1:off 2:off 3:on 4:off 5:on 6:off
Re: Postgresql won't start
Posted: Fri May 10, 2013 10:02 am
by scottwilkerson