OneLinersCommand workbench
Guides
Operational guides

Complete procedures with a way back.

Searchable, versioned procedures with prerequisites, verification, concrete output, and rollback.

Guides
243
Favorites
0
243 launch guides · 2601 reviewed steps
2 of 243 guides

Databases & Data · AI/ML · Security

Run production semantic search with PostgreSQL and pgvector

Pin PostgreSQL 18 and pgvector 0.8.5, enforce tenant RLS, store one validated vector dimension, ingest idempotently, measure HNSW and IVFFlat against exact recall, and prove maintenance, PITR, restore and rollback.
Save to collectionCreate a collection in the sidebar first.
caution420 minadvanced10 stepsPostgreSQL

Databases & Data · Backup & Recovery

Recover PostgreSQL to a point in time with WAL archiving

Build a fail-closed PostgreSQL 18.4 WAL archive and verified base-backup chain, then restore to an exact target in isolation, validate while paused, promote, and re-establish protection.
Save to collectionCreate a collection in the sidebar first.
danger420 minadvanced17 stepsPostgreSQL