Re: pg_dumpall and password access - Mailing list pgsql-sql

From David Lizano
Subject Re: pg_dumpall and password access
Date
Msg-id 4.3.2.7.0.20010404112720.00bf0c20@192.168.1.1
Whole thread Raw
In response to Re: pg_dumpall and password access  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
At 19.29 3/4/01 -0400, you wrote:
>Christophe Labouisse <labouiss@cybercable.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.



pgsql-sql by date:

Previous
From: David Lizano
Date:
Subject: Inserting binary data (BLOBs) in v7.1
Next
From: "Peter Galbavy"
Date:
Subject: performance of functions - or rather lack of it