Re: Connect to Postgres 7.4 via ODBC

Hi,

Citing Nadia Kunkov <nadiak(at)parkerglobal(dot)com>:
> Locally I have no problems connecting to the database and running psql.
> I need to set up an ODBC connection from my Windows box.
> Here is what I've done:
>
> 1. In postgresql.conf
> tcpip_socket = true
> (By the way does this eliminate the need to start postgres with -i option,
> see item 3 below ?)

yes

> 2. in pg_hba.conf
>
> local all all trust
> host all all 10.1.9.0 255.255.255.0 trust
> host all all 127.0.0.1 255.255.255.255 trust

looks good to me, mine looks like this, and it works:
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 10.195.0.0 255.255.0.0 md5

> 3. in /etc/rc.d/init.d/postgresql
>
> su -l postgres -s /bin/sh -c"/usr/bin/pg_ctl -D $PGDATA -o '-i' -p
> /usr/bin/postmaster start > /dev/null 2>&1 "</dev/null
> Note, I do have -i option.

Turn on logging (e.g. by using the -l option to pg_ctl)
and turn the line in postgresql.conf, which says
#log_connections = false
into
log_connections=true
Try to connect and look, if something shows up in your logfiles.

> 4. I ran netstat -na | grep 5432 and it tells me that postgres is listening
> on that port.

Something filtering inbetween? Logging connections as described
above might give you a clue what's happening.

Regards,
Daniel