PostgreSQL 18 · Bilingual · Community maintained
Start with what you need to accomplish.
Search for a term, error, or goal, then open the explanation, procedure, and verification steps. You do not need a chapter number.
Search PostgreSQL documentation
Uses the same Fumadocs search index as the navbar.
Choose your current task
Enter the docs by outcome
Install PostgreSQLLinux, macOS, Windows, Docker, and psqlDebug a connectionStart with the original error, SQLSTATE, and connection pathOptimize a slow queryEXPLAIN, statistics, scan methods, and indexesDesign backup and recoveryWAL, PITR, RPO/RTO, and restore rehearsalsChoose cloud PostgresManaged services, free tiers, ownership, and portabilityUpgrade PostgreSQL 18 to 19Release status, compatibility, rehearsal, and rollbackBuild AI on PostgreSQLpgvector, RAG, safe SQL, and agent evaluationsModel application dataConstraints, relations, transactions, and evolvable schemas
Diagnostic principle
Preserve the original error and SQLSTATE. Identify connection, permission, lock, resource, or query-plan failure before changing configuration.