Search Postgresql Archives

Re: Cannot reach pg server using -h localhost

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Fritz Meissner <fritz.meissner@xxxxxxxxx> writes:
>> From the terminal in Mac OS X Yosemite, connecting to homebrew
> installed 9.4.4, I have a problem if I specify the host (I know this
> comes up all the time, bear with me as I have done a fair amount of
> digging already). This works:

This rang a bell with me, and a bit of digging found this thread:
http://www.postgresql.org/message-id/flat/6804.1413911806@xxxxxxxxxxxxx

While that's not the same symptom you're describing, it does point up
that OS X will expand "localhost" as pretty much "whatever it says in
/etc/hosts".  You might want to make sure that that expansion is sane,
ie 127.0.0.1 and ::1 and nothing else.

On my not-misbehaving-now Yosemite laptop, /etc/hosts contains

##
# Host Database
#
# localhost is used to configure the loopback interface
# when the system is booting.  Do not change this entry.
##
127.0.0.1       localhost
255.255.255.255 broadcasthost
::1             localhost 


However, assuming that that's not your problem, I'd suggest cranking up
log_min_messages to DEBUG5 and seeing if anything more gets reported
in the postmaster log.

Another thing worth checking is whether "-h 127.0.0.1" and "-h ::1"
behave the same as "-h localhost".  That would help rule out (or not)
DNS issues.

			regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux