Re: unattended backupscript not working with 7.4.2, works in 7.1

On Mon, May 03, 2004 at 03:42:04AM +0200, Development - multi.art.studio wrote:

> i have a question about backing up my fresh updated databases :)
> after updating some of my databases, everything works fine, except my
> backupscripts.
> i run this script as root from cronjob with su - postgres -c "...script..."
> it works fine with postgres 7.1, but in 7.4.2 something seems to have
> changed on the behaviour of psql, and pg_dump

I think the difference is that the programs don't read the password from
stdin anymore; rather they expect it on /dev/tty. Maybe you could use
the ~/.pgpass file instead; read its documentation in the libpq section
of the manual.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Nadie esta tan esclavizado como el que se cree libre no siendolo" (Goethe)