Connect to Postgres 7.4 via ODBC

From: "Nadia Kunkov" <nadiak(at)parkerglobal(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Connect to Postgres 7.4 via ODBC
Date: 2004-12-14 21:55:20
Message-ID: AD00BDEBE7882B4E931CCE42D291A88F8C70EC@mail04.CONNECT.CONNECTAPPS.NET
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

After wasting about half a day I thought I'd ask you for help.
I have Fedora Core 3 box that came with postgresql 7.4.6 installed.
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 ?)


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

The ip address of the windows box is 10.1.9.15 and ip address of the server is 10.1.9.27

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.

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

Every time I try to connect via ODBC from windows I get an error:
Could not connect to the server
Could not connect to remote socket

I'd appreciate any help.
Thank you
NK

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jimmie H. Apsey 2004-12-14 22:50:28 Re: Performance differences 7.1 to 7.3
Previous Message Dann Corbit 2004-12-14 21:54:12 Re: Performance differences 7.1 to 7.3