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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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


  • From: "Milen A. Radev" <milen(at)radev(dot)net>
  • To: pgsql-bugs(at)postgresql(dot)org
  • Subject: Re: psql prompting for password. Can we suppress it?
  • Date: Fri, 27 Jul 2007 14:43:06 +0300
  • Message-id: <f8clob$ccp$1@sea.gmane.org> <text/plain>

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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group