Connect to PostgreSQL using R (in windows)

Question

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

Dirk is no longer here · Accepted Answer · 2013-03-02 17:01:20Z

8

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.

answered Mar 2, 2013 at 17:01

Dirk is no longer here

370k60 gold badges668 silver badges742 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Robin Winton Over a year ago

it's unclear to me how this conf file works; i was just trying out an example in a book, but this part is a bit blurry

Dirk is no longer here Over a year ago

Well psql may read it, but I do not think we ever added that to the package.

Collectives™ on Stack Overflow

Connect to PostgreSQL using R (in windows)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related