Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (Postfix) with ESMTP id 1714C475888 for ; Wed, 24 Apr 2002 15:07:01 -0400 (EDT) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 433 for ; Wed, 24 Apr 2002 12:53:53 -0600 Message-ID: <3CC7085C.75D70C72@waterford.org> Date: Wed, 24 Apr 2002 13:32:44 -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: Connection authentication Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/290 X-Sequence-Number: 7554 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