TimescaleDB 2 on Ubuntu by cloudimg

TimescaleDB 2 on Ubuntu 22.04 by cloudimg

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.

Why TimescaleDB over a purpose built time series engine

• Full PostgreSQL compatibility. Every PostgreSQL driver, client, ORM, and BI tool works with TimescaleDB unchanged
• Standard SQL as the query language. No new query language to learn
• Hypertables for automatic time based partitioning. Chunks are created on demand, queries route across the right chunks
• Continuous aggregates for real time rollups. Materialised views refresh incrementally
• Native columnar compression. Typical 90% or better space savings on cold chunks
• time_bucket and time_bucket_gapfill aggregates, 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
• TimescaleDB 2 Community edition installed from the Timescale packagecloud repository, Apache 2.0 licensed
• 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

What this image is

• A production ready single node PostgreSQL 16 server with TimescaleDB 2 Community enabled
• Pre installed from official upstream APT repositories
• Hardened by cloudimg: credentials never baked into the image, SSH keys truncated to preserve Azure injection, build time admin user removed for Azure Marketplace certification

What this image is not

• Not a replicated PostgreSQL cluster. For high availability use Patroni, repmgr, or the Timescale hosted service
• Not TLS encrypted out of the box. See the user guide for ssl on and certificate bundle patterns
• Not the Timescale License (TSL) edition. Apache 2.0 Community only

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
• Data Directory: /var/lib/postgresql/16/main
• Config: /etc/postgresql/16/main/postgresql.conf and pg_hba.conf
• Postgres OS User: postgres (owns the data directory and runs the server)
• Recommended Size: Standard_D2s_v3 (2 vCPU, 8 GB RAM); scale to D4s_v3 or larger for heavy workloads
• VM Generation: Hyper V Gen2 with UEFI boot

Security

• Latest CVE patches applied at build time
• SSH hardened with key based authentication
• No Java, no Python, no embedded interpreter: runtime CVE surface is PostgreSQL plus Ubuntu
• scram-sha-256 authentication enforced; postgres password is generated on first boot, unique per VM
• Restrict port 5432 to application subnets 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.