Skip to content

Instantly share code, notes, and snippets.

@lxneng
Created March 19, 2012 05:38
Show Gist options
  • Save lxneng/2097212 to your computer and use it in GitHub Desktop.
Save lxneng/2097212 to your computer and use it in GitHub Desktop.
~ sudo -u postgres sh
$ createuser -P eric
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) y
$ psql postgres
psql (9.1.3)
Type "help" for help.
postgres=# create database eric encoding 'UTF-8';
CREATE DATABASE
postgres=#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment