Re: psqlODBC hangs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Kelly <Peter(dot)Kelly(at)aepona(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlODBC hangs
Date: 2004-09-28 14:09:32
Message-ID: 14251.1096380572@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Peter Kelly <Peter(dot)Kelly(at)aepona(dot)com> writes:
> I'm having problems getting psqlODBC to work on HP-UX 11.11.
> Whenever I try to start my client, it hangs while connecting to the DB.
> The client and DB are both running on the same machine.
> I've downloaded and installed a precompiled version of Postgresql 7.4.2 from
> http://www.software.hp.com/cgi-bin/swdepot_parser.cgi/cgi/displayProductInfo.pl?productNumber=HPUXIEXP1111
> without any problems and can use psql to query the DB without problems.

psql will by default connect via a Unix socket, whereas the ODBC code
is evidently set up to connect via TCP/IP. I bet if you try
"psql -h 10.10.29.11 ..." it will block too.

It could be a problem with your pg_hba.conf entry for local TCP
connections, but usually mistakes there don't result in a complete
hang. I'm wondering whether kernel-level packet filtering is preventing
the connection request from going through. If you've got any sort of
software firewall setup, check its rules.

regards, tom lane

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Tom Lane 2004-09-28 14:14:15 Re: psqlODBC hangs
Previous Message Greg Campbell 2004-09-28 14:08:40 Re: Non-Proprietary ODBC Examples on Win32?