Скачать или смотреть How to Access Postgresql with pgAdmin using EC2 Instance AWS Linux

How to Access Postgresql using EC2 Instance AWS Linux

sudo dnf update
sudo dnf install postgresql15.x86_64 postgresql15-server
sudo postgresql-setup --initdb
sudo systemctl start postgresql
sudo systemctl enable postgresql
sudo systemctl status postgresql

sudo passwd postgres
su - postgres
psql -c "ALTER USER postgres WITH PASSWORD 'your-password';"
exit

cp /var/lib/pgsql/data/postgresql.conf /var/lib/pgsql/data/postgresql.conf.bak
sudo nano /var/lib/pgsql/data/postgresql.conf (listen_addresses = '*')


sudo nano /var/lib/pgsql/data/pg_hba.conf

host all all 0.0.0.0/0 md5
host all all ::/0 md5

sudo systemctl restart postgresql