Thread: pg_dumpall: permission denied for relation pg_shadow

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

CSN <cool_screen_name90001@yahoo.com> writes:
> I tried using pg_dumpall and got this error:
> pg_dumpall: query failed: ERROR:  permission denied
> for relation pg_shadow

You really need to run that as superuser.

            regards, tom lane