Launching the Platform/Self hosted/Prerequisites

PostgreSQL Database

Setup and configure PostgreSQL database for your self-hosted platform

Overview

Primary Database

User data and configurations
Platform state
Application data
Minimum version: PostgreSQL 13+

Key Features

High availability
Data persistence
Backup support
Performance monitoring

Deployment Options

Cloud Provider Options

Digital Ocean Managed Database

Create new database cluster
Choose PostgreSQL 13+
Select plan (minimum 2 vCPU, 4GB RAM)
Enable connection pooling (recommended: 50 connections)

Neon Serverless PostgreSQL

Create new project
Set up new database
Enable connection pooling
Note the connection string

Other Providers

Amazon RDS
Google Cloud SQL
Azure Database for PostgreSQL

Benefits

Automatic backups
High availability
Security patches
Performance monitoring

Requirements

Minimum Specifications

PostgreSQL 13 or higher
2 vCPU cores
4GB RAM
20GB storage

Recommended Features

Connection pooling
Automated backups
Point-in-time recovery
SSL/TLS encryption

Information Collection

Required Values for Platform Installation

postgresql:
  host: "your-db-host"
  port: 5432
  user: "platform"
  password: "your-secure-password"
  database: "platform"
  sslMode: "require" # or "disable" for local development

Validation

Test PostgreSQL connection

# Using psql client
psql "postgres://username:password@hostname:5432/dbname?sslmode=require"
 
# Or using connection string
 
psql "postgresql://username:password@hostname:5432/dbname?sslmode=require"

Troubleshooting

Connection Failures

Verify credentials
Check network/firewall rules
Confirm SSL/TLS settings
Validate connection string format

Performance Issues

Check connection pool settings
Monitor resource usage
Review query performance
Verify index usage

Need help? Contact [email protected] if you encounter any issues.

Previous

OAuth Provider

Next

Redis Cache