Ask a Question
Report a Bug
This page in other versions:
Warning: This documentation is for a pre-release version of pgAdmin 4
Use the Server dialog to describe a connection to a server. Note: you must
ensure that the pg_hba.conf file of the server from which you are connecting
allows connections from the host of the client.
Use the fields in the General tab to identify the server:
Click the Connection tab to continue.
Use the fields in the Connection tab to configure a connection:
Click the SSL tab to continue.
Use the fields in the SSL tab to configure SSL:
If pgAdmin is installed in Server mode (the default mode), you can use the
platform-specific File manager dialog to upload files that support SSL
encryption to the server. To access the File manager dialog, click the
icon that is located to the right of each of the following fields.
In Server mode, certificates, private keys, and the revocation list
are stored in the per-user file storage area on the server, which is owned
by the user account under which the pgAdmin server process is run. This
means that administrators of the server may be able to access those files;
appropriate caution should be taken before choosing to use this feature.
Click the SSH Tunnel tab to continue.
Use the fields in the SSH Tunnel tab to configure SSH Tunneling:
You can use the “SSH Tunnel” tab to connect pgAdmin (through an intermediary
proxy host) to a server that resides on a network to which the client may
not be able to connect directly.
Set “Use SSH tunneling” to Yes to specify that pgAdmin should use an SSH
tunnel when connecting to the specified server.
Specify the name or IP address of the SSH host (through which client
connections will be forwarded) in the Tunnel host field.
Specify the port of the SSH host (through which client connections will be
forwarded) in the Tunnel port field.
Specify the name of a user with login privileges for the SSH host in the
Specify the type of authentication that will be used when connecting to the
SSH host in the Authentication field:
Select the Password option to specify that pgAdmin will use a password
for authentication to the SSH host. This is the default.
Select the Identity file to specify that pgAdmin will use a private key
file when connecting.
If the SSH host is expecting a private key file for authentication, use the
Identity file field to specify the location of the key file.
If the SSH host is expecting a password of the user name or an identity file
if being used, use the Password field to specify the password.
Check the box next to Save password? to instruct pgAdmin to save the
password for future use. Use
Clear SSH Tunnel Password to remove the saved
Click the Advanced tab to continue.
Use the fields in the Advanced tab to configure a connection:
The password file option is only supported when pgAdmin is using libpq
v10.0 or later to connect to the server.