Re: Connection authentication

Oleg Lebedev wrote:
> 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,

PGUSER/PGPASSWORD certainly should work.  Did you export them properly? 
The only other idea I have is upgrading to 7.2 where on Linux you can
use ident on local connections.  It uses socket authentication and will
not require a password and you don't have to run ident.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026