Create PostgreSQL user and database

pg.md

Create PostgreSQL user and database for development environment

1. Install PostgreSQL

$ sudo apt-get update
$ sudo apt-get install postgresql postgresql-contrib

2. Switch to postgresql user

$ sudo -i -u postgres

Now you can use psql

3. Create user (not in psql) with same name that is used in Unix system

$ createuser --interactive
Enter name of role to add: lumen
Shall the new role be a superuser? (y/n) y

More info man createuser

4. Create database with owner and locale

createdb db_name --owner=lumen --locale=ru_RU.utf8 --template=template0

More info man createdb You can list available locales with locale -a

template0 is used to bypass locale incompatible error