Skip site navigation (1) Skip section navigation (2)

Re: "could not stat file "base/17436/119145": Permission denied" when performing pg_database_size() on windows with 8.4.0

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
Cc: pgeu-general(at)postgresql(dot)org
Subject: Re: "could not stat file "base/17436/119145": Permission denied" when performing pg_database_size() on windows with 8.4.0
Date: 2010-01-30 00:29:06
Message-ID: 1264811346.1360.36.camel@jd-desktop.unknown.charter.com (view raw or flat)
Thread:
Lists: pgeu-general
On Sat, 2010-01-30 at 00:12 +0000, Peter Geoghegan wrote:
> Hello,
> 
> I have a Postgres 8.4.0 (I've been meaning to upgrade) server running
> on Windows Vista:
> 
> Curiously, whenever I call pg_database_size, I get a cryptic error message:
> 
> SELECT pg_size_pretty(pg_database_size('my_database'))
> 
> ERROR:  could not stat file "base/17436/119145": Permission denied
> 
> 
> ********** Error **********
> 
> ERROR: could not stat file "base/17436/119145": Permission denied
> SQL state: 42501
> 
> Why? What should I do, other than the obvious, upgrading to 8.4.2?

Well generally this would mean that your postgres user can't read that
file. Make sure that your permissions are correct in the subdirectories.

Joshua D. Drake


> 
> Regards,
> Peter Geoghegan
> 


-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.


In response to

Responses

pgeu-general by date

Next:From: Peter GeogheganDate: 2010-01-31 15:43:49
Subject: Re: "could not stat file "base/17436/119145": Permission denied" when performing pg_database_size() on windows with 8.4.0
Previous:From: Andreas 'ads' ScherbaumDate: 2010-01-30 00:29:04
Subject: Re: "could not stat file "base/17436/119145": Permission denied" when performing pg_database_size() on windows with 8.4.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group