From: David Lizano <david.lizano@izanet.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-sql@postgresql.org
Subject: Re: pg_dumpall and password access
Date: Wed, 04 Apr 2001 11:32:34 +0200
Message-ID: <4.3.2.7.0.20010404112720.00bf0c20@192.168.1.1> (raw)
In-Reply-To: <29370.986340578@sss.pgh.pa.us>
References: <m266gliosk.fsf@gabuzo.meunet>
<m266gliosk.fsf@gabuzo.meunet>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: david.lizano@izanet.com, tgl@sss.pgh.pa.us
Subject: Re: pg_dumpall and password access
In-Reply-To: <4.3.2.7.0.20010404112720.00bf0c20@192.168.1.1>
References: <m266gliosk.fsf@gabuzo.meunet> <4.3.2.7.0.20010404112720.00bf0c20@192.168.1.1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox