Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I can tune the connection to PostgreSQL server by SSH. What values do I need to input to the fields on SSH tab of Database Registration dialog?

April 26, 2017connection database Fields input PostgreSQL server SSH Tab tune values

0

Posted

I can tune the connection to PostgreSQL server by SSH. What values do I need to input to the fields on SSH tab of Database Registration dialog?

1 Answer

0

Posted

You need to input the following: On SSH tab: – 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. On General tab: – 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 password of the PostgreSQL user.