Skip to content

How To Connect to GreengageDB

GreengageDB is PostgreSQL-compatible (it speaks the PostgreSQL wire protocol), so the basics — host, port, database, user, password, SSL, and SSH tunneling — work the same way as a Postgres connection.

Basic connection

  1. Create a new connection in Beekeeper Studio.
  2. Select GreengageDB from the database type dropdown.
  3. Fill in:
    • Host
    • Port
    • Database
    • User
    • Password
  4. (Optional) Configure SSL/TLS and/or SSH Tunnel.
  5. Click Test Connection, then Connect.

GreengageDB docs

To learn more about GreengageDB and how to set up your environment (including Docker), see the official documentation:

GreengageDB documentation

GreengageDB 6 vs 7

Beekeeper Studio supports both GreengageDB 6 and GreengageDB 7.

GreengageDB 6 (PostgreSQL 9.4–compatible)

GreengageDB 6 is based on an older PostgreSQL version, so some newer PostgreSQL features are not available.

Known example:
- GENERATED columns (PostgreSQL 12+) are not supported.

GreengageDB 7

GreengageDB 7 is generally recommended when you have a choice.