connector
PostgreSQL logo

PostgreSQL

The open-source relational database — full SQL support.

Connection fields

FieldRequiredDescription
hostYesHostname or IP address of the Postgres server.
portNoDefaults to 5432.
userYesUsername to authenticate with.
passwordNoNot enforced by the connector, but almost every real server requires one — leave it blank only against a server configured to allow passwordless auth.
dbnameYesDatabase name to connect to.
sslmodeNoOne of "disable", "prefer" (default), or "require".
Add data source form for a PostgreSQL connection

Example configuration

{
  "host": "db.internal.example.com",
  "port": 5432,
  "user": "arcodash_reader",
  "password": "••••••••",
  "dbname": "analytics",
  "sslmode": "require"
}

Caveats

  • arcodash needs network access to reach the host, so a cloud-hosted Postgres instance must accept connections from the internet. arcodash doesn't publish a fixed set of outbound addresses to allowlist — enable SSL/TLS rather than relying on IP filtering.
  • sslmode "require" only enforces that the connection is encrypted, not that the server certificate is verified against a CA.