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

[Edward Vanden Berghe]

Seems your user doesn���t have access. Did you get access with the same user and password through pgAdmin? Do you log connections to the database in postgresql.conf? If so, do you find anything in the PostgreSQL log file?

 

Edward

 

From: krisan haria [mailto:krisanharia using gmail.com] 
Sent: 09 September 2013 13:40
To: Edward Vanden Berghe
Cc: R-sig-DB using r-project.org
Subject: Re: [R-sig-DB] Error in connecting R to Postgre

 

Under pgAdmin yes. No issue there at all

 

On Mon, Sep 9, 2013 at 12:34 PM, Edward Vanden Berghe <evberghe using gmail.com> wrote:

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




-- 
Dr. Krisan Haria


	[[alternative HTML version deleted]]