Skip to content

Instantly share code, notes, and snippets.

@dweldon
dweldon / local-user.md
Last active May 4, 2023 06:52
Add a local pg user who can login without a password

Install pg

sudo apt-get install postgresql postgresql-contrib

Login as postgres and create the new user (dave in this example)

sudo -i -u postgres
createuser dave
psql