Skip to main content

​
PostgreSQL

Deploy fully managed PostgreSQL databases with automated backups, high availability, and scaling capabilities.

​
What is PostgreSQL?

PostgreSQL is a powerful, open-source relational database management system. Antryk offers fully managed PostgreSQL with zero administration overhead.

​
Key Features

  • PostgreSQL 14 & 15: Latest stable versions
  • Automated Backups: Daily backups with 7-day retention
  • Point-in-Time Recovery: Restore to any moment in time
  • High Availability: Multi-zone replication
  • Connection Pooling: Built-in PgBouncer support
  • Read Replicas: Scale read queries across replicas
  • Monitoring: Performance insights and query analytics
  • Extensions: Support for popular PostgreSQL extensions

​
Use Cases

  • Web applications and APIs
  • Financial applications requiring ACID compliance
  • Analytics and reporting
  • Content management systems
  • E-commerce platforms
  • SaaS applications

​
Getting Started

  1. Create a PostgreSQL database from your dashboard
  2. Choose plan (Dev, Starter, or Production)
  3. Configure region and database name
  4. Get connection string and credentials
  5. Connect your application

​
Connection Examples

​
Node.js

const { Pool } = require('pg');

const pool = new Pool({
  connectionString: process.env.DATABASE_URL,
  ssl: { rejectUnauthorized: false }
});

const client = await pool.connect();

​
Python

import psycopg2

conn = psycopg2.connect(
    os.environ['DATABASE_URL'],
    sslmode='require'
)

​
PHP

$db = pg_connect(getenv('DATABASE_URL'));

​
Plans

  • Dev: Development and testing (single zone)
  • Starter: Small production workloads
  • Production: High availability with multi-zone replication

​
Scaling

  • Vertical Scaling: Increase CPU and memory
  • Horizontal Scaling: Add read replicas
  • Storage: Automatic storage scaling
  • Connection Limits: Configurable max connections

​
Security

  • SSL/TLS: Encrypted connections required
  • VPC Integration: Private network connectivity
  • IP Whitelisting: Restrict access by IP
  • Authentication: Username/password auth

​
Backups

  • Automatic Backups: Daily at scheduled time
  • Manual Backups: On-demand backups
  • Point-in-Time Recovery: Restore to specific timestamp
  • Backup Retention: 7-day retention (extendable)

​
Monitoring

Track database performance with:
  • Query Performance: Slow query identification
  • Connection Metrics: Active connections, idle connections
  • Storage: Disk usage and growth trends
  • CPU & Memory: Resource utilization

Create PostgreSQL Database

Get started with PostgreSQL