[R] Issues with RPostgres

[John McKown]

On Thu, Aug 27, 2015 at 2:29 PM, Abraham Mathew <mathewanalytics at gmail.com>
wrote:

> I have a user-defined function that I'm using alongside a postgresql
> connection to
> summarize some data. I've connected to the local machine with no problem.
> However,
> the connection keeps throwing the following error when I attempt to use it.
> Can anyone point
> to what I could be doing wrong.
>
> > ds_summary(con, "test", vars=c("Age"), y=c("Class"))
> Error in postgresqlNewConnection(drv, ...) :
>   RS-DBI driver: (could not connect postgres at localhost on dbname "test"
> )
>
>
> con is the connection
>

​It would be helpful to see the assignment to "con" as well as any other
assignments related to this. If you are using the DBI package, then what I
am talking about would be something like:

drv<-dbDriver("PgSQL")
con<-dbConnect(drb,user=...,password=...,dbname="test');

>From looking at the message, it appears to me that you are trying to
connect to PostgreSQL as the "postgres" user. That just seems wrong to me.
Normally that user is only for administration purposes. It does not
normally contain user tables such as "test". I would think that what you
needed would be your PostgreSQL user id. Or the id of the owner of the
"test" table.​




> test is the database table
> age is the attribute that will be summarized
> class is the response variable
>
> Can anyone help?
>
>
> --
>
>
> *Abraham MathewData Ninja and Statistical Modeler*
>
>
>
> *Minneapolis, MN720-648-0108 at abmathewksAnalytics_Blog
> <https://mathewanalytics.wordpress.com/>*
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



-- 

Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.

Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.

He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown

	[[alternative HTML version deleted]]