Hello,
I have a problem running a CRON job that vacuums and backs up my
database when authentication type is set to 'password' in pg_hba.conf
file. I used to have 'trust'ed settings before and everything was
working fine. Now I switched to password authentication type, but how
would a cron script send the password when prompted. I tried to set up
PGUSER and PGPASSWORD env. vars, but psql still prompts for the
password.
Any ideas?
I am using PostgreSQL 7.1.3 on Red Hat Linux 7.1.
thanks,
Oleg