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

Reply via email to