PostgreSQL

PostgreSQL Database Service

This feature is currently in beta.

While we strive to provide a stable service, we may introduce changes to the service that are not backwards compatible. We will do our best to notify you of any changes that may affect you.

During the beta period, documentation may be incomplete or outdated. Please let us know if you find any issues or have any feedback.

Interested in joining the beta program? Contact us

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