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
- Automated Management: Patches, backups, and monitoring
- Enterprise Features: Advanced PostgreSQL features and extensions
- Performance Optimization: Tuned for production workloads
- Security: Encryption, access control, and compliance features
Supported PostgreSQL Versions
We support the latest stable PostgreSQL versions:
Currently Supported Versions
PostgreSQL 17.5 (Latest)
- Latest features and performance improvements
- Recommended for new deployments
- Full support for all PostgreSQL 17 features
PostgreSQL 16.9 (LTS)
- Long-term support version
- Stable and well-tested
- Recommended for production workloads
PostgreSQL 15.13 (LTS)
- Long-term support version
- Mature and stable
- Suitable for legacy applications
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
- Major version upgrades: Manual major version upgrades with migration support
PostgreSQL Features
Core PostgreSQL Features
Our PostgreSQL service includes all standard PostgreSQL features:
Data Types
- Numeric: Integer, decimal, floating-point, serial
- Character: Text, varchar, char with collation support
- Binary: Bytea for binary data storage
- Date/Time: Timestamp, date, time, interval
- Boolean: True/false values
- JSON: Native JSON and JSONB support
- Array: Multi-dimensional arrays
- Geometric: Points, lines, polygons
- Network: IP addresses, MAC addresses
- UUID: Universally unique identifiers
Advanced Features
- ACID Compliance: Full ACID transaction support
- MVCC: Multi-version concurrency control
- Foreign Keys: Referential integrity constraints
- Triggers: Database triggers for automation
- Stored Procedures: PL/pgSQL and other procedural languages
- Views: Materialized and regular views
- Indexes: B-tree, hash, GiST, SP-GiST, GIN, BRIN indexes
- Partitioning: Table partitioning for large datasets