Connect to PostgreSQL databases to query and analyze your relational data. Supports PostGIS for spatial queries.
Connect to PostgreSQL
- Click Add data in the Layers panel
- Go to the Connections tab
- Select PostgreSQL
- Fill in the connection parameters
- Click Create Connection
Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| Connection Name | Yes | A friendly name to identify this connection |
| Host | Yes | Hostname or IP address (e.g., localhost, db.example.com) |
| Port | Yes | Port number (default: 5432) |
| Database | Yes | Database name to connect to |
| Username | Yes | Database username |
| Password | Yes | Database password |
| Schema | No | Default schema within the database |
SSL/TLS Configuration
Enable SSL/TLS for encrypted connections to your database. When enabled, you can optionally upload:
- Client Certificate: PEM or CRT format
- Private Key: PEM or KEY format
- CA Certificate: For server verification
Working with Data
After connecting, browse available tables and views. Select the data you want to import and click Add to Project. Tables with PostGIS geometry columns import as vector layers with all attributes preserved.
Firewall Configuration
If your database is behind a firewall, whitelist these Atlas IP addresses:
16.16.129.130
51.20.23.178
13.50.71.210
51.21.188.73
Troubleshooting
| Issue | Solution |
|---|---|
| Connection Refused | Verify host and port. Check postgresql.conf allows external connections. |
| Authentication Failed | Confirm credentials. Check pg_hba.conf for auth method. |
| Database Not Found | Database names are case-sensitive. |
| No Spatial Data | Ensure PostGIS is installed. Run SELECT * FROM geometry_columns; to verify. |
| Timeout | Check network connectivity and firewall rules. |