Postgres Pro
Downloads
Home   >   mailing lists

psql shell with no password prompt - Mailing list pgsql-admin

From Steve.Toutant@inspq.qc.ca
Subject psql shell with no password prompt
Date
Msg-id OF19F9E409.963810B9-ON8525776D.005C2CB2-8525776D.005CC9EF@isn.rtss.qc.ca
Whole thread Raw
Responses Re: psql shell with no password prompt  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: psql shell with no password prompt  (Walter Willmertinger <willmis@gmail.com>)
List pgsql-admin
Tree view

Hi,
I created several SQL that are automatically executed via windows task scheduler, here is an example
psql -U "dbadmin" -d mydb -f D:\script.sql

It was running well until I changed the user (to open a session) associated to these task.
The script prompt for a password for user dbadmin.

How to avoid that? I guess there is a config so dbadmin will "trust" this new user....

Thanks for your help,

Steve

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Postgresql for Windows 7
Next
From: "Kevin Grittner"
Date:
Subject: Re: psql shell with no password prompt