Gitlab-with-external-PostgreSQL.md

@@ -18,3 +18,29 @@ You can configure the external url or can change the configuration later on /etc
 ```
 sudo EXTERNAL_URL="http://gitlab.example.com" apt-get install gitlab-ee
 ```
+### Install PostgreSQL-server
+We installed the PostgreSQl-server on the same host as the GitLab.
+```
+sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -sc)-pgdg main"
+wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
+sudo apt-get update
+sudo apt-get install postgresql-9.6
+```
+### Create new user for GitLab
+
+First sign-in to the postgresql as superuser to create new user.
+```
+sudo -u postgres psql
+```
+Let's make a new user "git" and make it a superuser and the database which gitlab uses gitlabhq_production.
+```
+CREATE USER git CREATEDB;
+CREATE DATABASE gitlabhq_production OWNER git;
+ALTER USER git WITH SUPERUSER;
+ALTER USER git WITH PASSWORD 'somepassword'
+```
+Test that the new user can login:
+```
+sudo -u git -H psql -d gitlabhq_production
+```
+