Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dumpall: permission denied for relation pg_shadow - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dumpall: permission denied for relation pg_shadow
Date
Msg-id 22901.1142550641@sss.pgh.pa.us
Whole thread Raw
In response to pg_dumpall: permission denied for relation pg_shadow  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: About index for temporay table in a plpgsql function
Next
From: "Bart Golda"
Date:
Subject: SSL or other libraries for Windows-to-Linux PostgreSQL connection?