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

[NISHIYAMA Tomoaki]

Hi,

While Dirk is right in that psql and RPostgreSQL should behave the same,
both psql and RPostgreSQL should be able to connect via unix domain socket.

In this case, what you are trying is equivalent to

psql -U PLAYER postgres
(on the host you are running R)

Does this work?

Best regards,
-- 
Tomoaki NISHIYAMA

Advanced Science Research Center,
Kanazawa University,
13-1 Takara-machi, 
Kanazawa, 920-0934, Japan


On 2013/09/09, at 22:14, Dirk Eddelbuettel wrote:

> 
> On 9 September 2013 at 14:57, Edward Vanden Berghe wrote:
> | 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?
> 
> Also:
> 
> -- what OS is this hosted on?
> 
> -- are you connecting via the network, or on the same machine?
> 
> -- RPostgreSQL "behaves like psql" in the sense that you MUST provide tcp/ip
>    access to PostgreSQL whereas the other apps may use other means
> 
> -- hence make sure you can, say, connect with psql from another box after
>    which RPostgreSQL will work too.
> 
> These are not R-related questions. Check the PostgreSQL documentation for
> 'enable network access' etc.
> 
> Dirk
> 
> 
> 
> | 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]]
> | 
> | 
> | ----------------------------------------------------------------------
> | _______________________________________________
> | 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
> 
> -- 
> Dirk Eddelbuettel | edd using debian.org | http://dirk.eddelbuettel.com
> 
> _______________________________________________
> 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