BUG #14233: getting the size if the database failing with permission denied error

From: ssatyasrinivas(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14233: getting the size if the database failing with permission denied error
Date: 2016-07-07 15:01:37
Message-ID: 20160707150137.1418.26662@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14233
Logged by: Satya Sunkara
Email address: ssatyasrinivas(at)gmail(dot)com
PostgreSQL version: 9.2.9
Operating system: windows
Description:

when we do the backup, we do query the DB for size and name using following
select statement:

select p.datname,pg_database_size(p.datname) from pg_database p

This query is throws error:

PQresultStatus indicates failure for select
p.datname,pg_database_size(p.datname) from pg_database p. Error:ERROR:
could not stat file "base/95821/272574": Permission denied

Is there any resolution for this?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2016-07-07 15:08:43 Re: Where clause in pg_dump: need help
Previous Message Prashanth Adiyodi 2016-07-07 14:06:29 Where clause in pg_dump: need help