Overview
psql version and extensions
psql version and the installed timescaledb extension confirmed via the \dx meta-command inside the tsdb database.
psql version and extensions
Service status and extension version
Hypertable and time_bucket query
This is a repackaged open source software product wherein additional charges apply for cloudimg support services.
Overview TimescaleDB is the open source time-series SQL extension for PostgreSQL, letting you write standard SQL queries against billions of rows and get millisecond response times. Hypertables automatically partition time-series data into chunks, continuous aggregates pre-compute common rollups, and native columnar compression can reduce storage by up to 95 percent. This image delivers TimescaleDB fully installed and configured on top of PostgreSQL, so a production-ready time-series database is running within minutes of launch.
Database Stack PostgreSQL with the TimescaleDB extension running as a systemd service. Installed from the official PGDG APT repository for PostgreSQL and the Timescale Community packagecloud repository for the extension. Community edition (Apache 2.0) only, with no Timescale License cloud-hosting restrictions. timescaledb-tune has been run to calibrate shared_buffers and work_mem to the instance's available RAM.
Secure First Boot On the first boot of your 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 straight away. Database files are stored on a dedicated, independently resizable data disk.
cloudimg Support 24/7 technical support by email and chat. Help with TimescaleDB deployment, hypertable design, continuous aggregates, compression policies, replication and database administration.
Use Cases IoT telemetry storage and analytics. Application performance monitoring. Financial tick data. Energy meter readings. Sensor fusion pipelines. Observability back ends.
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 and PostgreSQL preinstalled and ready with hypertables, continuous aggregates and columnar compression configured, and no manual setup required
- Hardened first boot generates a fresh PostgreSQL superuser password for every instance and stores it in a file only the root user can read, so no shared credentials ever ship in the image
- 24/7 technical support from cloudimg with expert assistance for TimescaleDB hypertable design, compression policies, continuous aggregates and database administration
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 |
t3.micro | t3.micro instance type | $0.04 |
t2.micro | t2.micro instance type | $0.04 |
c6id.large | c6id.large instance type | $0.08 |
vt1.3xlarge | vt1.3xlarge instance type | $0.24 |
inf1.6xlarge | inf1.6xlarge instance type | $0.24 |
r8a.16xlarge | r8a.16xlarge instance type | $0.24 |
m6in.large | m6in.large instance type | $0.08 |
c8ib.large | c8ib.large instance type | $0.08 |
g6e.xlarge | g6e.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 the TimescaleDB image.
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). Retrieve the generated PostgreSQL credentials with: sudo cat /root/timescaledb-credentials.txt. Connect to the default tsdb database with: PGPASSWORD='<password>' psql -U postgres -h localhost -d tsdb. Restrict port 5432 to trusted networks or application subnets. The user guide at https://www.cloudimg.co.uk/guides/timescaledb-2-aws/ covers hypertable creation, continuous aggregates and compression policies.
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.