PostgreSQL 17 + pgAdmin 4 on Ubuntu 24.04

## PostgreSQL 17 with pgAdmin 4 on Ubuntu 24.04 on Azure by cloudimg

PostgreSQL 17 is a major release of the world's most advanced open source relational database, preinstalled on Ubuntu 24.04 LTS and paired with pgAdmin 4, the official web console, so you can run queries, manage schemas, and administer users in a browser from the moment the VM boots. The image is built by cloudimg for Microsoft Azure and ships with per VM unique credentials and production sensible defaults.

Why Choose cloudimg?

* 24/7 Expert Support with guaranteed 24 hour response for all requests and one hour average for critical issues. Contact support@cloudimg.co.uk

* Production Ready from Launch PostgreSQL 17 cluster started, pgAdmin 4 served on port 80, scheduled vacuum running

* Per VM Unique Credentials postgres role and pgAdmin admin passwords are regenerated on the first boot of every deployed virtual machine, so two virtual machines launched from the same gallery image never share credentials

* Azure Native Integration Built with Azure Linux Agent, cloud init, Gen2 Hyper V support, StandardSSD compatible

What's Included

* PostgreSQL 17 (PGDG packages from apt.postgresql.org)

* pgAdmin 4 latest, server mode, preconfigured with a local PostgreSQL 17 server connection

* Apache web server acting as front end for pgAdmin at /pgadmin4/ with a 302 redirect from /

* Ubuntu 24.04 LTS long term support base

* Unattended Upgrades for security patching

Initial Access

After the first boot completes, retrieve the auto generated credentials over SSH:

```

sudo cat /root/postgresql-credentials.txt

```

Browse to the public IP address of the virtual machine to land on the pgAdmin 4 login page. Sign in with the admin email and password from the credentials file, then open the preconfigured PostgreSQL 17 server in the left tree and enter the postgres role password when prompted.

Use Cases

* Drop in relational database for web applications, microservices, and line of business apps

* Development and staging environments that need pgAdmin for schema design and query plans

* Data engineering sandboxes, OLAP prototyping, time series with TimescaleDB and partman extensions

* JSON document store via jsonb, full text search, and PostGIS workloads

* Stepping stone to Azure Database for PostgreSQL Flexible Server for larger deployments

Technical Specifications

* Operating System: Ubuntu 24.04 LTS

* PostgreSQL Release: 17 from the PostgreSQL Global Development Group

* Web Console: pgAdmin 4 (server mode, Apache + mod_wsgi)

* Database Port: 5432 (localhost by default, open the NSG to expose)

* Web Port: 80 (Apache, redirect / → /pgadmin4/)

* VM Generation: Hyper V Gen2

* Recommended Size: Standard_D2s_v3 (2 vCPU, 8 GB RAM) or larger

* Default User: azureuser (sudo enabled)

Security

* Unique postgres and pgAdmin admin passwords generated on first boot and stored in /root/postgresql-credentials.txt with 0600 permissions, readable only by the root user

* PostgreSQL bound to 127.0.0.1, never exposed on a public network interface by default

* pgAdmin stores its own metadata in a SQLite DB under /var/lib/pgadmin with locked down permissions

* Compatible with Let's Encrypt via certbot for one command HTTPS rollout

Support

cloudimg provides 24/7/365 expert technical support. Guaranteed response within 24 hours, one hour average for critical issues. Contact support@cloudimg.co.uk.

Visit www.cloudimg.co.uk/guides/postgresql-17-pgadmin-on-ubuntu-24-04-azure for the user guide and www.cloudimg.co.uk/products for our catalogue.

PostgreSQL is a registered trademark of the PostgreSQL Global Development Group. pgAdmin is a project of the pgAdmin Development Team. This image is a repackaged upstream distribution provided by cloudimg. Additional charges apply for build, maintenance, and 24/7 support.