Here's the /var/lib/pgsql/data directory ('.')
-bash-3.00$ ls -ldZ
drwx------ postgres postgres system_u:object_r:postgresql_db_t .
Here are the children:
-bash-3.00$ ls -ldZ *
lrwxrwxrwx postgres postgres user_u:object_r:postgresql_db_t base ->
/home/pgsql/base
drwx------ postgres postgres root:object_r:postgresql_db_t global
drwx------ postgres postgres root:object_r:postgresql_db_t pg_clog
-rw------- postgres postgres user_u:object_r:postgresql_db_t pg_hba.conf
-rw------- postgres postgres user_u:object_r:postgresql_db_t pg_hba.conf~
-rw------- postgres postgres root:object_r:postgresql_db_t pg_ident.conf
drwx------ postgres postgres root:object_r:postgresql_db_t pg_log
drwx------ postgres postgres root:object_r:postgresql_db_t pg_subtrans
drwx------ postgres postgres root:object_r:postgresql_db_t pg_tblspc
-rw------- postgres postgres root:object_r:postgresql_db_t PG_VERSION
drwx------ postgres postgres root:object_r:postgresql_db_t pg_xlog
-rw------- postgres postgres user_u:object_r:postgresql_db_t
postgresql.conf
-rw------- postgres postgres user_u:object_r:postgresql_db_t
postgresql.conf~
-rw------- postgres postgres root:object_r:postgresql_db_t
postmaster.opts
-bash-3.00$ ls -ldZ /home/pgsql
drwx------ postgres postgres root:object_r:user_home_dir_t /home/pgsql
-bash-3.00$ ls -ldZ /home/pgsql/base
drwx------ postgres postgres root:object_r:postgresql_db_t
/home/pgsql/base
-bash-3.00$ ls -ldZ /home/pgsql/base/*
drwx------ postgres postgres root:object_r:postgresql_db_t
/home/pgsql/base/1
drwx------ postgres postgres root:object_r:postgresql_db_t
/home/pgsql/base/17229
drwx------ postgres postgres system_u:object_r:postgresql_db_t
/home/pgsql/base/17230
drwx------ postgres postgres system_u:object_r:postgresql_db_t
/home/pgsql/base/29144
drwx------ postgres postgres system_u:object_r:postgresql_db_t
/home/pgsql/base/29149
Somewhere in here is probably the clue, and a 'chcon' is probably
necessary. I'm clueless about selinux though and have no idea what to do.
Tom Lane wrote:
> Jeffrey Tenny <jeffrey.tenny@comcast.net> writes:
>
>>Sorry, I take that back. The platform is Fedora Core 4, so SELinux may
>>be a concern, though during the installation I selected all the minimal
>>options for SELinux because I wasn't prepared to deal with it.
>
>
> Better check what /usr/sbin/getenforce tells you, then... or look in
> /var/log/messages to see if the postmaster's operations are being
> refused.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>