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: 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 (view raw or flat)
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

pgeu-general by date

Next:From: Peter GeogheganDate: 2010-01-31 16:05:45
Subject: Re: "could not stat file "base/17436/119145": Permission denied" when performing pg_database_size() on windows with 8.4.0
Previous: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

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