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) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly