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]]