Skip to content

Instantly share code, notes, and snippets.

@HintikkaKimmo
Created February 10, 2016 19:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save HintikkaKimmo/9c29cfaea31d62c48a80 to your computer and use it in GitHub Desktop.
Save HintikkaKimmo/9c29cfaea31d62c48a80 to your computer and use it in GitHub Desktop.
You manipulate postgres through the user postgres, as so:
# su - postgres
$ createdb mydb
$ psql -s mydb
# create user someuser password 'somepassword';
# GRANT ALL PRIVILEGES ON DATABASE mydb TO someuser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment