Managing OS Provided PostgreSQL Packages
Senior Database Engineer with 7+ years of PostgreSQL experience & author of several popular third-party PostgreSQL tools (pg_partman, pg_extractor, mimeo, pg_doc_store).
Compiling PostgreSQL from source is a relatively easy thing to do compared to most open source projects. But for production systems, using the packages the operating systems provide is generally the recommended way to go. The problem is none of them end up managing PostgreSQL quite the same, let alone anything like the original source compile. This talk will cover how some of the major Unix-based operating systems manage their provided PostgreSQL packages: - Debian, CentOS, FreeBSD - Package naming conventions - Repositories - Installation - Default binary file & data locations - Services (start/stop/reload) - Running multiple, simultaneous clusters
- 50 min
- PGConf US 2017