PieHost

PieGres

PieGres is a managed PostgreSQL service by PieHost. Get a production-ready PostgreSQL cluster in seconds: no server setup, no patching, no ops overhead.

Getting Started

Create a Cluster

  1. Go to Dashboard → Click Launch → PieGres
  2. Enter a name (alphanumeric characters)
  3. Choose a plan size
  4. Click Create PieGres Cluster

Your cluster is live within seconds. Connection credentials are available immediately in the dashboard.

Connecting

Every cluster gets a unique host and auto-generated credentials. Find them under your cluster dashboard.

Setting Value
Host {your-cluster}.gres.pie.host
Port 5432
Username admin
Password randomly generated, 16 characters
Database postgres
SSL Mode require

Connection string:

postgresql://admin:YOUR_PASSWORD@your-cluster.gres.pie.host:5432/postgres?sslmode=require

psql

psql "postgresql://admin:YOUR_PASSWORD@your-cluster.gres.pie.host:5432/postgres?sslmode=require"

Node.js (pg)

import { Pool } from 'pg'

const pool = new Pool({
  connectionString: 'postgresql://admin:YOUR_PASSWORD@your-cluster.gres.pie.host:5432/postgres?sslmode=require'
})

Python (psycopg3)

import psycopg

conn = psycopg.connect(
    'postgresql://admin:YOUR_PASSWORD@your-cluster.gres.pie.host:5432/postgres?sslmode=require'
)

Go (pgx)

conn, err := pgx.Connect(ctx,
    "postgresql://admin:YOUR_PASSWORD@your-cluster.gres.pie.host:5432/postgres?sslmode=require",
)

PHP (PDO)

$pdo = new PDO(
    'pgsql:host=your-cluster.gres.pie.host;port=5432;dbname=postgres;sslmode=require',
    'admin',
    'YOUR_PASSWORD'
);

Other Compatible Clients

PieGres works with any PostgreSQL-compatible client or driver: Ruby (pg), Java (pgjdbc), Rust (sqlx, tokio-postgres), Prisma, SQLAlchemy, Laravel, Django, and more.

Dashboard

From the cluster dashboard you can:

  • View real-time stats: PostgreSQL version, active connections, database count, table count, and storage used (updates every 10 seconds)
  • Copy connection credentials and connection string with one click
  • Rename the cluster
  • Enable or disable auto-scaling (paid plans)
  • Resize to a different plan
  • Delete the cluster

Plans

Plans differ by RAM, CPU, and bandwidth allocation. All plans include SSL encryption, automated backups, real-time monitoring, and full PostgreSQL 16 compatibility.

Auto-scaling: Available on paid plans — compute, storage, and bandwidth scale automatically on demand. Not available on the free plan.

Resizing: Upgrade or downgrade at any time from the dashboard with no data loss. The hourly rate updates immediately.

Billing is hourly, for more details, see pricing page.

Security

  • All connections use SSL encryption (sslmode=require)
  • Each cluster has a unique host and password — credentials are not shared between clusters
  • No public or unauthenticated access is permitted

Deleting PieGres

Go to PieGres Dashboard → Delete. You will be asked to confirm by typing the cluster name. Deletion is permanent, all data will be lost and cannot be recovered.

Support

Open a support ticket from your dashboard or visit piehost.com/contact.