cheatsheets/postgresql.org

Set up postgresql user

When you have postgresql running, execute these commands. Substituting "joshua" for your non-root username. This lets you connect to psql without having to provide any login details. It is quite handy. Note that I have created a database that is the same name as my username, but your database can be whatever name you want to give it.

#+BEGIN_SRC sh joshua@dobby ~$ sudo -u postgres -s /bin/sh Password: sh-5.0$ createuser joshua sh-5.0$ createdb joshua sh-5.0$

joshua@dobby ~$ psql joshua=> \c joshua You are now connected to database "joshua" as user "joshua". #+END_SRC