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
• 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.6 (Latest)

  • Latest features and performance improvements
  • Recommended for new deployments
  • Full support for all PostgreSQL 17 features

• PostgreSQL 16.10 (LTS)

  • Long-term support version
  • Stable and well-tested
  • Recommended for production workloads

• PostgreSQL 15.14 (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

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