Re: PGPASSWORD and client tools - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: PGPASSWORD and client tools
Date
Msg-id 41240488.8040404@familyhealth.com.au
Whole thread Raw
In response to PGPASSWORD and client tools  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: PGPASSWORD and client tools  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> While fixing the gui for pg_dump and pg_restore, I painfully noticed 
> there's no option for the password.
> After some tests, I found that using the PGPASSWORD environment variable 
> will do the job. I'm a bit irritated that it's marked "deprecated" in 
> the docs, the .pgpass solution isn't a good one for tool managed passwords.
> Hopefully PGPASSWORD won't vanish until there's another solution to 
> execute pgsql client tools...

I didn't notice it was deprecated either - it's the only way that 
phpPgAdmin can integrate with pg_dump...

Chris



pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: tablespace and sequences?
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Tablespace and cpu costs