I am using RODBC with Postgresql. I have disabled the log file in ~/.odbc.ini, but nevertheless I still get a logfile in /tmp, which can grow to gigabytes, so I would like to disable it. It appears that the logfile is generated by R: % lsof | grep /tmp/psqlodbc_tpapp7482.log R 7482 tpapp 3w REG 3,5 3127 1668135 /tmp/psqlodbc_tpapp7482.log Could somebody please tell me how to disable this logfile? I have searched the list and help, but found nothing about this. Thanks, Tamas
Prof Brian Ripley
2005-Aug-11 08:26 UTC
[R] off-topic ODBC Q (was how to disable RODBC log file)
RODBC does not have a log file, and this is nothing to do with RODBC or R. What you are talking about here is an *ODBC* log file, and for that you need to consult your (unstated) device manager documentation for your (unstated) OS. The name of the log file (psqlodbc_*) should have given you a clue: it seems to be coming from the ODBC driver. On Thu, 11 Aug 2005, Tamas K Papp wrote:> I am using RODBC with Postgresql. I have disabled the log file in > ~/.odbc.ini, but nevertheless I still get a logfile in /tmp, which can > grow to gigabytes, so I would like to disable it. > > It appears that the logfile is generated by R: > > % lsof | grep /tmp/psqlodbc_tpapp7482.log > R 7482 tpapp 3w REG 3,5 3127 1668135 /tmp/psqlodbc_tpapp7482.log > > Could somebody please tell me how to disable this logfile? I have > searched the list and help, but found nothing about this.> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.htmlPLEASE do as we ask! -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595