Re: new to Unixodbc: can't connect to Postgresql

mlc wrote:
> Hi,
> I'm new to postgresql Unix odbc (iodbc). I am trying to test my
> unixodbc connection to a local Postgres DB via the provided
> "iodbctest" program and have been unsuccessful in getting a "SQL>"
> prompt. Instead, it prints out a "Have nice day" message. Been
> working on this problem for a week now and have not come up with
> anything close at all.
> Searched the web and this forum for any "ideas" as to what is wrong
> and can't find anything. Any input or help in pointing me to the
> right direction is highly appreciated and invaluable.

1. Make sure you are logging connection attempts in postgresql.conf and
see if anything is happening there.
2. Make sure PG is listening on port 5432 (telnet localhost 5432, hit
return twice and you should see an error message)
3. Check your pg_hba.conf is allowing access from localhost (NOT local)
via passwords.

--
Richard Huxton
Archonet Ltd