Quick setup and configure postgres9.x on Ubuntu (development)

setup-postgres.sh

# How to run?
# sudo bash ./setup-postgres.sh

# Install
apt install -y postgresql;

# Set default password "postgres" for postgres user
sudo -u postgres psql -c "ALTER USER postgres WITH PASSWORD 'postgres';";

# Allow all type of connection with md5 authentication
mv -vn /etc/postgresql/10/main/pg_hba.conf /etc/postgresql/10/main/pg_hba.conf.bk
echo "local all postgres md5" > /etc/postgresql/10/main/pg_hba.conf;
echo "host all all 127.0.0.1/32 md5" >> "/etc/postgresql/10/main/pg_hba.conf" ;
systemctl restart postgresql;

# Check connection
PGPASSWORD="postgres" psql -h localhost -U postgres -c 'select 1';

echo "Done!";