search

zipperer / migrate_database_with_michael

0 stars 0 forks source link

Make password for admin user #9

Closed zipperer closed 7 months ago

zipperer commented 7 months ago

Execute commands from postgres_script.txt

= use psql to issue commands to postgres instance: =
==  make password for admin user ==

psql> ALTER USER postgres WITH ENCRYPTED PASSWORD 'example';
psql> \q
open /etc/postgresql/NUMBER/main/pg_hba.conf
replace 'trust' with 'scram-sha-256'. save and exit.
$ service postgresql restart
$ psql --username postgres --dbname postgres # provide password
zipperer commented 7 months ago

We did 

psql> ALTER USER postgres WITH ENCRYPTED PASSWORD 'example';

during #3 .