Holy Easy PostgreSQL deployment!
In case you missed it, the BigSQL team released an awesome package manager for installing and configuring PostgreSQL and many related, useful components. The package manager can be found here: https://www.bigsql.org/package-manager.jsp.
Playfully named pgc, for ‘pretty good command line’, pgc is a utility similar to yum or apt-get that allows you to install, configure, update and manage Postgres related components including foreign data wrappers, stored procedure languages, connectors, devops tools, HA tools and monitoring tools. Common uses:
- Provision Postgres (9.2 through 9.6, including multiple versions on same server)
- Installing pgBouncer, Backrest, and other community projects
- Scripting configurations in chef or other devops tools
PGC runs on Linux, Windows and OS X and supports the same exact cli so it is an ideal provisioning/management tool for multi OS environments.
PGC not only allows you to get and install these components but you can use pgc to update each component as new updates become available. Read more