[R-sig-DB] Error in connecting R to Postgre

[Edward Vanden Berghe]

Hi Krisan,

Are you able to connect to the database using other tools - command line, pgAdmin?

Edward

-----Original Message-----
From: r-sig-db-bounces using r-project.org [mailto:r-sig-db-bounces using r-project.org] On Behalf Of krisan haria
Sent: 09 September 2013 13:02
To: R-sig-DB using r-project.org
Subject: [R-sig-DB] Error in connecting R to Postgre

Hi

I have the following version of R installed

R version 3.0.0

I'm trying to connect this to PostGre Version 1.16.1

I have loaded the package RPostgreSQL

I have then tried to run the following

> drv <- dbDriver("PostgreSQL")
> drv
<PostgreSQLDriver:(8568)>
> con <- dbConnect(drv, dbname="postgres")
Error in postgresqlNewConnection(drv, ...) :
  RS-DBI driver: (could not connect PLAYER using local on dbname "postgres"
)

Any idea on what is causing this error?

--
Dr. Krisan Haria

	[[alternative HTML version deleted]]

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group R-sig-DB using r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db