PGCon2016 - 20180510

PGCon 2016
The PostgreSQL Conference

Speakers
Keith Fiske
Schedule
Day Talks - Day 2 - 2016-05-20
Room DMS 1120
Start time 16:00
Duration 00:45
Info
ID 905
Event type Lecture
Track DBA
Language used for presentation English

Managing OS Provided PostgreSQL Packages

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

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