Postgresql won't start

[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

[scottwilkerson]

Can you verify the drive isn't full

Code: Select all

df -h
df -i

[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?

[lmiltchev]

This is strange. Can you run the following commands and show the output?

Code: Select all

ls -ld /tmp
chkconfig --list | grep postgres

[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

[scottwilkerson]

Lets also run

Code: Select all

ls -la /tmp/.s
chage -l postgres