Skip site navigation (1) Skip section navigation (2)

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

From: Jeffrey Tenny <jeffrey(dot)tenny(at)comcast(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base
Date: 2005-09-28 22:03:33
Message-ID: 433B1335.70404@comcast.net (view raw or flat)
Thread:
Lists: pgsql-admin
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(dot)tenny(at)comcast(dot)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
> 

In response to

Responses

pgsql-admin by date

Next:From: Jeffrey TennyDate: 2005-09-29 01:11:49
Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base
Previous:From: Jeffrey TennyDate: 2005-09-28 21:42:30
Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group