Re: Postgres 9.4 + unixODBC on Centos 6.5 problem connecting localhost postgres instance with isql ODBC commandline client

Hi Jeremy

>I had thought perhaps psql was using unix domain socket(/tmp) and not
localhost but as  psql -h localhost ...
>works for you that is NOT the problem.

>Just one last thing to check if you run
>grep localhost /etc/hosts
>what do you get. In particular is the 127.0.0.1 line(IPv4) before the ::1
line(ipv6).

This is the output:

---
[root@jhbasterisk ~]# grep localhost /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4
localhost4.localdomain4
::1         localhost localhost.localdomain localhost6
localhost6.localdomain6
[root@jhbasterisk ~]#
---

One thing I did notice though. When I was initially setting up postgress,
the last line of my pg_hba.conf was

---
host    all             all             ::1/128                 trust
---

And I could not get access with psql to the running postgres instance.

Changing the last line to

---
host    all             all             ::1/128                 ident
---

also caused that I could not get access with psql to the running postgres
instance (restarting postgres after changing pg_hba.conf each time, of
course).

Only when I put

---
host    all             all             ::1/128                 md5
---

as the last line of pg_hba.conf and restarted postgres, could I get access
with psql to the running postgres instance.

This seems to indicate that I'm running postgres on IPV6 (unintentionally)
instead of IPV4?

I just want / need IPV4 functionality, IPV6 is unneccessary.

HOWEVER

Can this be why unixODBC is not working? E. g. it is string to connect to
postgres but it is ignoring IPV4 requests?

My current pg_hba.conf does allow IPV4:

---
local   all             all                                     trust
host    all             all             127.0.0.1/32            trust
host    all             all             ::1/128                 trust
---

I can drop the first two lines and nothing changes - psql still works and
isql still does NOT work - but drop the very last line and psql AND isql
don't work.

Ergo... IPV6 is being used by postgres and IPV4 traffic is completely
ignored?

I have not tried to connect to the box in question from any host besides
local.

Thanks for the assistance.

Kind regards

Stefan