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