Install Postgress 12:
sudo apt update && sudo apt upgrade
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee /etc/apt/sources.list.d/pgdg.list
sudo apt update
sudo apt -y install postgresql-12 postgresql-client-12
systemctl status postgresql.service
systemctl enable postgresql.service
psql --host=127.0.0.1 --username=postgres
Setting:
nano /etc/postgresql/12/main/postgresql.conf
nano /etc/postgresql/12/main/pg_hba.conf
IPTABLES:
iptables -A INPUT -s $myhost -p tcp -m tcp --dport 22 -j ACCEPT
iptables -A INPUT -p tcp -m tcp --dport 22 -j DROP
iptables -A INPUT -s $myhost -p tcp -m tcp --dport 5432 -j ACCEPT
iptables -A INPUT -p tcp -m tcp --dport 5432 -j DROP
Replication:
https://www.cherryservers.com/blog/how-to-set-up-postgresql-database-replication