Overview
Hypertable creation
Creating a TimescaleDB hypertable from a standard PostgreSQL table with create_hypertable().
Hypertable creation
time_bucket aggregate
Retention policy
This is a repackaged open source software product wherein additional charges apply for cloudimg support services.
Overview TimescaleDB is the open source PostgreSQL extension purpose built for time-series data. It adds hypertables, automatic time and space partitioning, continuous aggregates and data retention policies on top of a stock PostgreSQL backend, so every PostgreSQL client, driver and tool continues to work unchanged. This image ships the Community Edition of TimescaleDB under the Apache 2.0 licence, layered on PostgreSQL 16 from the official PGDG repository, and tuned with timescaledb-tune for production time-series workloads.
Database Stack PostgreSQL 16 from the official PostgreSQL Global Development Group (PGDG) APT repository, with TimescaleDB Community installed as a shared_preload_libraries extension from the official Timescale packagecloud repository. A dedicated cloudimg application database with the TimescaleDB extension enabled is ready to receive hypertables on first boot.
Secure First Boot On the first boot of your instance a one shot service rotates both the postgres superuser password and the cloudimg application role password to fresh random values unique to that instance, re-enables the TimescaleDB extension in the cloudimg database, and stores the passwords in a root only credentials file. No shared or default credentials ship in the image.
Ready To Use The PostgreSQL service, configuration, data directory, extension and application database are all prepared. Connect with psql, any standard PostgreSQL driver or your existing tooling and start creating hypertables, continuous aggregates and retention policies immediately. Database files live on a dedicated, independently resizable EBS data volume.
cloudimg Support 24/7 technical support by email and chat. Help with PostgreSQL and TimescaleDB deployment, upgrades, replication, performance tuning, hypertable design and retention strategy.
Use Cases IoT and sensor telemetry. Application and infrastructure metrics. Financial market and trading data. Industrial monitoring. Log and event analytics. Anywhere time-ordered data needs PostgreSQL compatibility plus high ingest and fast time-range queries.
All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
Highlights
- TimescaleDB Community on PostgreSQL, preinstalled with hypertables, continuous aggregates and retention policies available immediately and no manual setup required
- Hardened first boot rotates both the postgres superuser and cloudimg application role passwords per instance and stores them in a file only the root user can read, so the database is never left with default credentials
- 24/7 technical support from cloudimg, with expert assistance for PostgreSQL and TimescaleDB deployment, hypertable design, retention policy and performance tuning
Details
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Free trial
- ...
Dimension | Description | Cost/hour |
|---|---|---|
m5.large Recommended | m5.large | $0.08 |
t2.micro | t2.micro instance type | $0.04 |
t3.micro | t3.micro instance type | $0.04 |
r5ad.16xlarge | r5ad.16xlarge instance type | $0.24 |
p5.48xlarge | p5.48xlarge instance type | $0.24 |
r8id.xlarge | r8id.xlarge instance type | $0.12 |
m8i.96xlarge | m8i.96xlarge instance type | $0.24 |
r7a.metal-48xl | r7a.metal-48xl instance type | $0.24 |
r6in.2xlarge | r6in.2xlarge instance type | $0.24 |
r5d.xlarge | r5d.xlarge instance type | $0.12 |
Vendor refund policy
Refunds available on request.
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Initial release of TimescaleDB Community 2.x on PostgreSQL 16.
Additional details
Usage instructions
Connect via SSH on port 22 as the default login user for your operating system variant (the user guide lists it per variant). PostgreSQL with TimescaleDB listens on port 5432. Retrieve the generated credentials with: sudo cat /root/timescaledb-credentials.txt. Connect locally as the application role with: PGPASSWORD='<password>' psql -h 127.0.0.1 -U cloudimg -d cloudimg. Restrict port 5432 to trusted networks at the security-group level before opening it to the internet. A small nginx landing page is served on port 80 for the Marketplace health check, which is safe to leave open.
Resources
Vendor resources
Support
Vendor support
cloudimg provides 24/7 technical support for this product by email and live chat. Our engineers help with deployment, configuration, updates, performance tuning and troubleshooting; critical issues receive a one hour average response. Contact support@cloudimg.co.uk .
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.