
hi,

how put password to psql, pg_dump etc by same shell script (for ie by
crontab) , because there are option -W but passwd is reading from /dev/tty
not from stdin , so i can not use | :(



Mon, 20 Oct 2003 20:56:05 +0200 (CEST)
ivan <iv@psycho.pl>
how to put passwd ?
On Mon, Oct 20, 2003 at 08:56:05PM +0200, ivan wrote:

> how put password to psql, pg_dump etc by same shell script (for ie by
> crontab) , because there are option -W but passwd is reading from /dev/tty
> not from stdin , so i can not use | :(

Have you tried the ~/.pgpass file or the PGPASSWORD environment
variable?  They're both documented in the libpq reference.

BTW, you should really be posting this in pgsql-general, not -hackers.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La naturaleza, tan frï¿½gil, tan expuesta a la muerte... y tan viva"

Mon, 20 Oct 2003 16:01:37 -0300
Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: how to put passwd ?