pg_dumpall: permission denied for relation pg_shadow

Started by CSNabout 20 years ago2 messagesgeneral
Jump to latest
#1CSN
cool_screen_name90001@yahoo.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: CSN (#1)
Re: pg_dumpall: permission denied for relation pg_shadow

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