With psql

# Connect as application user
psql -h <VM_IP> -p 30432 -U <USERNAME> -d <DATABASE>

# Connect as postgres (superuser)
psql -h <VM_IP> -p 30432 -U postgres

‍

Connection string for applications

postgresql://<USERNAME>:<PASSWORD>@<VM_IP>:30432/<DATABASE>

‍

Examples by language

# Python (psycopg2)
import psycopg2
conn = psycopg2.connect( 
host="<VM_IP>", port=30432, 
user="<USER>", password="<PASSWORD>", dbname="<DATABASE>"
)

// Node.js (pg)
const client = new Client({ 
host: "<VM_IP>", port: 30432, 
user: "<USER>", password: "<PASSWORD>", database: "<DATABASE>"
});

#Python (SQLAlchemy)
engine = create_engine("postgresql://<USER>:<PASSWORD>@<VM_IP>:30432/<DATABASE>")

# View the PostgreSQL pod
`kubectl get pods -A | grep postgresql`

# View the installation log
`tail -f /var/log/cuemby/bootstrap.log`

# Verify that the port is listening
`ss -tlnp | grep 30432`

‍

Expected output

NAME                          READY   STATUS    RESTARTS
postgresql-xxxxxxxxx-xxxxx    1/1     Running   0        ← Running ✓

Credentials and database

‍

Performance tuning

‍

💡 For a VM with 4 GB of RAM, a balanced configuration would be: SHARED_BUFFERS=1GB, WORK_MEM=16MB, MAX_CONNECTIONS=100.

‍

-- List databases
\l

-- Connect to the application database
\c app

-- Create a table
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(150) UNIQUE NOT NULL,
created_in TIMESTAMPTZ DEFAULT NOW()
);

-- Insert a record
INSERT INTO users (name, email) VALUES ('Martin', 'martin@cuemby.com');

-- Query
SELECT * FROM users;

-- View existing tables
\dt