[R] Problem connecting to database via RPostgreSQL/RS-DBI: "could not connect" error

[Hadley Wickham]

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
> 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 at 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/