"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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgeu-general by date

  From Date Subject
Next Message Andreas 'ads' Scherbaum 2010-01-30 00:29:04 Re: "could not stat file "base/17436/119145": Permission denied" when performing pg_database_size() on windows with 8.4.0
Previous Message Joshua D. Drake 2010-01-29 19:51:23 Re: Fwd: General Purpose PostgreSQL Template