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

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.