Yadda ake Shigar PostgreSQL tare da pgAdmin4 akan Linux Mint 20


pgAdmin sigar buɗe-tushen fasali-mai wadataccen kayan aiki, kayan aiki na gaba wanda ke ba ku damar gudanarwa tare da sarrafa bayanan haɗin bayanan PostgreSQL ɗinku daga burauzar gidan yanar gizo.

Yana bayar da sauƙin amfani da keɓaɓɓen mai amfani wanda ke sauƙaƙa ƙirƙirawa da sa ido kan bayanai da abubuwan adana bayanai. PgAdmin 4 ci gaba ne na kayan aikin pgAdmin na baya kuma akwai shi don Linux, Windows, tsarin macOS, har ma da akwatin Docker.

A cikin wannan darasin, zaku koyi yadda ake girka PostgreSQL tare da pgAdmin4 akan Linux Mint 20.

Mataki 1: Shigar da Bayanan PostgreSQL akan Linux Mint

1. Don farawa, ƙaddamar da tashar ka kuma sabunta kunshinka ta amfani da mai sarrafa kunshin dace kamar yadda aka nuna.

$ sudo apt update -y

Da zarar sabuntawa ya cika, ci gaba zuwa mataki na gaba.

Tunda pgAdmin4 yana samar da gaban gogewa don gudanar da abubuwa na bayanan PostgreSQL, yana da mahimmanci a sanya PostgreSQL da farko.

2. Don yin wannan, zamu shigar da kunshin postgresql da kuma gudummawar postgresql wanda ke ba da ingantattun abubuwa waɗanda ke faɗaɗa ayyukan PostgreSQL.

$ sudo apt install postgresql postgresql-contrib

3. Yawancin lokaci, PostgreSQL yana farawa ta atomatik akan boot up. Kuna iya tabbatar da wannan ta amfani da umarnin da aka bayar a ƙasa:

$ sudo systemctl status postgresql

4. Don shiga misali na PostgreSQL ɗin ka, fara canzawa zuwa mai amfani da postgres ɗin. Mai amfani da Postgres ya zo tare da tsoho tare da sanya PostgreSQL. Sannan aiwatar da umarnin psql kamar yadda aka nuna.

$ sudo -i -u postgres
$ psql
# \q

5. Bugu da ƙari, za ka iya bincika idan uwar garken bayanan yana karɓar haɗin haɗi kamar yadda aka nuna.

$ sudo pg_isready

Mataki 2: Shigar pgAdmin4 akan Mint na Linux

pgAdmin4 yana samuwa ga Ubuntu 16.04 kuma daga baya za a iya shigar dashi cikin sauƙi ta amfani da mai sarrafa kunshin APT. Hakanan ba zai iya tallafawa Linux Mint 20 da masu haɓaka Pgadmi4 har yanzu ba su haɗa da tallafi wanda ke bawa masu amfani damar sauƙaƙe kayan aikin sarrafa gaba ta amfani da mai sarrafa kunshin APT.

6. Zaɓin kawai mai yiwuwa shine shigar pgAdmin4 daga yanayin kamala. Don haka da farko, zamu girka abubuwanda ake buƙata kamar yadda aka nuna.

$ sudo apt install libgmp3-dev build-essential libssl-dev

7. Na gaba, shigar da Python yanayi mai kyau da mahimmancin dogaro.

$ sudo apt install python3-virtualenv python3-dev libpq-dev

8. Na gaba, ƙirƙiri kundin adireshi inda zaku ƙirƙiri yanayin kamala.

$ mkdir pgadmin4 && cd pgadmin4

9. Sannan kirkirar yanayin kamala kamar yadda aka nuna. Anan, pgadmin4env shine sunan yanayin kama-da-wane.

$ virtualenv pgadmin4env

10. Da zarar an samar da yanayi mai kyau, kunna shi kamar yadda aka nuna.

$ source pgadmin4env/bin/activate

11. Sannan kayi amfani da kayan aikin pip domin saka pgadmin4 kamar yadda aka nuna.

$ pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.30/pip/pgadmin4-4.30-py3-none-any.whl

12. Na gaba, ƙirƙiri fayil ɗin sanyi config_local.py.

$ sudo nano pgadmin4env/lib/python3.8/site-packages/pgadmin4/config_local.py

kuma ƙara layin da ke ƙasa.

import os
DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/'))
LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log')
SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db')
SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')
STORAGE_DIR = os.path.join(DATA_DIR, 'storage')
SERVER_MODE = False

13. Don fara pgAdmin4 kayan aikin gudanarwa, kira umurnin:

$ python pgadmin4env/lib/python3.8/site-packages/pgadmin4/pgadmin4.py
Or
./pgadmin4env/bin/pgadmin4&

14. A karshe, ka wuce zuwa kan burauzarka ka bincika adireshin da aka nuna.

http://127.0.0.1:5050

Za a sa ku saita kalmar sirri ta asali, don haka ci gaba da saita kalmar wucewa mai ƙarfi kuma danna maballin 'Ok'.

15. Don sauƙaƙa abubuwa, zaku iya ƙirƙirar laƙabi a cikin fayil ɗin ~/.bashrc kamar yadda aka nuna.

$ echo "alias startPg='~/pgAdmin4/venv/bin/python ~/pgAdmin4/venv/lib/python3.8/site-packages/pgadmin4/pgAdmin4.py'" >> ~/.bashrc

16. Na gaba, sabunta fayil din bashrc.

$ source ~/.bashrc

17. A ƙarshe, zaku iya fara pgAdmin4 kayan aikin gudanarwa ta hanyar kiran umarnin startpg kawai.

$ startpg

Sake komawa kan burauzar ku sai ku shiga cikin aikin PgAdmin4. Kuma wannan ya kammala girka pgAdmin4 akan Linux Mint.