search

zipperer / migrate_database_with_michael

0 stars 0 forks source link

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

Open zipperer opened 7 months ago

zipperer commented 7 months ago

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