dbTalk Databases Forums  

[BUGS] psql does not pick up hostname without -h even though they ae the

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] psql does not pick up hostname without -h even though they ae the in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Griffiths
 
Posts: n/a

Default [BUGS] psql does not pick up hostname without -h even though they ae the - 08-27-2003 , 10:02 PM






When running psql locally using the tcp connect with tcpip_socket = true and
hostname_lookup = true in postgresql.conf, psql does not find localhost unless
the -h option is specified.


427 bash$ psql
psql: FATAL: No pg_hba.conf entry for host localhost, user jrg4598, database
jrg4598

428 bash$ psql -h localhost
Password:
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

jrg4598=# \q
429 bash$




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Reply With Quote
Reply




Thread Tools
Display Modes

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.