What's the difference between Hobby, Solo, and HA?
What's the difference between Hobby, Solo, and HA?
- Hobby ($9/mo): shared Postgres for development and testing, available in EU Central (
eu-central) only. One database per Hobby subscription. Up to 20 connections, direct to Postgres on port5432withsslmode=require. No PgBouncer or pooler. 5 GB soft quota, with an email warning at 80%. At 100%, connections are stopped and existing sessions are closed until usage drops below 90%. No high availability or read replicas. Hobby databases get daily full backups plus continuous WAL archiving, kept 14 days. Restores are whole-cluster and done by Rivestack support. There is no self-service per-database restore and no point-in-time recovery for customers. A Hobby database is deleted only when its subscription is cancelled or the account is deleted. - Solo ($29/mo): your own single-tenant VM (1 vCPU · 2 GB RAM · 30 GB NVMe) with daily backups, point-in-time recovery, and monitoring. Single node, so no automatic failover, but never deleted. Ideal for small production apps.
- HA Cluster (from $49/node/mo): dedicated infrastructure with 1 to 3 nodes. Choose at least 2 nodes for automatic failover; applications must retry connections during a failover.
How do I upgrade from Hobby to Solo?
How do I upgrade from Hobby to Solo?
Open the Hobby database in your dashboard and click Upgrade. We provision your dedicated Solo VM and migrate your data across automatically (typically ~3 minutes). Your Hobby database stays online and untouched until you delete it, so you can verify everything first, then just point your app at the new host and credentials.
What PostgreSQL version does Rivestack use?
What PostgreSQL version does Rivestack use?
Rivestack supports PostgreSQL 16, 17, and 18. You choose your major version when creating a cluster.
What extensions are available?
What extensions are available?
Rivestack enables the following extensions by default on new databases:
- pgvector: Vector similarity search for AI/ML embeddings
- pgvectorscale (
vectorscale): StreamingDiskANN indexes and scalable vector search - uuid-ossp: UUID generation
- pg_stat_statements: SQL execution statistics tracking
- pgcrypto: Cryptographic functions
- pg_trgm: Trigram matching for similarity searches
Are connections encrypted?
Are connections encrypted?
Yes. All managed endpoints require TLS and use publicly trusted Let’s Encrypt certificates. Dedicated plans use
sslmode=verify-full so the client encrypts the connection and verifies the database hostname. Hobby connects directly to Postgres on port 5432 with sslmode=require. No custom CA download is needed.What happens if a node fails?
What happens if a node fails?
On HA clusters with 2 or more nodes, Patroni can promote a healthy replica and the load balancer keeps the same connection endpoint. Existing sessions disconnect, so applications must reconnect with bounded retries and backoff. Detection and promotion time depends on cluster and network conditions; Rivestack does not currently promise a fixed failover SLA. Because replication is asynchronous, a failure can also lose transactions that had not reached a replica.Single-node clusters do not have automatic failover. We recommend at least 2 nodes for production.
How do backups work?
How do backups work?
Solo and HA clusters include automated daily backups via pgBackRest, stored in S3-compatible object storage. Retention is 7 days on Solo and 14 days on HA clusters. You can also trigger manual backups and restore to any point in time within the retention window. Hobby databases get daily full backups plus continuous WAL archiving, kept 14 days. Restores are whole-cluster and done by Rivestack support. There is no self-service per-database restore and no point-in-time recovery for customers. See the Backups & Restore guide for details.
Can I restore to a specific point in time?
Can I restore to a specific point in time?
Yes, on Solo and 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. Hobby does not include point-in-time recovery.
What regions are available?
What regions are available?
- EU Central: Falkenstein, Germany
- US East: Virginia, USA
- Asia Pacific: Singapore (Solo plan only)
eu-central) only. Solo is available in all regions. The HA tiers (Starter/Growth/Scale) are available in EU Central and US East only, so Singapore offers the Solo plan only. Pricing is set per region, and EU Central is the cheapest. See Pricing.Can I scale my cluster?
Can I scale my cluster?
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.
What are the connection limits?
What are the connection limits?
- Hobby: up to 20 connections per database, direct to Postgres on port
5432withsslmode=require. No PgBouncer or pooler. - Solo: 500 pooled client connections, 20 transaction slots per database
- Starter: 2,000 pooled client connections, 25 transaction slots
- Growth: 5,000 pooled client connections, 30 transaction slots
- Scale: 10,000 pooled client connections, 40 transaction slots
How is billing handled?
How is billing handled?
Solo is a flat $29/month. HA clusters are billed monthly per node (from $49/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.
Can I cancel my subscription?
Can I cancel my subscription?
Yes. Cancel anytime from the Billing page in the dashboard. Your cluster remains active until the end of the current billing period.
Where is my data stored?
Where is my data stored?
Dedicated-plan data is stored on servers in the region you selected (EU, US, or Singapore), and backup traffic is sent to S3-compatible object storage over TLS. Database connections are encrypted in transit. Rivestack does not currently advertise application-level, customer-managed, or pgBackRest repository encryption at rest; contact us before relying on a specific at-rest encryption or compliance requirement.
Do you support read replicas?
Do you support read replicas?
Not as read-serving replicas yet. Hobby has no read replicas. HA clusters with 2 or more nodes run streaming-replication standbys for automatic failover. Dedicated connections go through port
6432, and the load balancer routes every query (reads included) to the primary. A separate read-only replica endpoint that lets you offload reads is on our roadmap.Is there a free trial for HA clusters?
Is there a free trial for HA clusters?
There is no free trial for HA clusters. Hobby is shared Postgres at $9/month in EU Central (
eu-central) only, with one database per subscription, up to 20 direct connections on port 5432 (sslmode=require), and a 5 GB soft quota.How do I monitor my database?
How do I monitor my database?
On Solo and HA clusters, the dashboard provides real-time metrics including TPS, connections, CPU, memory, disk I/O, cache hit ratio, and replication lag. You can view historical data over 1 hour, 24 hours, or 7 days. See the Monitoring guide.Hobby shows a point-in-time snapshot of database size and percent of quota, active connections, cache hit ratio, transactions, rows, and deadlocks. Hobby has no historical graphs, TPS or latency series, or alerts.