pgAssistant - Database connection

Database connection

Enable pg_stat_statements for query analysis. Setup guide

Connection URI

Connection URI (optional but used in priority)

If provided, the URI will populate the fields below automatically before the connection attempt.

Connection details

Host name

Port

Database name

User

Password

Connection options

Multi-database mode

Explore the whole PostgreSQL cluster from a single connection instead of one database only. Connect to any database on the instance (usually postgres); pgAssistant lists all non-template databases on that server.

Switch databases from the navigation menu. Query and schema analysis follow the selected database.

Collector target

Opening this tab tests the connection entered in General and finds matching Collector targets. Your selection is saved when you connect.

Search targets

Selected target

Open this tab to search available Collector targets.