Presented by:

F18fdec1018a3dff032d70c085e2639a

Keith Fiske

OmniTI

Database Administrator with OmniTI for 5+ years & 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

Date:
2017 March 31 09:00
Duration:
50 min
Room:
Liberty III
Conference:
PGConf US 2017
Language:
Track:
Operations
Difficulty:
Medium