using PGPASSWORD environment variable - Mailing list pgsql-general

From James Hall
Subject using PGPASSWORD environment variable
Date
Msg-id EE80A67DD80E304DA779C72BC9FA999603E22605@ntmailo.dhcp.tandy.com
Whole thread Raw
Responses Re: using PGPASSWORD environment variable  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
I am trying to write a [perl] script to automate database backups. PG
requests the password every time I connect to a database. It was suggested
that I "use PGPASSWORD environment variable, just set it before you execute
pg_dumpall".


I have not been able to find any examples to show how to use the PGPASSWORD
variable in a script.

Can someone please post an example or 2?

TIA,
-jim

pgsql-general by date:

Previous
From: Ericson Smith
Date:
Subject: Re: What is the quickest query in the database?
Next
From: Patrick Nelson
Date:
Subject: jdbc in OO