Wierd problem with postgresql

[Linuxer Wang]

Jeff Vian wrote:

>On Sat, 2005-09-17 at 09:14 -0700, Linuxer Wang wrote:
>  
>
>>Hello, all
>>
>>I am using Fedora Core 4 and the pre-installed postgresql 8.0.3.
>>
>>I don't want to lost my data when I reinstall fedora next time, so I
>>decide to create a new database under /opt.
>>So I changed the service startup script /etc/init.d/postgresql, and it
>>successfully init the database and ran well.
>>But after reboot the system, I found the service startup failed. The
>>error message is "postmaster cannot access
>>the server configuration file "/var/lib/pgsql/data/postgresql.conf"
>>Permission denied. And after the system start and
>>login with root, the command "service postgresql start" can succeed.
>>
>>I also did the following test:
>>Disable the postgresql service, and put a line to /etc/rc.local:
>>runuser -l postgres -c "/usr/bin/postmaster -D /opt/postgresql/data &"
>>
>>When the system reboot, it failed to startup again, and the error
>>message is the same. But after login with root,
>>the above command can be successfully executed.
>>
>>Can anyone give me some hint to this problem?
>>
>>    
>>
>Probably not a weird issue at all.  You created the new database and
>have run the server as root. Permissions likely prevent it from running
>as postgres.
>
>Check the ownership/permissions of the /var/lib/pgsql tree (On mine that
>directory is postgres:postgres with 0700 permissions) and make sure the
>new tree all the way down is the same so it can run as postgres.
>
>  
>
I checked, but the /var/lib/pgsql only contains two empty folders, and
the permissions are correct.
The problem is that after the system start and login with root, it can
use "runuser -l postgres" to start the server,
but it can't be started in the service or /etc/rc.local.

BTW, I check the /opt/postgresql tree, the permission is also correct
for the whole tree.

Thanks,