| From: | David Lizano <david(dot)lizano(at)izanet(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: pg_dumpall and password access |
| Date: | 2001-04-04 09:32:34 |
| Message-ID: | 4.3.2.7.0.20010404112720.00bf0c20@192.168.1.1 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
At 19.29 3/4/01 -0400, you wrote:
>Christophe Labouisse <labouiss(at)cybercable(dot)fr> writes:
> > I'm trying to run pg_dumpall to backup all my users' bases but since I
> > have configure pg_hba.conf to "passwd" pg_dumpall always fails:
>
>pg_dumpall doesn't work very well with password authentication (and
>even if it did, storing the password in a cron script doesn't seem
>like a good idea to me).
From the cron script you can execute somethin like this.
su -l postgres -c pg_dumpall <parameters>
and then, "pg_dumpall" will be executed by the postgres user.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Galbavy | 2001-04-04 10:12:34 | performance of functions - or rather lack of it |
| Previous Message | J.H.M. Dassen Ray | 2001-04-04 09:07:18 | Re: pg_dumpall and password access |