Skip to content

Instantly share code, notes, and snippets.

@dweldon
dweldon / local-user.md
Last active April 11, 2026 12:11
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