Skip to content

Make new user -- non-admin user #17

@zipperer

Description

@zipperer

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

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions