Add Instructions on opening port 5432 on ubuntu

[cmatKhan]

get into sudo vim /etc/postgresql/12/main/postgresql.conf

Uncomment, and change the value to '*', this will allow Postgres connections from anyone.

listen_addresses = '*'

Save and exit the file. Next, modify pg_hba.conf to also allow connections from everyone. Open the file with your preferred editor:

sudo vim /etc/postgresql/12/main/pg_hba.conf  

Modify this section:

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5

To this:

# IPv4 local connections:
host    all             all             0.0.0.0/0            md5

https://www.digitalocean.com/community/questions/remote-access-to-postgresql-with-pgadmin

open the firewall

sudo ufw allow 5432/tcp

https://stackoverflow.com/a/51597485/9708266

[cmatKhan]

read up on security re: opening connections to anyone -- is there a best practice other than 0.0.0.0/0?

[cmatKhan]

don't modify -- just add the IPv4 line

also add the IPv6 protocol

[cmatKhan]

add this in instructions:

╭─ ~ ─────────────────────────────── database_admin@ip-172-31-37-99 13:02:36 ─╮
╰─❯ sudo service postgresql restart ─╯

╭─ ~ ─────────────────────────────── database_admin@ip-172-31-37-99 13:03:31 ─╮
╰─❯ sudo systemctl restart nginx