I am using RStudio Version1.0.143 on a Windows 7 machine. R version 3.4.0
I am trying to connect to a postgreSQL database with the following
command, but I receive an error message that says my password is
incorrect. Since I saved my password in a file, I think I remember it.
I searched for a solution online, but cannot figure out what to do. If I
have to change my password, please provide explicit instructions.
> con <- DBI::dbConnect(RPostgreSQL::PostgreSQL(),
+ password = "sql1",
+ port = 5432,
+ dbname = "pg_dump-sfpg-2017-08-18"
Error in postgresqlNewConnection(drv, ...) :
RS-DBI driver: (could not connect Ira@localhost:5432 on dbname
"pg_dump-sfpg-2017-08-18": FATAL:password authentication failed for user
Note also that I have never used psql. Someone sent me a file which I
intended to analyze using R. I do know how to write SQL queries, having
used SQL Server.
On 8/26/2017 9:47 PM, John wrote:
> On Sat, 26 Aug 2017 18:35:31 -0700
> Ira Sharenow via R-help <[hidden email]> wrote:
> Can you access the postgres database through psql or some other route?
> Also, do you require a password to access the database from these