Hi,
I know this isn't directly a postgres issue, but it might help a few
other users, so here goes.
I did an upgrade on my Fedora Core 4 system, and postgres (8.1.2 from
the postgres packages, not FC packages) stopped working because of
permission issues when trying to create postmaster.pid in the
/var/lib/pgsql/data directory. My system has SELinux active, and it
used to work until now.
So I upgraded using the latest 8.1.3 release (I built it from SRPMs as
an x86_64 binary wasn't available), hoping it will help. It didn't.
I researched it a bit, and tried a few things, and discovered that the
problem is in the init script at /etc/init.d/postgres users runuser
instead of su on SELinux enabled systems. But for some reason it won't
work this way. I manually reveted it to use su and it works fine.
It anyone knows of a better fix - please let me know.
Thanks,
Guy.
---
Family management on postgres+rails: http://www.famundo.com - coming soon!