I believe the answer to your problem is that in your ~/.odbc.ini file you are saying to use driver PostgreSQL
– but you have not defined that driver in your /etc/odbcinst.ini file. Try changing PostgreSQL
to PostgreSQL ANSI
or PostgreSQL Unicode
(both of which are defined in /etc/odbcinst.ini).