Skip to content

Latest commit

 

History

History
82 lines (39 loc) · 1.63 KB

README.md

File metadata and controls

82 lines (39 loc) · 1.63 KB
Raw

postgresql 9.5 script for centos 7.x64

For use on a clean CentOS 7.x64 box only!!

This script installs:

  • postgresql95

  • postgresql95-devel

  • postgresql95-server

  • postgresql95-libs

  • postgresql95-contrib

  • postgresql95-plperl

  • postgresql95-plpython

  • postgresql95-pltcl

  • postgresql94-python

  • postgresql95-odbc

  • postgresql95-jdbc

  • perl-DBD-Pg

  • pgbouncer

  • Webmin

  • IP Tables

The script also creates the following:

  • A minimally privilaged user (pgadmin - change to whatever you like)

  • Disables root log in

  • Sets root, postgres, admin, and ssl pass to 32 chars.

  • Configures Webmin for managing PostgreSQL

  • Installs a self-signed SSL

  • Updates pga_hba.conf to MD5 and SSL

  • Updates postgresql.conf for SSL.

  • You can change the SSH port as well as the user name to whatever you like. You can also add/remove packages.

  • Once completed, it will display the new passwords for pgadmin, root, postgres, and ssl as well as write them to an auth.txt file.

  • This script install IP tables. If you want to use firwalld, comment the appropriate lines as noted.

Usage:

  1. Download the script to a clean CentOS 7.x64 box wget https://github.com/DavidGhedini/postgresql-9.5-script-centos-7x64/blob/master/pgsql-9.5-centos-7x-64.sh
  2. Make it executable chmod 755 pgsql-9.5-centos-7x-64.sh
  3. Execute it ./pgsql-9.5-centos-7x-64.sh

Example Output at End of Script:

Passwords saved in /root/auth.txt

pg pass: DqVnavTlCXcSKfHprgUtjF-20rpfsKui

ssl pass: yxaQJCXgudTw19XEOMPdZzNd5n6rwVOG

pgadmin pass: A0RUHtPfSFC82mHeDP_ixrRavk7itgkE

root pass: RvZDHkZv-AeQS-ce0Mcnif7GxmmJ-zxN