Skip site navigation (1) Skip section navigation (2)

Re: Problem to connect to PostgreSQL7.2.3 using UNIXODBC's

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: Mauro Goncalves de OliveriaDate: 2002-12-04 11:18:44
Subject:
Previous:From: lingjiaDate: 2002-12-04 03:07:30
Subject: Problem to connect to PostgreSQL7.2.3 using UNIXODBC's datamanager

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group