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 · Incident Response & Troubleshooting

Fix PostgreSQL relation does not exist: database, schema and search_path

Trace PostgreSQL SQLSTATE 42P01 from the failing application connection to the exact database, schema and identifier. Distinguish missing migrations from name-resolution and privilege problems, then prove a narrow correction without creating a guessed table or exposing application data.
Save to collectionCreate a collection in the sidebar first.
caution40 minintermediate7 stepsPostgreSQL

Databases & Data · Identity & Access · Incident Response & Troubleshooting

Fix PostgreSQL permission denied for schema public or table

Diagnose and repair PostgreSQL permission errors without granting broad roles or changing object ownership. This guide separates database connection, schema USAGE and CREATE, table privileges, sequence access, role inheritance, default privileges, and row-level security so an application receives only the rights it actually needs.
Save to collectionCreate a collection in the sidebar first.
caution45 minintermediate10 stepsPostgreSQL