Skip to main content
Rivestack runs PostgreSQL 17, the latest stable release.
Yes. pgvector is pre-installed on every Rivestack database (both Free and HA tiers). Enable it with CREATE EXTENSION IF NOT EXISTS vector;.
HA clusters support 25+ PostgreSQL extensions including:
  • pgvector — Vector similarity search
  • PostGIS — Geospatial data
  • TimescaleDB — Time-series data
  • pg_stat_statements — Query performance tracking
  • pgcrypto — Cryptographic functions
  • pg_trgm — Trigram text search
  • uuid-ossp — UUID generation
You can install extensions from the Management tab in the dashboard.
Yes. All connections require SSL/TLS (sslmode=require). Unencrypted connections are rejected. No CA certificate download is needed.
On HA clusters with 2 or more nodes, failover is automatic. Patroni detects the failure and promotes a replica to primary within 10-30 seconds. HAProxy reroutes connections to the new primary. Your connection string does not change.Single-node clusters do not have automatic failover. We recommend at least 2 nodes for production.
HA clusters include automated daily backups via pgBackRest, stored in S3-compatible object storage. Backups are retained for 14 days. You can also trigger manual backups and restore to any point in time within the retention window. See the Backups & Restore guide for details.
Yes. Rivestack supports point-in-time recovery (PITR) on HA clusters. Continuous WAL archiving lets you restore to any second within your backup retention window. Initiate a restore from the Backup tab in the dashboard.
  • EU Central — Falkenstein, Germany
  • US East — Virginia, USA
  • Asia — Singapore
All plans and features are available in all regions at the same pricing.
Yes. You can add or remove nodes (between 1 and 3) from the Management tab. Adding a node provisions a new replica that joins your cluster automatically. See the Scaling guide.Vertical scaling (changing server type) is not yet supported. To upgrade, create a new cluster with the desired server type and migrate your data.
  • Free tier: 5 connections per database
  • HA clusters: 100 connections per cluster
Use connection pooling in your application if you need more concurrent connections.
HA clusters are billed monthly per node. Payment is processed via credit card through our payment provider. Scaling changes (adding/removing nodes) are prorated within your billing cycle. You can cancel anytime from the Billing page.
Yes. Cancel anytime from the Billing page in the dashboard. Your cluster remains active until the end of the current billing period.
Your data is stored on dedicated servers in the region you selected (EU, US, or Asia). Backups are stored in S3-compatible object storage in the same region. Data is encrypted at rest and in transit.
Yes. HA clusters with 2 or more nodes include read replicas. Connect to port 5001 for read-only queries distributed across replicas. See the Connection Guide for details.
There is no free trial for HA clusters, but the Free tier lets you explore Rivestack at no cost with a shared PostgreSQL database (4 GB storage, 5 connections).
The dashboard provides real-time metrics including TPS, connections, CPU, memory, disk I/O, cache hit ratio, and replication lag. View historical data over 1 hour, 24 hours, or 7 days. See the Monitoring guide.