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

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

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: pgeu-general(at)postgresql(dot)org
Subject: "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:12:54
Message-ID: db471ace1001291612l5b21d85du296e4820553e0365@mail.gmail.com (view raw or flat)
Thread:
Lists: pgeu-general
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?

Regards,
Peter Geoghegan

Responses

pgeu-general by date

Next: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
Previous:From: Joshua D. DrakeDate: 2010-01-29 19:51:23
Subject: Re: Fwd: General Purpose PostgreSQL Template

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