Yadda ake Sanya PostgreSQL 9.6 akan Debian da Ubuntu

PostgreSQL mai ƙarfi ne, mai ƙima sosai, buɗaɗɗen tushe da tsarin bayanai na alakar abu-dandamali wanda ke gudana akan tsarin aiki-kamar Unix ciki har da Linux da Windows OS. Tsarin tsarin bayanai ne na matakin kamfanoni wanda abin dogaro ne sosai kuma yana ba da amincin bayanai da daidaito ga masu amfani.

A cikin labarinmu na farko, mun bayyana shigarwar PostgreSQL 10 akan CentOS/RHEL da Fedora. A cikin wannan labarin, za mu bayyana yadda ake shigar da PostgreSQL 9.6 akan Debian, Ubuntu da abubuwan da suka samo asali ta amfani da ma'ajin PostgreSQL APT na hukuma.

Ƙara Ma'ajiyar PostgreSQL APT

Wannan wurin ajiyar PostgreSQL APT na hukuma zai haɗu tare da tsarin Linux ɗin ku kuma yana ba da sabuntawa ta atomatik don duk nau'ikan tallafi na PostgreSQL akan rarrabawar Debian da Ubuntu.

Don ƙara ma'ajin da ya dace, da farko ƙirƙirar fayil ɗin /etc/apt/sources.list.d/pgdg.list, kuma ƙara layi don ma'ajiyar kamar yadda ake rarrabawa.

--------------- On Ubuntu 17.04 ---------------
deb http://apt.postgresql.org/pub/repos/apt/ zesty-pgdg main

--------------- On Ubuntu 16.04 ---------------
deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main

--------------- On Ubuntu 14.04 ---------------
deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main

--------------- On Stretch 9.x ---------------
deb http://apt.postgresql.org/pub/repos/apt/ stretch-pgdg main

--------------- On Jessie 8.x ---------------
deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main

--------------- On Wheezy 7.x ---------------
deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main

Sannan shigo da maɓallin sa hannu na ma'ajiya, kuma sabunta jerin fakitin tsarin kamar haka.

$ wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
$ sudo apt update 

Shigar PostgreSQL Server

Da zarar kun ƙara ma'ajin da ya dace na PostgreSQL a cikin rarraba Linux ɗin ku, yanzu shigar da sabar PostgreSQL da fakitin abokin ciniki kamar haka:

$ sudo apt install postgresql-9.6-server postgresql-9.6  

Muhimmi: Ba kamar a cikin RHEL/CentOS/Fedora ba inda dole ne ka fara tsarin bayanai da hannu, a cikin Ubuntu/Debian, an fara farawa ta atomatik. Don haka kawai ci gaba don fara uwar garken bayanai kamar yadda aka bayyana a sashe na gaba.

Kundin bayanan bayanan PostgreSQL /var/lib/postgresql/9.6/main yana ƙunshe da duk fayilolin bayanai na bayanan.

Fara kuma Kunna Sabar PostgreSQL

Tare da ƙaddamar da uwar garken bayanai, fara sabis na PostgreSQL kuma kunna sabis na PostgreSQL don farawa ta atomatik akan boot ɗin tsarin kamar wannan.

--------------- On SystemD --------------- 
$ sudo systemctl start postgresql.service
$ sudo systemctl enable postgresql.service 
$ sudo systemctl status postgresql.service 

--------------- On SysVinit --------------- 
$ sudo service postgresql-9.6 start
$ sudo chkconfig postgresql on
$ sudo service postgresql-9.6 status

Tabbatar da Shigar PostgreSQL

Bayan shigar da tsarin bayanan PostgreSQL akan sabar ku, tabbatar da shigarwa ta hanyar haɗawa zuwa uwar garken bayanai na postgres. Ana kiran mai amfani da mai gudanarwa na PostgreSQL azaman postgres, rubuta wannan umarni don samun damar asusun tsarin mai amfani.

$ sudo su postgres
# cd
# psql

Don saita kalmar sirri don mai amfani da bayanan bayanan postgre, yi amfani da wannan umarni:

postgres=# \password postgres

Don kiyaye asusun tsarin mai amfani na postgre, yi amfani da umarnin kalmar sirri da ke ƙasa.

$ sudo passwd postgres 

Enter new UNIX password: 
Retype new UNIX password: 
passwd: password updated successfully

$su - postgre
$ ls
$ psql

Don ƙarin bayani, je zuwa Shafin Farko na PostgreSQL: https://www.postgresql.org/

A ƙarshe, kuma karanta ta cikin waɗannan labaran game da shahararrun tsarin sarrafa bayanai:

1. Shigar da MariaDB 10.1 a cikin Debian Jessie da Gudun Tambayoyin MariaDB Daban-daban
2. Yadda ake Canja Tsohuwar Jagorar Bayanan Bayanan MySQL/MariaDB a cikin Linux
3. Yadda ake Shigar da Amintacce MariaDB 10 a cikin CentOS 7
4. Yadda ake Shigar da Amintacce MariaDB 10 a cikin CentOS 6
5. Saka MongoDB Community Edition 3.2 akan Linux Systems

Wannan ke nan a yanzu! Don raba kowane tunani tare da mu, yi amfani da fom ɗin amsa da ke ƙasa. Ka tuna koyaushe ka kasance cikin haɗin kai zuwa linux-console.net don abubuwan Linux masu ban sha'awa.