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

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
Cc: jd(at)commandprompt(dot)com, 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-31 15:51:04
Message-ID: 4B65A6E8.1080407@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgeu-general

Peter Geoghegan wrote:
> Hi Joshua,
>
>> Well generally this would mean that your postgres user can't read that
>> file. Make sure that your permissions are correct in the subdirectories.
>
> Funnily enough, the problem comes and goes without any intervention
> from me. It works fine right now.

that is usually caused by missbehaving antovirussoftware that tries to
do "on-access" scanning. Try excluding PGDATA from whatever you have
there - or even better deinstall...

Stefan

In response to

Responses

Browse pgeu-general by date

  From Date Subject
Next Message Peter Geoghegan 2010-01-31 16:05:45 Re: "could not stat file "base/17436/119145": Permission denied" when performing pg_database_size() on windows with 8.4.0
Previous Message Peter Geoghegan 2010-01-31 15:43:49 Re: "could not stat file "base/17436/119145": Permission denied" when performing pg_database_size() on windows with 8.4.0