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 9D27AD6815 for ; Tue, 8 Nov 2005 14:21:33 -0400 (AST) 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 73994-06 for ; Tue, 8 Nov 2005 18:21:31 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by svr1.postgresql.org (Postfix) with ESMTP id CBAAAD7B39 for ; Tue, 8 Nov 2005 14:21:31 -0400 (AST) Received: obelix.askesis.nl 172.31.0.1 from 172.31.1.8 172.31.1.8 via HTTP with MS-WebStorage 6.0.6249 Received: from Panoramix by obelix.askesis.nl; 08 Nov 2005 19:21:31 +0100 Subject: Re: Moving pg_xlog problem From: Joost Kraaijeveld To: Tom Lane Cc: Jeff Frost , "Pgsql-Admin (E-mail)" In-Reply-To: <7245.1131473123@sss.pgh.pa.us> References: <1131472648.6025.15.camel@Panoramix> <7245.1131473123@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Tue, 08 Nov 2005 19:21:31 +0100 Message-Id: <1131474091.6025.23.camel@Panoramix> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.052 required=5 tests=[AWL=0.051, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.052 X-Spam-Level: X-Archive-Number: 200511/74 X-Sequence-Number: 19447 Hi Tom, On Tue, 2005-11-08 at 13:05 -0500, Tom Lane wrote: > Joost Kraaijeveld writes: > >>> PANIC: could not open file > >>> "/var/lib/postgresql/8.0/main/pg_xlog/00000001.history": Permission > >>> denied > > >> So what happens if you do: > >> ls -l /var/lib/postgresql/8.0/main/pg_xlog/00000001.history > > > There is not a file with that name. > > Not surprising; the problem is that it's getting "Permission denied" > instead of "No such file". It does not suprise me either . But in an attempt to be complete I added the (almost) full directory listing of the permissions and contents of the relevant directories. *I* cannot find any "access denied" reason. Can you? (do I sound desperate enough ;-)?) -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: J.Kraaijeveld@Askesis.nl web: www.askesis.nl