psql without password prompt

From: brew(at)theMode(dot)com
To: Wei Weng <wweng(at)kencast(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: psql without password prompt
Date: 2002-05-30 20:54:35
Message-ID: Pine.BSF.4.44.0205301652220.6765-100000@themode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


> I want to run a SQL script in my crontab job which requires using psql
> without having to input password every time. I am running postgresql
> 7.2.
>
> What is the trick?

You may have gotten other replies that I've not noticed in my mail que,
but what I do is write my script in perl and use the DBI module to connect
to the database. Then use cron to run the script.

I'm sure there are other ways, but that's one way.

brew

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message V R 2002-06-01 06:24:47 Enabling Audit Trail in Postgres
Previous Message Josh Berkus 2002-05-30 15:44:13 Re: Database Ownership