[R] Problem connecting to database via RPostgreSQL/RS-DBI: "could not connect" error
h.wickham at gmail.com
Mon Feb 3 16:24:56 CET 2014
On Fri, Jan 31, 2014 at 9:40 PM, andrewH <ahoerner at rprogress.org> wrote:
> In the description section of the RPostgreSQL package documentation, it
> "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:
> When I tried to run:
> 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 at local on dbname
> 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
More information about the R-help