Database guides

EDB Postgres Advanced Server

Updated 2026-08-11 · 2 min read

EnterpriseDB’s PostgreSQL distribution with Oracle compatibility layered on. Stock catalog, so the full AddisDB Postgres toolset applies. Note the default port is 5444.

EDB Postgres Advanced Server is PostgreSQL packaged by EnterpriseDB with an Oracle-compatibility layer added — PL/SQL-style syntax, Oracle-shaped built-ins, and a set of dba_ and all_ catalog views alongside the normal Postgres ones. Underneath it is PostgreSQL with a complete catalog, so AddisDB connects with its Postgres driver.

Who it is for

It exists for organisations migrating off Oracle who want to move the database without rewriting every stored procedure at the same time. If you are not carrying Oracle-compatibility requirements, community PostgreSQL is the simpler choice and AddisDB treats them identically anyway.

The practical difference on day one is the port. Advanced Server listens on 5444, not 5432, so that PostgreSQL and EDB can be installed side by side. AddisDB prefills 5444 for this engine.

Set up the server

  1. Note the host and confirm the port — 5444 for Advanced Server, though a site standard may have changed it.
  2. The bundled superuser is enterprisedb in Oracle-compatible mode and postgres in the Postgres-compatible one. Ask which mode the installation runs in.
  3. Add your client address to pg_hba.conf and reload.
  4. Confirm the role you will use has CONNECT on the database and SELECT on the schemas you care about.
# Advanced Server on its own port
psql -h edb.example.com -p 5444 -U enterprisedb -d edb -c 'SELECT version();'

Connect from AddisDB

  1. New Connection → EDB Postgres Advanced Server. Port prefills to 5444, database to edb and username to enterprisedb.
  2. Enter the host and your credentials.
  3. Set SSL mode to require if the server terminates TLS, and attach the CA certificate if you want it verified.
  4. Test, then Save.

What AddisDB gives you

The full PostgreSQL toolset, because the catalog is PostgreSQL’s: schema tree, in-grid editing, structured create and alter table, database-user management, mock data, test clones, and the complete EXPLAIN option list.

The Live Monitor is real, reading pg_stat_activity for live sessions and table sizes, with cancel and terminate available.