U haajiridda xogta GitLab ee PostgreSQL dibadda

Hello qof walba!

Maqaalkan, waxaanu ka haajirin doonaa xogta GitLab gudaha PostgreSQL, kaas oo lagu rakibay GitLab, una guuri doonaa PostgreSQL dibadda, kaas oo horay loogu rakibay server kale.

XUSUUS
Dhammaan tallaabooyinka waxaa loo dammaanad qaaday inay ka shaqeeyaan CentOS 7.7.1908, PostgreSQL 12 iyo GitLab 12.4.2-ee.0.

Diyaargarow hordhac ah

Aynu hore u sii wadno saddex arrimood:

1. Adeegga PostgreSQL, ku dar xeer dab-damiska oo u oggolaanaya xidhiidhada soo galaya ee PostgreSQL port 5432/TCP.

Xaaladdeyda:

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

2. Isla meel, laakiin feylka postgresql.conf, u ogolow isdhexgalka shabakada inuu aqbalo isku xirka dibadda ka imanaya. Fur faylka postgresql.conf, hel laynka faallooyinka laga bixiyay"#dhegeyso_addresses = 'localhost'" oo hoosteeda ku dar sadar sida hoose. Halkee - 10.0.0.2, ciwaanka interfiyuugaga.

Xaaladdeyda:

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. Maadaama server-ka GitLab uu ku xidhmi doono xog-ururin dibadeed, tani waa in lagu oggolaadaa server-ka PostgreSQL ee ku jira faylka pg_hba.conf. Ciwaanka serverka GitLab waa 10.0.0.4.

Aan furno faylka pg_hba.conf oo aan ku darno xariiqda halkaas:

host    all             gitlab               10.0.0.4/24             md5

Waxay u ekaan doontaa sidan:

# 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

Ugu dambeyntiina, waxaan dib u bilownay adeegii postgresql:

systemctl restart postgresql-12.service

Dhoofinta xogta GitLab

Aynu ku samayno kaydka xogta xogta ee server-ka GitLab:

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

Kaabashadu waxay ka soo muuqatay /tmp:

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

Aan koobiyeynno nuqulkan server-ka PostgreSQL:

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

Soo dejinta "internal-gitlab.sql" gudaha PostgreSQL

Soo rar xogta xogta PostgreSQL:

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

Hubi in kaydku hadda ku jiro PostgreSQL:

sudo -u postgres psql -l

Sadarka soo socdaa waa inuu soo muuqdaa:

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

Dejinta GitLab

Kadib soo dejinta xogta PostgreSQL, isticmaale gitlab ayaa la sameeyay. Waxaad u baahan tahay inaad beddesho erayga sirta ah ee isticmaalaha.

Beddelka erayga sirta ah:

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

Kadibna, server-ka GitLab, faylka qaabeynta /etc/gitlab/gitlab.rb, waxaan ku tusi doonaa dhammaan xogta PostgreSQL ee dibadda ah.

Aynu samayno koobi gurmad ah oo ah faylka gitlab.rb:

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

Hadda ku dar khadadkan dhamaadka faylka gitlab.rb:

# Отключить встроенный 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'] = '******'

Keydi faylka /etc/gitlab/gitlab.rb oo dib u habeyn GitLab:

gitlab-ctl reconfigure && gitlab-ctl restart

Waa intaas :)

Codsi weyn Haddii aad wax yar dhigto, ku qor sababta faallooyinka.

Source: www.habr.com