Thread: how to put passwd ?

how to put passwd ?

From
ivan
Date:
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 | :(




Re: how to put passwd ?

From
Alvaro Herrera
Date:
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"