Kutama kweGitLab dhatabhesi kuenda kunze PostgreSQL

Hello vose!

Muchinyorwa chino, isu tichatamisa dhatabhesi yeGitLab kubva mukati PostgreSQL, iyo yakaiswa neGitLab, kuenda kunze PostgreSQL, iyo yakatoiswa pane imwe server.

ONA
Zviito zvese zvinovimbiswa kushanda paCentOS 7.7.1908, PostgreSQL 12 uye GitLab 12.4.2-ee.0.

Kugadzirira kwekutanga

Ngatiite zvinhu zvitatu pachine nguva:

1. PaPostgreSQL server, wedzera mutemo kune firewall inobvumira kupinda mukati kuPostgreSQL port 5432/TCP.

Muchiitiko changu:

firewall-cmd --add-service=postgresql --zone=internal --permanent
success
firewall-cmd --reload
success

2. Munzvimbo imwe chete, asi mu postgresql.conf faira, bvumira network network kuti igamuchire hukama hunouya kubva kunze. Vhura iyo postgresql.conf faira, tsvaga yakataurwa mutsara "#teerera_kero = 'localhost'" uye pasi payo wedzera mutsara senge pazasi. Kupi - 10.0.0.2, kero yechitarisiko chako.

Muchiitiko changu:

vi /var/lib/pgsql/12/data/postgresql.conf
# - Connection Settings -

#listen_addresses = 'localhost'         # what IP address(es) to listen on;
listen_addresses = 'localhost, 10.0.0.2'
                                        # comma-separated list of addresses;

3. Sezvo sevha yeGitLab ichizobatana nedatabase rekunze, izvi zvinofanirwa kubvumidzwa paPostgreSQL server mupg_hba.conf file. Yangu GitLab server kero ndeye 10.0.0.4.

Ngativhure pg_hba.conf faira towedzera mutsara ipapo:

host    all             gitlab               10.0.0.4/24             md5

Ichaita seizvi:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             postgres                                     md5

# IPv4 local connections:
host    all             postgres             127.0.0.1/32            md5
host    all             gitlab               10.0.0.4/24             md5

Uye pakupedzisira, isu tinotangazve iyo postgresql sevhisi:

systemctl restart postgresql-12.service

Kutumira kunze dhatabhesi yeGitLab

Ngatiitei kuchengetedza dhatabhesi pane GitLab server:

sudo -u gitlab-psql /opt/gitlab/embedded/bin/pg_dumpall -U gitlab-psql --host=/var/opt/gitlab/postgresql > /tmp/internal-gitlab.sql

Iyo backup yakaonekwa mukati /tmp:

ls -lh
total 836K
-rw-r--r--. 1 root root 836K Nov 18 12:59 internal-gitlab.sql

Ngatikopei kopi iyi kuPostgreSQL server:

scp /tmp/internal-gitlab.sql 10.0.0.2:/tmp/
internal-gitlab.sql                                                                               100%  835KB  50.0MB/s   00:00

Kupinza "internal-gitlab.sql" muPostgreSQL

Ngenisa dhatabhesi muPostgreSQL:

sudo -u postgres psql -f /tmp/internal-gitlab.sql

Tarisa kuti dhatabhesi yave muPostgreSQL:

sudo -u postgres psql -l

Mutsetse unotevera unofanira kuoneka:

gitlabhq_production | gitlab   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

Kugadzirisa GitLab

Mushure mekutumira dhatabhesi muPostgreSQL, mushandisi wegitlab akagadzirwa. Iwe unofanirwa kushandura password yemushandisi uyu.

Kuchinja password:

sudo -u postgres psql -c "ALTER USER gitlab ENCRYPTED PASSWORD 'ПАРОЛЬ' VALID UNTIL 'infinity';"
Password for user postgres:
ALTER ROLE

Zvadaro, paGitLab server, mufaira rekugadzirisa /etc/gitlab/gitlab.rb, ticharatidza data yose yePostgreSQL yekunze.

Ngatigadzirei kopi yekuchengetedza yegitlab.rb faira:

cp /etc/gitlab/gitlab.rb /etc/gitlab/gitlab.rb.orig

Zvino wedzera mitsara iyi kumagumo egitlab.rb faira:

# Отключить встроенный PostgreSQL.
postgresql['enable'] = false

# Данные для подключения к внешней базе. Указывайте свои.
gitlab_rails['db_adapter'] = 'postgresql'
gitlab_rails['db_encoding'] = 'utf8'
gitlab_rails['db_host'] = '10.0.0.2'
gitlab_rails['db_port'] = 5432
gitlab_rails['db_database'] = "gitlabhq_production"
gitlab_rails['db_username'] = 'gitlab'
gitlab_rails['db_password'] = '******'

Sevha iyo faira /etc/gitlab/gitlab.rb uye gadzirisazve GitLab:

gitlab-ctl reconfigure && gitlab-ctl restart

Ndizvo zvose :)

Chikumbiro chikuru. Kana iwe ukaisa minus, nyora chikonzero mumashoko.

Source: www.habr.com