There is a perm problem on pgsql data directory, when using msec 'restricted'
permission setting:
[root@silbermann xml-spec]# /usr/bin/postmaster does not find the database
system.
Expected to find it in the PGDATA directory "/var/lib/pgsql/data",
but unable to open file "/var/lib/pgsql/data/global/pg_control":
Permission denied
The following modification to /etc/init.d/postgresql script should solve it:
[root@silbermann xml-spec]# diff -Naur /etc/init.d/postgresql
/etc/init.d/postgresql.new
--- /etc/init.d/postgresql Mon Nov 19 15:34:02 2001
+++ /etc/init.d/postgresql.new Mon Nov 19 15:34:11 2001
@@ -108,7 +108,7 @@
if [ ! -d $PGDATA ]
then
mkdir -p $PGDATA
- chown postgres.postgres $PGDATA
+ chown -R postgres.postgres $PGDATA
fi
# Make sure the locale from the initdb is preserved for later
startups...
[ -f /etc/sysconfig/i18n ] && cp /etc/sysconfig/i18n
$PGDATA/../initdb.i18n
--
Guillaume Rousse <[EMAIL PROTECTED]>
GPG key http://lis.snv.jussieu.fr/~rousse/gpgkey.html
