Postgres Pro
Downloads
Home   >   mailing lists

Re: psql prompting for password. Can we suppress it? - Mailing list pgsql-bugs

From Milen A. Radev
Subject Re: psql prompting for password. Can we suppress it?
Date
Msg-id f8clob$ccp$1@sea.gmane.org
Whole thread Raw
In response to psql prompting for password. Can we suppress it?  ("Pradeep Rai" <pradeepr@infotechsw.com>)
List pgsql-bugs
Tree view 
Pradeep Rai написа:
> Hello,
>
> We are trying to perform bulk insert into PostGre database with the help of
> a text file (containing n INSERT statements), and then invoking psql command
> from a batch file.
>
> "psql -d <database name> -f <file-name.sql> -h <server-ip> -U <username>"
>
> The issue is that the psql command window prompts for the password. Have you
> got any idea how to suppress it?

1.http://www.postgresql.org/docs/current/static/libpq-pgpass.html
2.http://www.postgresql.org/docs/current/static/auth-methods.html#AUTH-TRUST



--
Milen A. Radev

pgsql-bugs by date:

Previous
From: "Pradeep Rai"
Date:
Subject: psql prompting for password. Can we suppress it?
Next
From: Tom Lane
Date:
Subject: Re: BUG #3493: Cannot find data with = operator