Skip to content

Instantly share code, notes, and snippets.

@jeanlescure

jeanlescure/postgres-init.md

Created August 3, 2016 21:15
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 jeanlescure/6434338846b2fe01c769d3f2fb2767d1 to your computer and use it in GitHub Desktop.
Save jeanlescure/6434338846b2fe01c769d3f2fb2767d1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres-init.md 
$ sudo apt-get install -y postgresql-9.4 postgresql-contrib-9.4 libpq-dev
$ sudo su - postgres
postgres@user:~$ createuser user
postgres@user:~$ psql
postgres=# ALTER ROLE user WITH SUPERUSER CREATEDB REPLICATION LOGIN;
postgres=# \password user
postgres=# CREATE SCHEMA user;
postgres=# \q
postgres@user:~$ exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment