PostgreSQL version: 11
R Version: 3.5.2
OS: Windows 10
Driver: PostgreSQL ANSI(x64)
The following code worked just fine two weeks ago but suddenly stopped working. The only change is, I had to go into windows settings and change the list separator setting from ',' to '|' for a different project. I've since changed it back. There have been no other changes to my machine. I have a DSN called DVDRental. The point of using the DSN is so people don't put passwords in code. I've tried specifying the database and that doesn't work either. The DSN connects properly. It's like sqldf isn't using RPostgreSQL anymore.
library(sqldf)
library(RPostgreSQL)
library(Hmisc)
library(rpart)
library(rpart.plot)
options(sqldf.RPostgreSQL.DSN = "DVDRental")
films_all_numbers = sqldf("SELECT * FROM total_revs_by_film_numbers_only")
Error message: Error in postgresqlNewConnection(drv, ...) : RS-DBI driver: (could not connect postgres@localhost:5432 on dbname "test": FATAL: password authentication failed for user "postgres" )
Error message with db specification:Error in postgresqlNewConnection(drv, ...) : RS-DBI driver: (could not connect postgres@localhost:5432 on dbname "DVDRental": FATAL: password authentication failed for user "postgres" )