Connect to postgres database from computer different from the computer that hosts the database

[zipperer]

Execute commands from postgres_script.txt

= Connect to database from a computer different from the computer that hosts the database =

open /etc/postgresql/14/main/postgresql.conf
find listen_addresses. remove # at beginning of line. replace 'localhost' with '*'.
save and exit.

open /etc/postgresql/14/main/pg_hba.conf.
at bottom of file, add new line:
hostssl all             all             0.0.0.0/0               scram-sha-256
save and exit.

$ service postgresql restart