I need to know what to put in Host (This i guess is localhost, b'coz am working at home right now)
The Port, by default is 5432
What should be the SSH Host name?
The SSH Port?
The SSH Username?
Answer:
- Host is a host where PostgreSQL server is located from the point of view of SSH server. If SSH and PostgreSQL server are on the same machine, it is equal to SSH Host, or may be 'localhost'.
- Port is a port of PostgreSQL server on Remote Host, by default it is 5432.
- User Name is a PostgreSQL user name.
- Password is a password of the PostgreSQL user.
Please note that PostgreSQL host name should be set relative to the SSH server in this case. For example, if both of PostgreSQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address. Please, do not forget to choose Use tunneling and SSH tunneling.
On the second step:
- SSH host name is a host where SSH server is activated.
- SSH port is a port where SSH server is activated.
- SSH user name is a user on Linux machine. (It is a Linux user. It is not a user of PostgreSQL server.)
- SSH password is a Linux user password.
No comments:
Post a Comment