postgres_init.md

emergency

1. su root

2. su postgres

3. psql

4. CREATE ROLE myuser LOGIN password 'secret';

5. ALTER USER user_name WITH PASSWORD 'new_password';

6. sudo service postgresql restart

7. sudo apt-get update

8. sudo apt-get install postgresql postgresql-contrib

9. sudo -u postgres psql

10. create database mydb;

11. create user myuser with encrypted password 'mypass';

12. grant all privileges on database mydb to myuser;

13. SHOW hba_file; //change it to

14. sudo systemctl restart postgresql.service

Now open other shell

1. psql -h localhost -d mydb -U myuser -p 5432

Enter password