From: | lingjia <lingjia(at)i2r(dot)a-star(dot)edu(dot)sg> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Problem to connect to PostgreSQL7.2.3 using UNIXODBC's |
Date: | 2002-12-04 04:24:51 |
Message-ID: | 01f601c29b4d$19a22900$4485a8c0@lit.org.sg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
Please ignore my previous posting, I searched the web again and changed the following:
1) Starting postmaster with -i option
2) uncommeted tcpip_socket=false in /usr/local/pgsql/data/postgresql.conf file and set it to true.
And it is working!
Thanks anyway!
Lingjia
----- Original Message -----
From: lingjia
To: pgsql-odbc(at)postgresql(dot)org
Sent: Wednesday, December 04, 2002 11:07 AM
Subject: [ODBC] Problem to connect to PostgreSQL7.2.3 using UNIXODBC's datamanager
Hi,
I have encountered a problem when I tried to use UnixODBC to connect to PostgreSQL7.2.3
Here are my ini files:
*********************************************************
[postgres(at)sv-ns postgres]$ cat /etc/odbc.ini
[postgre_test]
Description = postgresql
Driver = postgresql
Trace = No
TraceFile =
Database = testing
Servername = sv-ns
UserName =
Password =
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
************************************************************
[postgres(at)sv-ns postgres]$ cat /etc/odbcinst.ini
[postgresql]
Description = Driver for postgresql
Driver = /usr/local/pgsql/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1
CPTimeout =
CPReuse =
************************************************************
When I run DBManager, it says that:
"Could not connect to the server; could not connect to the remote socket."
The postgresql is running, I am able to browse and issue SQL statements on
the database using psql. Did I miss sth here?
Thanks in advance!
Lingjia
From | Date | Subject | |
---|---|---|---|
Next Message | Mauro Goncalves de Oliveria | 2002-12-04 11:18:44 | |
Previous Message | lingjia | 2002-12-04 03:07:30 | Problem to connect to PostgreSQL7.2.3 using UNIXODBC's datamanager |