Yadda ake Sanya PostgreSQL 10 akan CentOS/RHEL da Fedora


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 wannan labarin, zamuyi bayanin yadda ake shigar da sabon sigar PostgreSQL 10 akan CentOS, RHEL, Oracle Enterprise Linux, Linux Scientific da Fedora ta amfani da ma'ajin PostgreSQL Yum na hukuma.

Ƙara Maajiyar PostgreSQL Yum

Wannan ma'ajiyar PostgreSQL Yum 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 rarraba tushen RedHat kamar CentOS, Linux Linux da Scientific Linux, da kuma nau'ikan Fedora na yanzu.

Lura cewa saboda gajeriyar zagayen tallafin Fedora, ba duk nau'ikan ke samuwa ba kuma muna ba da shawarar cewa kar a yi amfani da Fedora don tura sabar.

Don amfani da ma'ajiyar yum, bi waɗannan matakan:

--------------- On RHEL/CentOS 7 and Scientific Linux/Oracle Linux 7 --------------- 
# yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-1.noarch.rpm

--------------- On 64-Bit RHEL/CentOS 6 and Scientific Linux/Oracle Linux 6 --------------- 
# yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgdg-redhat10-10-1.noarch.rpm

--------------- On 32-Bit RHEL/CentOS 6 and Scientific Linux/Oracle Linux 6 --------------- 
# yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-i386/pgdg-redhat10-10-1.noarch.rpm

--------------- On Fedora 26 --------------- 
# dnf install https://download.postgresql.org/pub/repos/yum/10/fedora/fedora-26-x86_64/pgdg-fedora10-10-2.noarch.rpm

--------------- On Fedora 25 --------------- 
# dnf install https://download.postgresql.org/pub/repos/yum/10/fedora/fedora-25-x86_64/pgdg-fedora10-10-3.noarch.rpm

--------------- On Fedora 24 --------------- 
# dnf install https://download.postgresql.org/pub/repos/yum/10/fedora/fedora-24-x86_64/pgdg-fedora10-10-3.noarch.rpm

Shigar PostgreSQL Server

Bayan ƙara ma'ajiyar PostgreSQL yum a cikin rarraba Linux ɗin ku, yi amfani da umarni mai zuwa don shigar da sabar PostgreSQL da fakitin abokin ciniki.

# yum install postgresql10-server postgresql10   [On RedHat based Distributions]
# dnf install postgresql10-server postgresql10   [On Fedora Linux]

Muhimmi: Kundin bayanan bayanan PostgreSQL /var/lib/pgsql/10/data/ ya ƙunshi duk fayilolin bayanai na bayanan.

Fara Database PostgreSQL

Saboda wasu manufofi don rarraba tushen Red Hat, shigarwar PostgreSQL ba zai kasance mai aiki don farawa ta atomatik ba ko kuma an fara tattara bayanai ta atomatik. Don kammala shigarwar bayananku, kuna buƙatar fara shigar da bayananku kafin amfani da su a karon farko.

# /usr/pgsql-10/bin/postgresql-10-setup initdb

Fara kuma Kunna Sabar PostgreSQL

Bayan ƙaddamar da bayanai ya ƙare, fara sabis na PostgreSQL kuma kunna sabis na PostgreSQL don farawa ta atomatik akan boot ɗin tsarin.

--------------- On SystemD --------------- 
# systemctl start postgresql-10
# systemctl enable postgresql-10
# systemctl status postgresql-10 

--------------- On SysVinit --------------- 
# service postgresql-10 start
# chkconfig postgresql-10 on
# service postgresql-10 status

Tabbatar da Shigar PostgreSQL

Bayan shigar da PostgreSQL 10 akan sabar ku, tabbatar da shigarwa ta hanyar haɗawa zuwa uwar garken bayanai na postgres.

# su - postgres
$ psql

psql (10.0)
Type "help" for help.

Idan kana so zaka iya ƙirƙirar kalmar sirri don masu amfani da postgres don dalilai na tsaro.

postgres=# \password postgres

Kuna iya samun ƙarin bayani a Shafin Farko na PostgreSQL: https://www.postgresql.org/

Hakanan duba waɗannan labaran game da shahararrun tsarin sarrafa bayanai:

  1. Yadda ake Shigar da Amintacce MariaDB 10 a cikin CentOS 7
  2. Yadda ake Shigar da Amintacce MariaDB 10 a cikin CentOS 6
  3. Saka MongoDB Community Edition 3.2 akan Linux Systems

Shi ke nan! Da fatan za ku sami amfani wannan labarin. Idan kuna da wasu tambayoyi ko tunani don rabawa, yi amfani da sashin sharhin da ke ƙasa.