pg_dumpall and authentication

From: Tom Hart <tomhart(at)coopfed(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dumpall and authentication
Date: 2007-11-09 16:52:15
Message-ID: 4734903F.1080406@coopfed.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm sure you guys have heard this about 100 times, and I've done some
research on Google and found out some things, but I still have a couple
questions.

As I'm sure you may have guessed from the subject, I'm trying to
schedule (under windows) pg_dumpall to run each night/morning/full
moon/whatever. The hitch in this is that it asks for a password for each
database as it dumps it. I know I can use the PGPASS environment
variable, or a ~/.pgpass file. What I'm wondering is what's considered
'best practice' in practical applications. What solutions do you guys
use? Is it worth changing PGPASSFILE to point to a different .pgpass?

Thanks in advance for any assistance.

Thomas R. Hart II
tomhart(at)coopfed(dot)org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message brian 2007-11-09 16:56:25 Re: Optimal time series sampling.
Previous Message Ted Byers 2007-11-09 16:47:17 Re: Optimal time series sampling.