pg_dumpall: permission denied for relation pg_shadow

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dumpall: permission denied for relation pg_shadow
Date: 2006-03-16 21:57:32
Message-ID: 20060316215732.99465.qmail@web52913.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I tried using pg_dumpall and got this error:

pg_dumpall: query failed: ERROR: permission denied
for relation pg_shadow
pg_dumpall: query was: SELECT usename, usesysid,
passwd, usecreatedb, usesuper, valuntil, (usesysid =
(SELECT datdba FROM pg_database WHERE datname =
'template0')) AS clusterowner FROM pg_shadow

I haven't messed around with template0. This is a
recent installation of postgres (8.0.x), done via yum.

Any idea what the problem is and how to fix it?

thanks,
CSN

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomi NA 2006-03-16 21:59:26 Re: Disability the trigger
Previous Message Tomi NA 2006-03-16 21:56:33 Re: picking the correct locale when doing initdb