X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E35A4D9B2D for ; Wed, 28 Sep 2005 19:03:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62616-04 for ; Wed, 28 Sep 2005 22:03:32 +0000 (GMT) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [63.240.76.28]) by svr1.postgresql.org (Postfix) with ESMTP id 08CE8D9B20 for ; Wed, 28 Sep 2005 19:03:33 -0300 (ADT) Received: from [192.168.1.52] (c-65-96-235-5.hsd1.ma.comcast.net[65.96.235.5]) by comcast.net (sccrmhc13) with ESMTP id <2005092822033401300fqe2ee>; Wed, 28 Sep 2005 22:03:34 +0000 Message-ID: <433B1335.70404@comcast.net> Date: Wed, 28 Sep 2005 18:03:33 -0400 From: Jeffrey Tenny User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.11) Gecko/20050729 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base References: <433AE636.7030506@comcast.net> <8410.1127936570@sss.pgh.pa.us> <433B07F2.40906@comcast.net> <433B086D.7020709@comcast.net> <5092.1127943195@sss.pgh.pa.us> In-Reply-To: <5092.1127943195@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.453 required=5 tests=[AWL=-0.415, DNS_FROM_RFC_POST=1.376, DNS_FROM_RFC_WHOIS=0.492] X-Spam-Level: * X-Archive-Number: 200509/322 X-Sequence-Number: 19059 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 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 >