commlog destination in Solaris - Mailing list pgsql-odbc

From Little, Douglas
Subject commlog destination in Solaris
Date
Msg-id 8585BA53443004458E0BAA6134C5A7FB47CA5CDD@EGEXCMB01.oww.root.lcl
Whole thread Raw
List 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.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Attachment

pgsql-odbc by date:

Previous
From:
Date:
Subject: Re: Issues when using schema names with odbc
Next
From: "Little, Douglas"
Date:
Subject: COMMLog location