Re: pg_dump privileges - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_dump privileges
Date
Msg-id 18014.1075821674@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump privileges  (Mark Lubratt <mark.lubratt@indeq.com>)
List pgsql-admin
Mark Lubratt <mark.lubratt@indeq.com> writes:
> I'd like to create a user for my pg_dump backup process.  I'd like that
> user to have only the privileges required to run pg_dump.

You're wasting your time.  pg_dump should generally be run by the
database superuser.  Anything less creates problems with being unable
to dump stuff that doesn't belong to it.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Matt Clark"
Date:
Subject: Re: Alternative to "Money" ...
Next
From: Chris Gamache
Date:
Subject: Re: Alternative to "Money" ...