psql without password prompt - Mailing list pgsql-novice

From brew@theMode.com
Subject psql without password prompt
Date
Msg-id Pine.BSF.4.44.0205301652220.6765-100000@themode.com
Whole thread Raw
In response to psql without password prompt  (Wei Weng <wweng@kencast.com>)
List 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


pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Database Ownership
Next
From: "V R"
Date:
Subject: Enabling Audit Trail in Postgres