dbTalk Databases Forums  

passing password to psql, pg_restore etc.?

Go Back dbTalk Databases Forums Databases comp.databases.postgresql passing password to psql, pg_restore etc.?

comp.databases.postgresql comp.databases.postgresql


Discuss passing password to psql, pg_restore etc.? in the comp.databases.postgresql forum.



Reply
Page 4 of 4 < 1 2 3 4
 
Thread Tools Display Modes
  #31  
Old   
Skeptik
 
Posts: n/a

Default Re: passing password to psql, pg_restore etc.? - 04-11-2008 , 02:00 PM





thanks

"Thomas Guettler" <hv (AT) tbz-pariv (DOT) de> je napisao u poruci interesnoj
grupi:668d2cF2f50enU1 (AT) mid (DOT) individual.net...
Quote:
Skeptik schrieb:
Hello.
How to pass password in these commands, without beeing prompted, and
without pgpass.conf?


If you DB is on a unix machine and you connect from this machine,
you can use this line in pg_hba.conf:

local all all ident sameuser

This allows access without password if the db-username matches
the unix username.

Thomas

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de



Reply With Quote
  #32  
Old   
Skeptik
 
Posts: n/a

Default Re: passing password to psql, pg_restore etc.? - 04-11-2008 , 02:00 PM





thanks

"Thomas Guettler" <hv (AT) tbz-pariv (DOT) de> je napisao u poruci interesnoj
grupi:668d2cF2f50enU1 (AT) mid (DOT) individual.net...
Quote:
Skeptik schrieb:
Hello.
How to pass password in these commands, without beeing prompted, and
without pgpass.conf?


If you DB is on a unix machine and you connect from this machine,
you can use this line in pg_hba.conf:

local all all ident sameuser

This allows access without password if the db-username matches
the unix username.

Thomas

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de



Reply With Quote
  #33  
Old   
Skeptik
 
Posts: n/a

Default Re: passing password to psql, pg_restore etc.? - 04-11-2008 , 02:00 PM


thanks

"Thomas Guettler" <hv (AT) tbz-pariv (DOT) de> je napisao u poruci interesnoj
grupi:668d2cF2f50enU1 (AT) mid (DOT) individual.net...
Quote:
Skeptik schrieb:
Hello.
How to pass password in these commands, without beeing prompted, and
without pgpass.conf?


If you DB is on a unix machine and you connect from this machine,
you can use this line in pg_hba.conf:

local all all ident sameuser

This allows access without password if the db-username matches
the unix username.

Thomas

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de



Reply With Quote
Reply
Page 4 of 4 < 1 2 3 4

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top