```html
Connecting to a PostgreSQL Server in pgAdmin 4
Defining a Server Connection
To establish a connection to a PostgreSQL server in pgAdmin 4, right-click on the "Servers" node in the left-hand pane and select "Create" > "Server..." from the context menu.
Connect to Server Dialog
In the "Connect to Server" dialog, provide the following information:
- Name: A descriptive name for the server connection.
- Host: The host name or IP address of the PostgreSQL server.
- Port: The port number on which the server is listening (default: 5432).
- Username: The PostgreSQL user name.
- Password: The password for the specified user.
Authentication Options
pgAdmin 4 supports various authentication methods, including: * Password * GSSAPI * AWS IAM * Azure Active Directory * Google Cloud Platform
Connecting via Paste
Alternatively, you can create a new server connection by pasting a PostgreSQL connection string into the "Connect to Server" dialog. This is useful when you have a connection string that was generated by another tool or application. To paste a connection string, click the "Paste Connection String" button in the "Connect to Server" dialog. This will open a new dialog where you can paste the connection string.
Accessing Server Objects
Once you have established a connection to a server, you can access its objects, such as databases, tables, views, and functions, in the right-hand pane of pgAdmin 4.
Comments