|
I am trying to connect the program pgAdmin III to PostgreSQL database on server. What should I specify in the Host field? I introduced the web146.webfaction.com but failed to connect. |
|
You cannot connect directly to your DB server from your desktop or any other remote system. Instead, you must go through a SSH tunnel and then use "localhost" or "127.0.0.1" as the host name in your DB client. More information is available in our documentation: Accessing a Database Remotely Is it possible to use pgAdmin after performing the steps in that document? I've tried the directions here [http://forum.webfaction.com/viewtopic.php?id=3458], but I'm still getting "password authentication failed for user..." Yes, it's possible. Can you confirm that you're using your database name as both the 'username' and 'database' name in pgAdmin, and using the database password in the 'password' field? Most commonly these errors are due to specifying an incorrect username |
