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 698D1D9B51 for ; Wed, 28 Sep 2005 22:11:51 -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 08303-08 for ; Thu, 29 Sep 2005 01:11:47 +0000 (GMT) Received: from sccrmhc14.comcast.net (sccrmhc14.comcast.net [204.127.202.59]) by svr1.postgresql.org (Postfix) with ESMTP id 3C578D9AFA for ; Wed, 28 Sep 2005 22:11:48 -0300 (ADT) Received: from [192.168.1.52] (c-65-96-235-5.hsd1.ma.comcast.net[65.96.235.5]) by comcast.net (sccrmhc14) with ESMTP id <2005092901115201400pvprje>; Thu, 29 Sep 2005 01:11:52 +0000 Message-ID: <433B3F55.2040407@comcast.net> Date: Wed, 28 Sep 2005 21:11:49 -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: Jeffrey Tenny Cc: Tom Lane , 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> <433B1335.70404@comcast.net> In-Reply-To: <433B1335.70404@comcast.net> 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.448 required=5 tests=[AWL=-0.420, DNS_FROM_RFC_POST=1.376, DNS_FROM_RFC_WHOIS=0.492] X-Spam-Level: * X-Archive-Number: 200509/323 X-Sequence-Number: 19060 I tried a few: chcon -t postgresql_db_t /home/pgsql type things. No luck. It's interesting that there are no permission denials logged in /var/log/messages, but postgresql says it can't access /var/lib/pgsql/data/base because permission is denied (in the postgres log). I played with the symlink chcon user, and the /home/pgsql user as well (again, chcon, not chown). It's clearly selinux though. If I do this: /usr/sbin/setenforce 0 Then everything works peachy for my testing. But turning off selinux is probably a one way road, since all files created in that environment won't have their context set. So I really need to solve this in the correct fashion. For now I'll run with the database files under /var/lib/pgsql/data until I (or someone else) can figure out the selinux/postgresql magic.