Hi Everybody, I started running 8.3.0 recently on dell hardware with redhat advanced server 4.
I have a problem with pg_dumpall via crontab. I had a simple crontab to do the same thing on 8.2.4 and the same thing doesn't work. Here's my very simple crontab entry: xx xx * * * sh /usr/local/pgsql/cron_dir/moo.sh and moo.sh is eqally simple: #! /bin/bash . .bashrc filename=`date +%G%m%d.%w`.gz /usr/local/pgsql/bin/pg_dumpall > $filename Here's what I get back as output is: Password: pg_dumpall: could not connect to database "template1": fe_sendauth: no password supplied This is not what happened on 8.2.4. I read 8.3.0 man page on pg_dumpall. Here's what it told me: The file .pgpass in a user's home directory or the file referenced by PGPASSFILE can contain passwords to be used if the connection requires a password (and no password has been specified otherwise). I have .pgpass in /usr/local/pgsql and when I type psql dbname It lets me in without asking the password. So I don't understand why I get what I get: fe_sendauth: no password supplied I ran a different cron job which looks like: #! /bin/bash . .bashrc echo PGUSER: $PGUSER echo PGDATABASE: $PGDATABASE echo PGHOST: $PGHOST echo PGPASSFILE: $PGPASSFILE echo PGDATA: $PGDATA and everything it told me checks out with what I get from interactive session. Please tell me what I am doing wrong. I am at the end of my wits. Regards, Tena Sakai [EMAIL PROTECTED]
