search

zipperer / migrate_database_with_michael

0 stars 0 forks source link

Make new user -- non-admin user #17

Open zipperer opened 7 months ago

zipperer commented 7 months ago

Follow steps from postgres_script.txt

$ psql --username postgres --dbname postgres # provide password

== make new user ==

psql> CREATE USER example_user;

== add password for user ==
psql> ALTER USER example_user WITH ENCRYPTED PASSWORD 'example1';
psql> ALTER USER example_user WITH CREATEDB;
psql> \q

open /etc/postgresql/NUMBER/main/pg_hba.conf.
replace 'peer' with 'scram-sha-256'. save and exit.

$ service postgresql restart
$ psql --username example_user --dbname postgres