Otu esi etinye PostgreSQL na pgAdmin4 na Linux Mint 20

pgAdmin bụ ihe mepere emepe nke bara ụba, ngwa njikwa ihu na-enye gị ohere ijikwa ma jikwaa nchekwa data mmekọrịta PostgreSQL gị site na ihe nchọgharị weebụ.

Ọ na-enye ngwa ọrụ dị mfe iji mee ihe nke na-eme ka ịmepụta na nlekota nke ọdụ data na ihe nchekwa data dị mfe. PgAdmin 4 bụ nkwalite nke ngwa pgAdmin mbụ ma dị maka Linux, Windows, sistemụ macOS na ọbụna akpa Docker.

N'ime nkuzi a, ị ga-amụta ka esi etinye PostgreSQL na pgAdmin4 na Linux Mint 20.

Kwụpụ 1: Wụnye ọdụ data PostgreSQL na Linux Mint

1. Iji malite, malite ọnụ ọnụ gị wee kwalite ngwugwu gị site na iji njikwa ngwugwu dabara adaba dịka egosiri.

$ sudo apt update -y

Ozugbo emelitere mmelite ahụ, gaba na nzọụkwụ ọzọ.

Ebe pgAdmin4 na-enye ihu ihu maka njikwa ihe nchekwa data PostgreSQL, ọ dị mkpa ka etinyere PostgreSQL mbụ.

2. Iji mee nke a, anyị ga-etinye ngwugwu postgresql na postgresql-contrib nke na-enye atụmatụ agbatị nke na-agbatị ọrụ nke PostgreSQL.

$ sudo apt install postgresql postgresql-contrib

3. Ọtụtụ mgbe, PostgreSQL na-amalite na-akpaghị aka na buut elu. Ị nwere ike kwado nke a site na iji iwu enyere n'okpuru:

$ sudo systemctl status postgresql

4. Iji banye na ihe atụ PostgreSQL gị, buru ụzọ gbanwee gaa na onye ọrụ postgres. Onye ọrụ Postgres na-abịa na ndabara na ntinye nke PostgreSQL. Wee mee iwu psql dị ka egosiri.

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

5. Ọzọkwa, ị nwere ike ịlele ma ọ bụrụ na nchekwa data nkesa na-anabata njikọ mbata dị ka egosiri.

$ sudo pg_isready

Kwụpụ 2: Wụnye pgAdmin4 na Linux Mint

pgAdmin4 dị maka Ubuntu 16.04 na nsụgharị ndị ọzọ na enwere ike itinye ya ngwa ngwa site na iji njikwa ngwugwu APT. Otu ihe ahụ enweghị ike ịkwado Linux Mint 20 na ndị mmepe Pgadmi4 abanyebeghị nkwado nke na-enye ndị ọrụ ohere ịwụnye ngwa njikwa frontend ngwa ngwa site na iji njikwa ngwugwu APT.

6. Nanị nhọrọ nwere ike ime bụ ịwụnye pgAdmin4 site na gburugburu ebe obibi. Yabụ na nke mbụ, anyị ga-etinye ngwugwu ihe achọrọ dị ka egosiri.

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

7. Ọzọ, wụnye Python mebere gburugburu ebe obibi na ihe ndabere metụtara.

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

8. Ọzọ, mepụta ndekọ ebe ị ga-emepụta ebe obibi mebere.

$ mkdir pgadmin4 && cd pgadmin4

9. Mgbe ahụ mepụta mebere gburugburu dị ka egosiri. Ebe a, pgadmin4env bụ aha mebere gburugburu.

$ virtualenv pgadmin4env

10. Ozugbo mebere gburugburu ebe obibi, rụọ ọrụ ya dị ka egosiri.

$ source pgadmin4env/bin/activate

11. Mgbe ahụ, jiri ngwá ọrụ pip tinye pgadmin4 dị ka egosiri.

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

12. Ọzọ, mepụta faịlụ nhazi config_local.py.

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

ma tinye ahịrị ndị dị n'okpuru.

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. Iji malite ngwa njikwa pgAdmin4, kpọọ iwu:

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

14. N'ikpeazụ, gaba na ihe nchọgharị gị na-agagharị na adreesị gosiri.

http://127.0.0.1:5050

A ga-akpali gị ka ịtọọ paswọọdụ nna ukwu, yabụ gaba n'ihu ma tọọ paswọọdụ siri ike wee pịa bọtịnụ 'OK'.

15. Iji mee ka ihe dị mfe, ị nwere ike ịmepụta utu aha na faịlụ ~/.bashrc dị ka egosiri.

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

16. Ọzọ, melite faịlụ bashrc.

$ source ~/.bashrc

17. N'ikpeazụ, ị nwere ike ịmalite ngwa njikwa pgAdmin4 site na ịkpọku iwu startpg.

$ startpg

Gaa ọzọ na ihe nchọgharị gị wee banye na PgAdmin4 interface. Nke a mechiri ntinye nke pgAdmin4 na Linux Mint.