Re: pg_dumpall problems - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dumpall problems
Date
Msg-id 20835.1170110152@sss.pgh.pa.us
Whole thread Raw
In response to pg_dumpall problems  ("Peter Koczan" <pjkoczan@gmail.com>)
Responses Re: pg_dumpall problems
List pgsql-admin
"Peter Koczan" <pjkoczan@gmail.com> writes:
> Right now, we run pg_dumpall as a non-superuser,

[ raised eyebrow... ]  That's never been a recommended procedure.

> The weird thing is, whenever I run this exact same command from psql as the
> backup user, it works.

Maybe you're not trying it in the same database pg_dumpall is?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Peter Koczan"
Date:
Subject: pg_dumpall problems
Next
From: "Phillip Smith"
Date:
Subject: Re: Terminating a query that appears to be hung