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

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

Information Collection

Required Values for Platform Installation

  • Database hostname
  • Port number (default: 5432)
  • Database name
  • Username
  • Password
  • SSL mode (e.g., require)
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.