PostgreSQL Hacks
- Administration hacks
- Backup and Restore Hacks
- Data Type Hacks
- psql hacks
- Replication hacks
- SQL Hacks
- Statistics, Planning and Execution Hacks
OID-related hacks
Obtain the current replication lag
Detect if backend is primary or standby
Get current WAL filename
List PostgreSQL configuration items which require a server restart