
- Home
- Books
- Data Engineering & Databases
- SQL & Relational Databases
- PostgreSQL 16 Administration Cookbook
SQL & Relational DatabasesIn Stock
PostgreSQL 16 Administration Cookbook
Solve Real-world Database Administration Challenges with 180+ Practical Recipes and Best Practices
Price৳ 650
PostgreSQL 16 Administration Cookbook by Gianni Ciolli provides practical recipes for managing, tuning, and securing production PostgreSQL servers. It offers step-by-step solutions to operational database challenges, routine maintenance, and high-availability setups. Readers learn to diagnose query bottlenecks, implement physical backups, and manage replication using PostgreSQL 16 features.
What you will learn
- Configure server parameters, connection pools, and memory settings for production workloads
- Implement automated backup, point-in-time recovery, and disaster recovery strategies with pg_dump and WAL archiving
- Monitor server health, lock contention, and query performance with system catalogs and pg_stat_statements
- Set up physical and logical replication for read scaling and zero-downtime version upgrades
- Execute routine database maintenance, table vacuuming, and index reorganization
- Harden database security with TLS encryption, role permissions, and connection authentication
Who this is for
Database administrators, DevOps engineers, and backend developers managing PostgreSQL database instances. Basic familiarity with SQL syntax and Linux command-line operations is assumed. Advanced PostgreSQL administration experience is not required.


