[R] RPostgreSQL [Expired connection at startup]

Stephen Sefick ssefick at gmail.com
Tue Feb 15 19:36:23 CET 2011


I have set up a postgresql database that I connect to each R startup in
my .Rprofile file.

##############relevant lines from .Rprofile############################
library(RPostgreSQL)
m <- PostgreSQL()
con <- dbConnect(m, user="xxx", password="yyy", dbname="zzz")
#######################################################################

in R

con
<Expired PostgreSQLDriver:(3177)>

This Expired message has only recently started showing up.  I can run
the relevant code snippett above and the connection will work without a
hitch.  Am I missing something like a close connection command?  Thanks
for the help in advance and anymore relevant information I can provide
please let me know.

Stephen

R version 2.12.1 (2010-12-16)
Platform: x86_64-pc-linux-gnu (64-bit)

locale:
 [1] LC_CTYPE=en_US.utf8       LC_NUMERIC=C             
 [3] LC_TIME=en_US.utf8        LC_COLLATE=en_US.utf8    
 [5] LC_MONETARY=C             LC_MESSAGES=en_US.utf8   
 [7] LC_PAPER=en_US.utf8       LC_NAME=C                
 [9] LC_ADDRESS=C              LC_TELEPHONE=C           
[11] LC_MEASUREMENT=en_US.utf8 LC_IDENTIFICATION=C      

attached base packages:
[1] graphics  grDevices utils     datasets  stats     grid
methods  
[8] base     

other attached packages:
 [1] vegetarian_1.2          gpclib_1.5-1
RPostgreSQL_0.1-7      
 [4] DBI_0.2-5               StreamMetabolism_0.03-3
maptools_0.7-38        
 [7] lattice_0.19-17         sp_0.9-76
foreign_0.8-41         
[10] chron_2.3-39            zoo_1.6-4
vegan_1.17-5           
[13] ggplot2_0.8.9           proto_0.3-8
reshape_0.8.3          
[16] plyr_1.4               

loaded via a namespace (and not attached):
[1] tcltk_2.12.1 tools_2.12.1



More information about the R-help mailing list