TimescaleDB preinstalled for AWS. PostgreSQL with the TimescaleDB time-series extension, hypertables, continuous aggregates and columnar compression on Ubuntu 22.04, with a per-instance PostgreSQL password generated on first boot. Backed by 24/7 cloudimg support.
## TimescaleDB by cloudimg
TimescaleDB is the open source time-series SQL extension for PostgreSQL. Hypertables automatically partition data by time, continuous aggregates pre-compute analytic rollups, and native columnar compression reduces storage by up to 95 percent. This Amazon Machine Image delivers TimescaleDB fully installed and configured, so a production-ready time-series database is running within minutes of launch.
## Application Stack
PostgreSQL with the TimescaleDB Community edition (Apache 2.0) extension, installed from the official PGDG and Timescale packagecloud repositories. timescaledb-tune calibrates shared_buffers and work_mem at install time. Database data is stored on a dedicated resizable EBS volume.
## Secure First Boot
On the first boot of every instance a one-shot service generates a fresh PostgreSQL superuser password, unique to that instance, and writes it to a root-only file. No shared or default credentials ship in the image.
## Ready To Use
Connect with the credentials from /root/timescaledb-credentials.txt and start creating hypertables, continuous aggregates and time-bucket queries immediately.
## cloudimg Support
cloudimg provides 24/7 technical support for this image, covering TimescaleDB deployment, hypertable design, compression policies, continuous aggregates and database administration.