Skip to content

Instantly share code, notes, and snippets.

@randyjhunt
Created January 31, 2009 02:54
Show Gist options
  • Select an option

  • Save randyjhunt/55415 to your computer and use it in GitHub Desktop.

Select an option

Save randyjhunt/55415 to your computer and use it in GitHub Desktop.
# run psql as the postgres user
psql -U postgres
create role USERNAME with createdb login;
\q
# run psql as the newly created user
psql -U USERNAME postgres
create database DBNAME;
\q
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment