Thread: Connect to Postgres 7.4 via ODBC
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
Add : host all all 10.1.9.15 [your subnet mask number] trust in pg_hba.conf file. have you set the ODBC parameter correctly? database name, etc..? On Tue, 14 Dec 2004 16:55:20 -0500, Nadia Kunkov <nadiak@parkerglobal.com> wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Best Regards, Frans Gunawan fransgunawan@gmail.com
Hi, Citing Nadia Kunkov <nadiak@parkerglobal.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