PostgreSQL
The World's Most Advanced Open Source Relational Database
What is PostgreSQL?
PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development. It has a strong reputation for reliability, feature robustness, and performance.
Key Features
- ACID compliance for reliable transactions
- Support for JSON and JSONB data types
- Full-text search capabilities
- Extensible with custom functions and data types
- Advanced indexing (B-tree, Hash, GiST, GIN)
- Replication and high availability support
- Row-level security policies
Deployment on Moltern
PostgreSQL can be deployed on Moltern with a single click. Moltern handles:
- Automatic SSL/TLS certificates via Let's Encrypt
- Persistent storage for your data
- Environment configuration through the dashboard
- Container orchestration with automatic restarts
Getting Started
- Navigate to the Services page in Moltern
- Search for "PostgreSQL"
- Click Deploy and configure your settings
- Access your instance via the provided URL
Configuration
Environment Variables
Configure the following environment variables in your Moltern dashboard:
| Variable | Description | Default |
|---|---|---|
| Check service settings | Configure via dashboard | - |
Backup
Moltern provides automatic backup options. Configure backup schedules in the service settings.