Re: [R] Connect to postgreSQL

2017-08-26 Thread Ira Sharenow via R-help
I went to the Start menu and opened a psql shell. I entered some information, but when I entered the password, it said authentication failed. Server localhost, the default Database the file previously mentioned pg_dump-sfpg-2017-08-18 Port 5432 Username Ira Password sql1--  Fatal error When

Re: [R] Connect to postgreSQL

2017-08-26 Thread John
On Sat, 26 Aug 2017 18:35:31 -0700 Ira Sharenow via R-help 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 alternatives? JWDougherty __ R-help@r-project.or

[R] Connect to postgreSQL

2017-08-26 Thread Ira Sharenow via R-help
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 s