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

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

pgsql-odbc by date

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

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