R and PostgreSSQL error


#1

Tried to connect R with PostgresSQL but it failed throwing error. Not able to figure out the exact issue.

Executed Script -
pg=dbDriver("PostgreSQL")

con < dbConnect(pg,user="rasao",password="1281",host="localhost",port=5432, dbname="banking_case")

"Error in postgresqlNewConnection(drv, ...) :
RS-DBI driver: (could not connect rasao@localhost:5432 on dbname "banking_case": FATAL: password authentication failed for user "rasao"


#2

This error doesn't make it more clear? Are you sure your password is correct?


#3

To connect to PostgreSQL database the username is rasao and password is 1281.

I am entering the same password, but R is throwing error authentication failed for user rasao.

Is there any other way to connect R to PostgreSQL database?


#4

Not 100% confident, but I believe I've run into this issue recently, and got around it by putting the credentials into a .pgpass file. Try following this guide


#5

If you are currently using dbplyr or RPostgresSQL,

try this package:


#6

Not 100% sure if this is the best way to do it, but I use a .ini file and then use gsub to extract the credentials. I would also recommend the RPostgres package to connect. Here's a quick example I spun up a while ago.


#7

Thank you so much for the info