dbTalk Databases Forums  

Running postgresql on localhost

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Running postgresql on localhost in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
chrisstrachan_at_msn.com
 
Posts: n/a

Default Running postgresql on localhost - 04-22-2004 , 02:49 PM






Hi everyone,

Probably a bit of a basic config problem but any help would be really
appreciated

I can currently log in fine to psql like so,

#psql template1 -p 5432

this by default logs you into the local socket but unfortuanately it
does not work when I try

#psql template1 -h localhost

and returns the error

psql: unknown host name: localhost ( a similar login with mysql works
fine )

This has been quite frustrating as it means I can't login to the
database with tools such as pgadmin


Thanks in advance

Chris Strachan
chrisstrachan at msn.com

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: Running postgresql on localhost - 04-27-2004 , 11:51 PM






chrisstrachan (AT) msn (DOT) com (chrisstrachan_at_msn.com) writes:
Quote:
I can currently log in fine to psql like so,
#psql template1 -p 5432
this by default logs you into the local socket but unfortuanately it
does not work when I try
#psql template1 -h localhost
psql: unknown host name: localhost
You have a broken name lookup setup --- either /etc/hosts is wrong,
or you've misconfigured DNS, or quite likely both. It's not
Postgres-specific.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings



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.