Documentation Index
Fetch the complete documentation index at: https://docs.instapods.com/llms.txt
Use this file to discover all available pages before exploring further.
PostgreSQL 14 is available as an on-demand service for your pods.
Install
instapods services add my-app -s postgresql -w
Go to your pod’s Services tab and click Install next to PostgreSQL.
Installation takes approximately 8–15 seconds.
Credentials
instapods services creds my-app -s postgresql
| Field | Value |
|---|
| Host | localhost |
| Port | 5432 |
| Username | instapod |
| Password | (auto-generated) |
| Database | instapod |
Connecting from Your Application
Python (psycopg2)
import psycopg2
conn = psycopg2.connect(
host='localhost',
port=5432,
user='instapod',
password='YOUR_PASSWORD',
dbname='instapod'
)
Python (SQLAlchemy)
from sqlalchemy import create_engine
engine = create_engine('postgresql://instapod:YOUR_PASSWORD@localhost:5432/instapod')
Node.js
const { Pool } = require('pg');
const pool = new Pool({
host: 'localhost',
port: 5432,
user: 'instapod',
password: 'YOUR_PASSWORD',
database: 'instapod'
});
PHP (PDO)
$pdo = new PDO(
'pgsql:host=localhost;port=5432;dbname=instapod',
'instapod',
'YOUR_PASSWORD'
);
Command Line Access
SSH into your pod and use psql:
instapods ssh my-app
psql -U instapod -d instapod
Configuration
PostgreSQL runs with development-friendly defaults:
- Listens on
localhost:5432 only
- Default encoding: UTF-8
- Peer authentication for local socket, password for TCP