[Referans]PostgreSQL
CheatSheets
Quick CLI, syntax reference cards & downloadable PDF posters
Filter by Category:
Other Engines:
4 / 4 Published Asset(s)Production-Grade Verified
PostgreSQL 16 / 17CLI & Administration
10 dk okuma
psql CLI Quick Reference
Connection parameters, meta commands (\d, \l, \du), .psqlrc template, COPY streaming, and real-time lock/activity triage queries.
Connection Strings & URI Syntax
Complete Meta Commands (\dt+, \dn+, \du)
Output & Formatting Options
PostgreSQL 15 / 16 / 17Security & Hardening
12 dk okuma
PostgreSQL Security Hardening
pg_hba.conf hardening rules, SCRAM-SHA-256 password policies, SSL/TLS verify-full, pgaudit audit trails, public schema lockdown, and single-query security check scripts.
SCRAM-SHA-256 & Secure pg_hba.conf
Least Privilege & public Schema Lockdown
TLS/SSL verify-full Configuration
PostgreSQL 14–17Backup & Recovery
11 dk okuma
PostgreSQL Backup & Recovery
Logical backups with pg_dump/pg_dumpall, physical backups with pg_basebackup and pgBackRest, WAL archiving, and Point-in-Time Recovery (PITR) quick reference.
pg_dump & pg_dumpall Optimal Flags
WAL Archiving & Non-Blocking Physical Backups
Point-in-Time Recovery (PITR) Walkthrough
PostgreSQL 14–17Index & Query
13 dk okuma
PostgreSQL Indexing & Query Optimization
B-Tree, BRIN, GIN, GiST index selection, EXPLAIN (ANALYZE, BUFFERS) node analysis, slow query triage via pg_stat_statements, and index bloat remediation.
B-Tree, GIN, GiST & BRIN Index Selection Guide
EXPLAIN (ANALYZE, BUFFERS) Execution Plan Reading
Index Skip Scan, Partial & Expression Indexes