TimescaleDB 2 Community on Ubuntu 22.04 by cloudimg. Open source time series extension for PostgreSQL, Apache 2.0 licensed, with hypertables, continuous aggregates, and native compression. Full PostgreSQL compatibility: every SQL client, driver, and ORM works unchanged. 24/7 expert support.
TimescaleDB 2 Community on Ubuntu 22.04 LTS, packaged and supported by cloudimg as an Azure Marketplace virtual machine image.
TimescaleDB is the open source time series extension for PostgreSQL, licensed under the Apache 2.0 licence for its Community edition. The image ships PostgreSQL 16 from the official PGDG APT repository with the TimescaleDB extension pre installed and enabled in a default database called tsdb. Every PostgreSQL tool and client you already use works unchanged: psql, pg_dump, pg_restore, pgAdmin, DBeaver, every ORM, every driver. Standard SQL plus TimescaleDB's purpose built time series extensions on top.
Why TimescaleDB over a purpose built time series engine
* Full PostgreSQL compatibility. Every PostgreSQL driver, client, ORM, and BI tool works with TimescaleDB unchanged because it is a PostgreSQL extension, not a separate engine
* Standard SQL as the query language. No new query language to learn, no new skills to hire, no new tooling ecosystem to build out
* Hypertables for automatic time based partitioning. Chunks are created on demand as data lands, and queries transparently route across the right chunks
* Continuous aggregates for real time rollups. Materialised views that refresh incrementally against the underlying hypertable, so dashboards query pre aggregated data instead of scanning raw rows
* Native columnar compression. Typical 90% or better space savings on cold chunks, configurable by compression policy
* time_bucket and time_bucket_gapfill aggregates for arbitrary bucket sizes, plus locf and interpolate for filling missing observations
Pre configured for production posture on day one
* PostgreSQL 16 installed from the official PGDG APT repository, so future security patches pull through the standard apt channel
* TimescaleDB 2 Community edition installed from the Timescale packagecloud repository, Apache 2.0 licensed, no cloud hosting restrictions
* Listener on port 5432, bound to 0.0.0.0 so application servers and Grafana on the same virtual network can reach it
* scram-sha-256 authentication enforced on every remote connection
* Unique postgres password generated on the very first boot of every deployed virtual machine, written to a root only credentials file
* Default database tsdb created at build time with the TimescaleDB extension already enabled
* timescaledb-tune auto configures shared_buffers, effective_cache_size, work_mem, and maintenance_work_mem proportionally to available memory
* systemd supervision with a firstboot oneshot that rotates the password on customer first boot then disables itself
* Convenience wrappers at /usr/local/sbin for start, stop, and environment setup
What this image is
* A production ready single node PostgreSQL 16 server with TimescaleDB 2 Community enabled, ready to ingest time series data and serve SQL queries on day one
* Pre installed from official upstream APT repositories, with configuration files cloudimg owns
* Hardened by cloudimg: credentials never baked into the image, SSH keys truncated not deleted to preserve Azure's deployment injection, build time admin user removed to pass Azure Marketplace certification
What this image is not
* Not a replicated PostgreSQL cluster. The image is single node by design; for high availability use Patroni, repmgr, or the Timescale hosted service
* Not TLS encrypted out of the box. See Section 20 of the user guide for the recommended ssl = on and certificate bundle pattern
* Not the Timescale License (TSL) edition. We ship only the Apache 2.0 Community edition to avoid cloud hosting restrictions. TSL features like data tiering and role level security are not included
Components
* PostgreSQL 16, pinned at build time, installed from apt.postgresql.org
* TimescaleDB 2 Community, pinned at build time, installed from packagecloud.io/timescale/timescaledb
* PostgreSQL Binaries: /usr/lib/postgresql/16/bin/
* Data Directory: /var/lib/postgresql/16/main (cluster data: write ahead log, heap files, indexes)
* Config: /etc/postgresql/16/main/postgresql.conf and /etc/postgresql/16/main/pg_hba.conf
* Default OS User: your chosen admin user
* Postgres OS User: postgres (owns the data directory and runs the server)
* Recommended Size: Standard_D2s_v3 (2 vCPU, 8 GB RAM) for typical time series workloads; scale to D4s_v3 or larger for heavy ingest or concurrent analytical queries
* VM Generation: Hyper V Gen2 with UEFI boot
* Filesystem: Default Ubuntu gallery LVM layout
Security
* Latest CVE patches applied at build time, with a first boot apt-get update and upgrade for any patches published between build and deployment
* SSH hardened with key based authentication
* No Java, no Python, no embedded interpreter: the runtime CVE surface is PostgreSQL plus the base Ubuntu image
* scram-sha-256 authentication enforced out of the box; the postgres password is generated on first boot and is unique per virtual machine
* Recommended to restrict port 5432 to application and Grafana subnets in the NSG and enable ssl = on before production
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/timescaledb-2-on-ubuntu-22-04-azure for the full user guide.
TimescaleDB is a trademark of Timescale, Inc. This image uses the Apache 2.0 licensed Community edition. PostgreSQL is a registered trademark of the PostgreSQL Global Development Group. This image is a repackaged upstream distribution provided by cloudimg. Additional charges apply for build, maintenance, and 24/7 support.