Setup guide

PostgreSQL SSH tunneling on macOS

SSH tunneling lets you connect to private PostgreSQL instances safely over encrypted channels without exposing database ports publicly.

Prerequisites

  • - A bastion or jump host with SSH access.
  • - PostgreSQL host reachable from the bastion.
  • - Database credentials with least-privilege access.

Step-by-step

  1. 1.Validate SSH connectivity to your bastion from your macOS machine.
  2. 2.Configure local tunnel forwarding from a local port to your PostgreSQL host and port.
  3. 3.Point VeloxDB connection host to localhost and use the forwarded local port.
  4. 4.Enable SSL mode where required by your infrastructure policy.
  5. 5.Store connection details securely and test reconnect behavior after restarting the tunnel.

Related resources

Migrate from pgAdminMigrate from DBeaverPostgreSQL SSL setupDownload VeloxDB