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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026