Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group