CentOS 7-de pgAdmin4-i nädip gurmaly

PgAdmin4, PostgreSQL maglumat bazalaryny dolandyrmak üçin web interfeýsini ulanmak aňsat. Linux, Windows we Mac OS X ýaly birnäçe platformalarda ulanylyp bilner. PgAdmin 4-de bootstrap 3-den bootstrap 4-e göçmek bar.

Bu gollanmada pgAdmin 4-i CentOS 7 ulgamyna gurnarys.

Bellik: Bu gollanma, CentOS 7-de eýýäm PostgreSQL 9.2 ýa-da ondan ýokary gurnalandygyny göz öňünde tutýar. Ony nädip gurmalydygy barada görkezmeler üçin, CentOS we Fedora-da PostgreSQL 10-y nädip gurmalydygyny görkezip bilersiňiz.

CentOS 7-de pgAdmin 4-i nädip gurmaly

Bu ädim PostgreSQL gurlandan soň tamamlanmalydy, ýöne ýok bolsa, şulary ýerine ýetirip bilersiňiz:

# yum -y install https://download.postgresql.org/pub/repos/yum/12/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Indi pgAdmin bilen gurnamaga taýyn:

# yum -y install pgadmin4

Gurmak wagtynda, baglylyklar sebäpli aşakdaky ikisi hem gurlar - pgadmin4-web we httpd web serweri.

CentOS 7-de pgAdmin 4-i nädip sazlamaly

PgAdmin4 işlemegi üçin edilmeli ownuk konfigurasiýa üýtgeşmeleri az. Ilki bilen conf faýlynyň adyny pgadmin4.conf.sample-den pgadmin4.conf adyna üýtgederis:

# mv /etc/httpd/conf.d/pgadmin4.conf.sample /etc/httpd/conf.d/pgadmin4.conf
# vi /etc/httpd/conf.d/pgadmin4.conf

Faýly şeýle görnüşde sazlaň:

<VirtualHost *:80>
LoadModule wsgi_module modules/mod_wsgi.so
WSGIDaemonProcess pgadmin processes=1 threads=25
WSGIScriptAlias /pgadmin4 /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.wsgi

<Directory /usr/lib/python2.7/site-packages/pgadmin4-web/>
        WSGIProcessGroup pgadmin
        WSGIApplicationGroup %{GLOBAL}
        <IfModule mod_authz_core.c>
                # Apache 2.4
                Require all granted
        </IfModule>
        <IfModule !mod_authz_core.c>
                # Apache 2.2
                Order Deny,Allow
                Deny from All
                Allow from 127.0.0.1
                Allow from ::1
        </IfModule>
</Directory>
</VirtualHost>

Indiki pgAdmin4 üçin surnallar we lib kataloglary dörederis we olaryň eýeçiligini belläris:

# mkdir -p /var/lib/pgadmin4/
# mkdir -p /var/log/pgadmin4/
# chown -R apache:apache /var/lib/pgadmin4
# chown -R apache:apache /var/log/pgadmin4

Soň bolsa config_distro.py mazmunymyzy giňeldip bileris.

# vi /usr/lib/python2.7/site-packages/pgadmin4-web/config_distro.py

Aşakdaky setirleri goşuň:

LOG_FILE = '/var/log/pgadmin4/pgadmin4.log'
SQLITE_PATH = '/var/lib/pgadmin4/pgadmin4.db'
SESSION_DB_PATH = '/var/lib/pgadmin4/sessions'
STORAGE_DIR = '/var/lib/pgadmin4/storage'

Netijede, web interfeýsinde tassyklanjak ulanyjy hasaby dörederis. Munuň üçin ylga:

# python /usr/lib/python2.7/site-packages/pgadmin4-web/setup.py

Indi pgAdmin4 interfeýsine ýetmek üçin serweriňiziň http:// ip-address/pgadmin4 ýa-da http:// localhost/pgadmin4 girip bilersiňiz:

PgAdmin4 interfeýsine gireniňizde 403 ýalňyşlyk alsaňyz, aşakdaky faýllarda dogry SELinux kontekstini düzmeli.

# chcon -t httpd_sys_rw_content_t /var/log/pgadmin4 -R
# chcon -t httpd_sys_rw_content_t /var/lib/pgadmin4 -R

Hakyky tassyklamak üçin ozal ulanan e-poçta salgyňyzy we parolyňyzy ulanyň. Hakyky tassyklanandan soň, pgAdmin4 interfeýsini görmeli:

Ilkinji gireniňizde dolandyrmak üçin täze serwer goşmaly bolarsyňyz.\Täze serwer goş -a basyň. PostgresQL birikmesini sazlamaly bolarsyňyz. Birinji goýmada\Umumy aşakdaky sazlamalary giriziň:

• Ady - düzýän serweriňiziň adyny beriň.
• Düşündiriş - mysaly düşündirmek üçin teswir ýazyň.

Ikinji tab\Baglanyşyk has möhümdir, sebäbi girmeli bolarsyňyz:

• Host - PostgreSQL mysalynyň eýesi/IP adresi.
• Port - deslapky port 5432.
• Bejeriş bazasy - bu postgres bolmaly.
• Ulanyjy ady - birleşjek ulanyjy ady. Postgres ulanyjysyny ulanyp bilersiňiz.
• Parol - ýokardaky ulanyjy üçin parol.

Hemme zady dolduranyňyzdan soň, üýtgeşmeleri ýazdyryň. Baglanyşyk üstünlikli bolsa, aşakdaky sahypany görmeli:

Bu boldy. PgAdmin4 gurnamagyňyz tamamlandy we PostgreSQL maglumat bazasyny dolandyryp bilersiňiz.