Re: Minimum permissions required for pg_dump as a backup user

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
Cc: pgsql-novice(at)postgresql(dot)org, team-srs(at)catalyst(dot)net(dot)nz
Subject: Re: Minimum permissions required for pg_dump as a backup user
Date: 2002-10-11 04:16:59
Message-ID: 2183.1034309819@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-novice

Andrew McMillan <andrew(at)catalyst(dot)net(dot)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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message rmunn 2002-10-11 05:56:54 Re: TR: Re: TR: interface PERL and return results
Previous Message =?ISO-2022-JP?B?GyRCMiZJTBsoQg==?= 2002-10-11 02:27:06 backup problem

Browse pgsql-novice by date

  From Date Subject
Next Message Jeffrey Green 2002-10-11 07:06:31 foreign key, create table, and transactions
Previous Message John Joseph Bachir 2002-10-10 23:10:24 os x 10.2 Pg.pm