Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base

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
>