On Fri, Jan 31, 2014 at 9:40 PM, andrewH <ahoer...@rprogress.org> wrote:
>
> In the description section of the RPostgreSQL package documentation, it
> states:
>
> "In order to build and install this package from source, PostgreSQL itself
> must be present your system to provide PostgreSQL functionality via its
> libraries and header files. . . . On Microsoft Windows system the attached
> libpq library source will be used."
>
> I am not sure what "attached" means in this setting.
>
> After successfully running:
> install.packages('RPostgreSQL')
>
> When I tried to run:
> require('RPostgreSQL')
> drv <- dbDriver("PostgreSQL", fetch.default.rec=10000)
> con <- dbConnect(drv, dbname="postgres")
>
> I get the error message:
> Error in postgresqlNewConnection(drv, ...) :
> RS-DBI driver: (could not connect Administrator@local on dbname
> "postgres")
>
> I am guessing that this error is because PostgreSQL either does not exist or
> has been improperly installed.
Or you're not running a postgres db on your local machine with that
accepts a connection with username Administrator and no password? I
doubt that's the error you would see if RPostgreSQL hadn't found
libpq.
Hadley
--
http://had.co.nz/
______________________________________________
R-help@r-project.org mailing list
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.
