CODEWITHSUNDEEP
rpostgresql
Robin Winton
Robin Winton

Reputation: 601

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")

Upvotes: 4

Views: 2638

Answers (1)

Dirk is no longer here
Dirk is no longer here

Reputation: 368201

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.

Upvotes: 8

Related Questions