Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (Postfix) with ESMTP id DCD54474E4E for ; Fri, 26 Apr 2002 15:35:35 -0400 (EDT) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 431 for ; Fri, 26 Apr 2002 13:22:30 -0600 Message-ID: <3CC9B20F.6511C8D3@waterford.org> Date: Fri, 26 Apr 2002 14:01:19 -0600 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Postgres SQL Mailing List Subject: Re: Connection authentication References: <200204251443.g3PEhSb12314@candle.pha.pa.us> Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/333 X-Sequence-Number: 7597 I checked PGUSER/PGPASSWORD settings for the root and the user which runs the cron job and they seem to be fine. However, I get the following messages in the root mail: Connection to database 'webspec' failed. fe_sendauth: no password supplied. Any ideas? thanks, Oleg Bruce Momjian wrote: > 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, Pennsylvania 19026 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html