Thinkful ubuntu postgresql notes

gistfile1.txt

---

Log into psql using peer-authentication

  sudo -u postgres psql

---

Set the default password for the postgres user

1. Switch to postgres user, open postgres database

  sudo -u postgres psql postgres

2. Set the password for the postgres user (you will be prompted to enter the password)

  \password postgres

3. Quit psql

  \q

Now you should be able to log in with a password via DBeaver

---