Postgres Pro
Downloads
Home   >   mailing lists

Re: Minimum permissions required for pg_dump as a backup user - Mailing list pgsql-novice

From Tom Lane
Subject Re: Minimum permissions required for pg_dump as a backup user
Date
Msg-id 2183.1034309819@sss.pgh.pa.us
Whole thread Raw
In response to Minimum permissions required for pg_dump as a backup user  (Andrew McMillan <andrew@catalyst.net.nz>)
List pgsql-novice
Tree view 
Andrew McMillan <andrew@catalyst.net.nz> writes:
> Does anyone know what the minimum permission is required to have
> database backups run as a less privileged user?

Backups should be run as the superuser.  Don't waste your time trying
to kluge up something else.

            regards, tom lane

pgsql-novice by date:

Previous
From: Andrew McMillan
Date:
Subject: Minimum permissions required for pg_dump as a backup user
Next
From: "Chad Thompson"
Date:
Subject: Inner join syntax