postgresql.org 713 B
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