PostgreSQL Database Service
Thalassa Cloud’s PostgreSQL Database as a Service (DBaaS) provides fully managed PostgreSQL clusters with high availability, automatic backups, and enterprise-grade features. Our PostgreSQL service is designed to handle the most demanding production workloads while providing the flexibility and power of PostgreSQL.
PostgreSQL Overview
PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development. Our managed PostgreSQL service includes:
- High availability — Multi-AZ deployment with automatic failover; see High availability
- Automated management — Patches, backups, and monitoring; see Storage and backups
- Performance — Tuned for production workloads; see Instance types and Parameters
- Security — Encryption, access control, and compliance features
Supported PostgreSQL Versions
We support the latest stable PostgreSQL versions:
Currently Supported Versions
- PostgreSQL 18.1 (Latest)
- PostgreSQL 17.6
- PostgreSQL 16.10
Version Support Policy
- Latest 3 major versions — We support the latest 3 major PostgreSQL versions
- Latest minor releases — Each supported major version includes the latest minor release
- Automatic minor updates — Opt into automatic minor version updates
Core PostgreSQL Features
Our PostgreSQL service includes all standard PostgreSQL features:
Data Types
Numeric, character, binary (bytea), date/time, boolean, JSON/JSONB, arrays, geometric, network (IP, MAC), UUID.
Advanced Features
- ACID compliance, MVCC, foreign keys, triggers, stored procedures (PL/pgSQL), views (regular and materialized), indexes (B-tree, hash, GiST, SP-GiST, GIN, BRIN), partitioning.
Pre-loaded Extensions
The following extensions are available and autoloaded on every cluster:
- auto_explain — Automatically log execution plans for slow queries
- pg_stat_statements — Track query execution statistics
- pgaudit — SQL audit logging for compliance
- pg_failover_slots — Replication slot management for failover (CloudNativePG)
For more extensions and how to enable them, see Extensions.
Documentation
| Topic | Description |
|---|---|
| Extensions | Discover, enable, and manage PostgreSQL extensions (including TimescaleDB, PostGIS, pgvector) |
| Instance types | Choose instance size and view default parameters per type |
| Parameters | Configure allowed PostgreSQL parameters |
| Storage | Block storage and Barman backups |
| High availability | Replicas, failover, and AZ spread |
Featured extension guides:
- TimescaleDB — Time-series (Apache-2 edition only)
- PostGIS — Spatial types and functions
- pgvector — Vector similarity search