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)