Robin R. Winton Robin R. Winton - 1 year ago 122
R Question

Connect to PostgreSQL using R (in windows)

I have this R code and i want to connect to a postgres db using the conf file:

con <- dbConnect(PostgreSQL(), groups='epl')


The postgresql.conf file contains:

#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------

# Add settings for extensions here
[epl]
host='localhost'
port = 5432
dbname='rlearning'
user='user'
password='pass'


When I run the R code, i get this error:

Error in postgresqlNewConnection(drv, ...) :
unused argument(s) (groups = "epl")

Answer Source

If everything else fails, you can try reading the documentation and following the examples. For help(dbConnect), you find

# create an PostgreSQL instance and create one connection.
drv <- dbDriver("PostgreSQL")

# open the connection using user, passsword, etc., as
con <- dbConnect(drv, dbname = "postgres")

and this is where you add additional user, password, host, arguments.

It will also show you that there is no argument groups explaining the error you get.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download