first time postgres database creation made easy

gistfile1.txt

# first create a user in the database that is your current username (answer 'y' for superuser  if this is a development machine.)
sudo su postgres -c "createuser seth"

# create a database of the same name, so that just typing 'psql' will drop you into the psql command-line against database 'seth'
sudo su postgres -c "createdb seth --owner seth"

# now you don't need to sudo for any subsequest pg commands, if you are logged in as this user, for example:
initdb /var/lib/pgsql91/data

createdb "test_this"

psql test_this