how to put passwd ?

Started by ivanabout 22 years ago2 messages
#1ivan
iv@psycho.pl

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 | :(

#2Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: ivan (#1)
Re: 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"