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 9E9C8D9A21 for ; Wed, 28 Sep 2005 15:51:40 -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 76545-01 for ; Wed, 28 Sep 2005 18:51:37 +0000 (GMT) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [63.240.76.21]) by svr1.postgresql.org (Postfix) with ESMTP id E8B47D994E for ; Wed, 28 Sep 2005 15:51:37 -0300 (ADT) Received: from [192.168.1.52] (c-65-96-235-5.hsd1.ma.comcast.net[65.96.235.5]) by comcast.net (sccrmhc11) with ESMTP id <2005092818513501100ltv9ee>; Wed, 28 Sep 2005 18:51:36 +0000 Message-ID: <433AE636.7030506@comcast.net> Date: Wed, 28 Sep 2005 14:51:34 -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: pgsql-admin@postgresql.org Subject: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base 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.635 required=5 tests=[AWL=-0.233, DNS_FROM_RFC_POST=1.376, DNS_FROM_RFC_WHOIS=0.492] X-Spam-Level: * X-Archive-Number: 200509/309 X-Sequence-Number: 19046 I'm trying to move my databases to another drive. With postmaster off, I create: /home/pgsql mv /var/lib/pgsql/data/base /home/pgsql/ I make sure that /home/pgsql is owned by postgres, and only 'rwx' for the owner. All the permissions look fine. from /var/lib/pgsql/data, I do ln -s /home/pgsql/base Of course the link permissions look like: lrwxrwxrwx 1 postgres postgres 16 Sep 28 14:21 base -> /home/pgsql/base The postmaster starts, but attempts to access the database complain that permission is denied: $ psql -l psql: FATAL: could not access directory "/var/lib/pgsql/data/base/1": Permission denied Any clues about why this won't work? I've searched the archives, but most references were to invalid permissions on the directories and I'm pretty sure I've got those right. All my pgsql dirs look pretty much like: drwx------ 3 postgres postgres 4096 Sep 28 14:21 pgsql Both in the original /var/lib/pgsql area, and the /home/pgsql area.