search for: postgresqlnewconnection

Displaying 2 results from an estimated 2 matches for "postgresqlnewconnection".

2016 Apr 21
2
Error using RPostgreSQL
...;- dbConnect( drv, dbname = "dadqn30er7ghpl", host = "ec2-27-837-167-90.eu-west-1.compute.amazonaws.com", port = 5432, user = "tascofyvasswmblc", password = XXXXXX' ); I'm getting the error: Error in postgresqlNewConnection(drv, ...) : RS-DBI driver: (could not connect tascofyvasswmblc at ec2-27-837-167-90.eu-west-1.compute.amazonaws.com on dbname "dascn90er7ghpl" ) Any pointers would be hugely appreciated! Thanks, Izaak
2017 Aug 27
2
Connect to postgreSQL
...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 at localhost:5432 on dbname "pg_dump-sfpg-2017-08-18": FATAL:password authentication failed for user "Ira" ) Thanks. Ira [[alternative HTML version deleted]]