Derek Coleman & Associates Inc logoDerek Coleman & Associates Inc

Home / Marketplace / PostgreSQL on AlmaLinux 9

PostgreSQL on AlmaLinux 9

PostgreSQL on AlmaLinux 9: the world's most advanced open-source database on an enterprise-grade RHEL-compatible base. This image gives you a production-ready deployment within minutes of first boot — no dependency wrangling, no manual hardening checklist. Published and maintained by Derek Coleman & Associates Inc: freshly rebuilt against current security advisories and deployable straight from the Azure Marketplace into your own subscription.

Version: PostgreSQL (AlmaLinux 9 AppStream package)Platform: AlmaLinux 9Ports: 5432 (PostgreSQL) — opened in firewalld at first boot; the server listens on localhost until you set listen_addressesCategory: Databases

What's included

  • PostgreSQL latest installed from the official upstream source
  • AlmaLinux 9 base with automatic security updates enabled
  • No shared or default passwords baked into the image
  • Trusted Launch support: Secure Boot + vTPM
  • Azure Monitor Agent, Defender for Cloud, and Update Manager install cleanly

Quick start

  1. Deploy from the Azure Marketplace (Get It Now → Create), choosing your SSH key at the Administration step.
  2. Allow inbound SSH (22) for yourself plus the application port(s): 5432 (PostgreSQL) — to your application subnets only — restrict to your own IP where possible. The in-image firewall already allows them; only the Network Security Group (NSG) keeps them closed.
  3. Connect locally with `sudo -u postgres psql`, or over TCP as postgres with the generated superuser password (see First login below).
  4. Set listen_addresses and a pg_hba.conf rule for your subnets, restart PostgreSQL, then open 5432 in the NSG to your app tier only.

Get your admin password (one time)

ssh <your-username>@<VM-IP>
sudo cat /var/lib/pgsql/.superuser-password

Sign in as postgres — either with `sudo -u postgres psql` (peer authentication) or with the generated password in /var/lib/pgsql/.superuser-password over TCP. Change the password and create a least-privilege application role before you open 5432 to anything.

Common use cases

  • Transactional workloads on a RHEL-compatible base
  • Analytics and reporting databases
  • Geospatial workloads with PostGIS
  • On-prem PostgreSQL lift-and-shift

Why our images

Freshly rebuilt against the latest security advisories, no shared default credentials, Trusted Launch support, and automatic OS security updates — everything runs in your own Azure subscription under your governance.

Deploy PostgreSQL in minutes

Production-ready, hardened, and maintained. Deploy straight from the Azure Marketplace into your subscription.