commlog destination in Solaris

From: "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: commlog destination in Solaris
Date: 2010-12-01 09:22:14
Message-ID: 8585BA53443004458E0BAA6134C5A7FB47CA5CDD@EGEXCMB01.oww.root.lcl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
We're having problems with connection failures from Informatica to GP/PG. there's nothing in the GP/PG log.
We've turned on the commlog trace in the odbc settings.
Can someone tell me where I can find the log location?
We're running PsqlODBC 8.0.4 on solaris 10 sparc 64bit.

Our odbc.ini file
[GreenplumProd_Write]
Driver=/infa/GreenPlum/greenplum-connectivity/drivers/odbc/psqlodbc-08.02.0500/datadirect-52_32/psqlodbcw.so
#Driver=/infa/GreenPlum/connectivity-3.2-build-9981/drivers/odbc/psqlodbc-08.03.0400/unixodbc-2.2.12/psqlodbcw.so
#Driver=/infa/GreenPlum/connectivity-3.2-build-9981/psqlodbcw.so
Description=Greenplum Production - Read_Write
Servername=eggpdbvip.prod.orbitz.net
Port=5432
Database=p1gp1
Username=infa_write
Password=infagpwrite
UseDeclareFetch=0
Fetch=20000
Protocol=7.4-1
Trace=0
Debug=0
Readonly=No

Add
COMMLOG=1

Thanks

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
Douglas(dot)Little(at)orbitz(dot)com<mailto:Douglas(dot)Little(at)orbitz(dot)com>
[cid:image001(dot)jpg(at)01CB9106(dot)F2E81B40] orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>

Browse pgsql-odbc by date

  From Date Subject
Next Message Little, Douglas 2010-12-03 15:36:18 COMMLog location
Previous Message michael.28.smith 2010-11-30 14:38:44 Re: Issues when using schema names with odbc