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
