IvorySQL 5.4 on Ubuntu 24.04 LTS

Azure Databases

IvorySQL, an Oracle compatible distribution of PostgreSQL that answers Oracle SQL and native PostgreSQL from one database.

Base
Hardened build
minimal ports, security patches applied at build time
Access
Unique credentials
generated on first boot, readable only by root
Verified
Boots working
services pass a health gate before release
Support
24/7, 365 days
by email and live chat, 24 hour response SLA

Overview

IvorySQL is an open source, Oracle compatible distribution of PostgreSQL. It is the complete PostgreSQL engine, unmodified, with an Oracle compatibility layer built on top: PL/iSQL, packages, Oracle data types such as number, varchar2 and date, the sys schema, and Oracle built ins including dual, sysdate, nvl and to_char.

What makes it unusual is that one cluster answers on two ports. One port parses standard PostgreSQL, the other parses Oracle SQL, and both read and write exactly the same tables. A migrating Oracle application can keep speaking Oracle while your existing PostgreSQL reporting, backup and monitoring tools keep speaking PostgreSQL, against a single database and with neither side rewritten. That makes it a practical staging post for moving off Oracle at your own pace, as well as a capable general purpose relational database in its own right.

Why the cloudimg image

The image ships with no database cluster at all, which is the point: there is no data directory, no authentication file, no roles and no credential to discover. Each virtual machine initialises its own cluster on first boot and generates a superuser password and a TLS certificate that exist nowhere else, and the database service is held closed until that has happened. Stock PostgreSQL would otherwise write passwordless trust authentication by default; here it never exists. Both listeners are bound to loopback until you deliberately open them, the compiler used to build the engine is removed before capture, and a shipped self check verifies the whole posture in one command. Paired with a walk through verified deployment guide and 24/7 cloudimg support.

Common uses

  • Migrating Oracle workloads to PostgreSQL without rewriting PL/SQL first
  • Running Oracle style and PostgreSQL style clients against one database
  • A general purpose relational database with Oracle syntax compatibility