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 04E8BD9ADD for ; Wed, 28 Sep 2005 16:34:38 -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 85992-01 for ; Wed, 28 Sep 2005 19:34:25 +0000 (GMT) Received: from ns01.qresc.com (ns01.qresc.com [212.244.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id A2E31D909E for ; Wed, 28 Sep 2005 16:34:24 -0300 (ADT) Received: from [127.0.0.1] (ip-85-198-229-198.broker.com.pl [85.198.229.198]) by ns01.qresc.com (8.13.4/8.13.4/Debian-3) with ESMTP id j8SJY9Xj008889 for ; Wed, 28 Sep 2005 21:34:15 +0200 Message-ID: <433AF032.3090305@qresc.com> Date: Wed, 28 Sep 2005 21:34:10 +0200 From: Sergiusz Jarczyk User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base References: <433AE636.7030506@comcast.net> In-Reply-To: <433AE636.7030506@comcast.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/311 X-Sequence-Number: 19048 Hi Jeffrey Jeffrey Tenny wrote: > 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. > Try to issue chown -R postgres.postgres /home/pgsql Sergiusz