Connecting to a PostgreSQL Server

Add a Server

Right-click Servers > Create > Server, then in the Connection tab fill:

Name:        my-postgres
Host:        127.0.0.1
Port:        5432
Username:    postgres
Password:    ******

Save. The server appears in the tree with databases below it.

SSL and Advanced Options

The SSL tab forces encryption; the Advanced tab sets the maintenance database and role. Over a public network always enable SSL.

Testing the Connection

After saving, pgAdmin opens the server with databases (postgres, template0/1). If it fails, verify host, port, and that pg_hba.conf allows your connection from this IP.

Managing Connections

Right-click the server > Disconnect when idle, and Reconnect when needed. Saved passwords are optional - pgAdmin will prompt otherwise.

Key Points

• You register servers; pgAdmin never finds them magically.
• Host, port, role and password are the essentials.
• SSL tab protects remote connections.
• Failures usually trace to pg_hba.conf or firewall.