Features
The main features of the TimescaleDB Enterprise console, by area: services, HA, backups, upgrades, monitoring, security and licensing.
Database services
- PostgreSQL with TimescaleDB and PgBouncer, as a Standard service or an HA cluster. Each service keeps its versions until you upgrade it.
- Extensions: pgvector, PostGIS, pg_cron, pg_repack, Apache AGE, pgaudit, TimescaleDB Toolkit and the PostgreSQL contrib extensions.
- Settings of PostgreSQL, TimescaleDB, PgBouncer and HAProxy, and HBA rules. You review each change before it applies.
- A SQL browser, read-only by default.
High availability
- Standard HA and Advanced HA (etcd on the database servers, or on a separate DCS cluster).
- Automatic failover, and switchover, failover and rolling restart from the console.
- An optional virtual IP, and a recommended endpoint that always reaches the primary.
- Runbooks with measured recovery times.
Backup and restore
- pgBackRest backups on a schedule, full and differential, with retention in days or in backups.
- An automatic full backup after the first deploy and after each restore.
- A copy on a dedicated backup server, and a local copy for a Standard service.
- Point-in-time restore in place, and restore into a new service, also of a deleted service.
- A mark on backups that find corrupt pages.
- Encrypted console backups to a local directory or S3, and a restore of the console on a new host.
Upgrades
- Service upgrades of the PostgreSQL minor version, TimescaleDB, extensions and components.
- PostgreSQL major upgrades.
- Console upgrades with the installer, and a notice when a new release is available.
Servers and networking
- Ubuntu 26.04 servers, x86_64 or aarch64, enrolled with one command into the private WireGuard mesh of the console.
- No internet access on the servers: a deploy installs from the signed server packages of the console.
- Time sync from the console, and server health.
- Replace a server, resize a server, and change IP addresses.
Monitoring and alerts
- Metrics of each server and service, kept 30 days by default, with PromQL queries and federation into your own Prometheus.
- Alert rules with notifications by Slack, Microsoft Teams, webhook or email, and a heartbeat that alerts you when the console stops.
- Service logs and support reports.
Security and access
- Local users and single sign-on (OIDC).
- Two-factor authentication (TOTP) for local users.
- Roles (viewer, operator, admin) and access to single services.
- An audit log of each change and login, with an export.
- TLS with a self-signed certificate or your own certificate.
LiveSync
- Continuous replication with PostgreSQL logical replication, between managed services or with an external database. See supported connections.
- Table selection for a managed source, and creation of the missing tables on the target.
Installation and licensing
- One installer for one Linux host with Docker, and signed releases.
- An air-gapped install and air-gapped licenses.
- A demo mode on one computer.
- A license for each database service, and a 7-day trial.
- The HTTP API, with an interactive playground.