Message-ID: <45B53BDF.1030909@dunslane.net>
Date: Mon, 22 Jan 2007 17:34:07 -0500
From: Andrew Dunstan <andrew@dunslane.net>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.8.0.6) Gecko/20060804 Fedora/1.0.4-0.5.1.fc5 SeaMonkey/1.0.4
MIME-Version: 1.0
To: shaunc <shaun@cranedata.us>
CC: pgsql-hackers@postgresql.org
Subject: Re: send password to pg_dump
References: <8473174.post@talk.nabble.com>
In-Reply-To: <8473174.post@talk.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

shaunc wrote:
> Hello,
>
> I'm trying to run pg_dump programmatically, and I'm wondering how I can send
> it a password.
>
> I'm running it with a system() call in a child process, and sending the
> password in from the parent process on stdin, but somehow pg_dump always
> finds out how to ask my terminal for a password. How do I fool it?
>
> (I need this to work in linux... in python would be preferable too.)
>
>
>   

1. this is the wrong forum for this question - here we discuss 
postgresql developments, not usage
2. use a pgpass file, possibly with a PGPASSFILE environment setting as 
well - see the docs for details. This works on all platforms and should 
work with anything at all calling pg_dump.
3. In general, the only way to "fool" programs properly this way is to 
use expect or some equivalent that uses ptys. In this case, it would be 
overkill.

cheers

andrew