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

Re: psql prompting for password. Can we suppress it?

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: psql prompting for password. Can we suppress it?
Date: 2007-07-27 11:43:06
Message-ID: f8clob$ccp$1@sea.gmane.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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


In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-07-27 13:07:07
Subject: Re: BUG #3493: Cannot find data with = operator
Previous:From: Michał NiklasDate: 2007-07-27 10:55:56
Subject: Re: BUG #3493: Cannot find data with = operator

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