If the provided settings and credentials for both the database connection and the SSH tunnel are correct and valid, the tunnel and database connection should be established successfully. Then click SAVE as highlighted in the following screenshot. We recommend using public-key authentication so select IDENTITY FILE and select the private key file from your local machine. Then select the Authentication type (either password or identity file). Turn on the “ Use SSH tunneling” option, enter the Tunnel host, Tunnel port, SSH username. You can check Save password to store the password locally so that you are not prompted to enter it every time you attempt to connect to the database. Then set the port, database name, database username, and the user’s password. Enter the database server IP address or FQDN (fully qualified domain name). Next, click on the Connection tab to enter the database connection settings. In the pop-up window, under the General tab, enter the server name as highlighted in the following screenshot. Open your pgadmin4 application and start by creating a new server connection, go to the Objects tab, then click Create and click Server.
0 Comments
Leave a Reply. |