Deploy PostgreSQL on CentOS 7.4

deploy_postgresql.sh

#!/bin/bash

echo "Deploy Postgresql on CentOS 7.4";

sudo yum -y install postgresql-server postgresql-contrib

sudo postgresql-setup initdb

sudo cp /var/lib/pgsql/data/pg_hba.conf /var/lib/pgsql/data/pg_hba.conf.save

# SED

sudo sed '/ident/ s/ident/md5/g' /var/lib/pgsql/data/pg_hba.conf > /var/lib/pgsql/data/pg_hba.conf

sudo systemctl start postgresql
sudo systemctl enable postgresql
sudo systemctl status postgresql

firewall-cmd --add-service=postgresql

firewall-cmd --add-service=postgresql --permanent


### REVISAR LOGS
# tail -f /var/lib/pgsql/data/pg_log/postgresql-*

# Crear DB
# createdb --encoding=UTF8 --owner=db_user_name db_name

# Crear Usuario
# createdb db_user_name --owner=db_name

sudo -i -u postgres
echo "Ingresando a la consola de PSQL -> Puedes salir con : \q";
psql

# Cargar DUMP
# psql -U user_db -W -h localhost name_db < archivo.dump

● postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
Active: active (running) since Wed 2018-12-19 18:54:56 UTC; 14s ago
Main PID: 18927 (postgres)
CGroup: /system.slice/postgresql.service
├─18927 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432
├─18928 postgres: logger process
├─18930 postgres: checkpointer process
├─18931 postgres: writer process
├─18932 postgres: wal writer process
├─18933 postgres: autovacuum launcher process
└─18934 postgres: stats collector process

Dec 19 18:54:55 qportalapp01.novalocal systemd[1]: Starting PostgreSQL database server...
Dec 19 18:54:56 qportalapp01.novalocal systemd[1]: Started PostgreSQL database server.