Abasthan
DocsPostgreSQL

PostgreSQL

Fully managed PostgreSQL databases with automatic provisioning, daily backups, and high-performance NVMe storage.

Database Instances

Abasthan provisions PostgreSQL instances in isolated containers within our private network. Every database comes with:

  • NVMe SSD Storage: For lightning-fast I/O operations.
  • Automatic Backups: Daily snapshots stored securely.
  • Extensions: Popular extensions like PostGIS, pg_stat_statements, and uuid-ossp pre-installed.

Connecting Your App

For apps running on Abasthan, the best way to connect is via Environment Variables. When you link a PostgreSQL service to your app, Abasthan automatically injects:

POSTGRES_HOST=db-abasthan-prod
POSTGRES_PORT=5432
POSTGRES_USER=abasthan_user
POSTGRES_PASSWORD=your_secure_password
POSTGRES_DB=app_db
DATABASE_URL=postgres://user:pass@host:port/db

Best Practices

  • Indexes: Ensure your frequently queried columns are indexed to maintain high performance as your data grows.
  • Read-Only Access: For analytical queries, consider creating a read-only user to prevent accidental data modification.
  • Monitoring: Use the Insights tab in your dashboard to monitor query performance and identify slow-running queries.

Maintenance & Updates

We perform regular maintenance and security updates during your specified maintenance window. Your database will experience a few seconds of downtime as it restarts with the new updates.

← Static SitesMariaDB →