Yadda ake Sanya PostgreSQL tare da PhpPgAdmin akan OpenSUSE

PostgreSQL (wanda aka fi sani da Postgres) tushe ne mai ƙarfi, kyauta kuma mai buɗewa, cikakken fasali, mai fa'ida sosai da tsarin tsarin bayanai na alakar abun da ke tattare da dandamali, wanda aka gina don amintacce, fasalin ƙarfi, da babban aiki.

PostgreSQL yana gudana akan duk manyan tsarin aiki ciki har da Linux. Yana amfani kuma yana faɗaɗa harshen SQL haɗe tare da fasali da yawa waɗanda ke adanawa da auna nauyin aikin bayanai mafi rikitarwa.

PhpPgAdmin kayan aiki ne da ake amfani dashi don gudanar da bayanan PostgreSQL akan yanar gizo. Yana ba da damar gudanar da sabar da yawa, sarrafa nau'ikan daban-daban na PostgreSQL, kuma yana goyan bayan sauƙin sarrafa bayanai.

Hakanan yana goyan bayan zubar da bayanan tebur ta nau'ikan tsari: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump da shigo da rubutun SQL, COPY data, XML, CSV, da Tabbed. Mahimmanci, yana da tsawo tare da amfani da plugins.

A cikin wannan labarin, za mu bayyana yadda ake shigar da PostgreSQL 10 da PhpPgAdmin 5.6 a cikin bugu na uwar garken openSUSE.

Shigar da PostgreSQL Database Server

PostgreSQL 10 yana samuwa don shigarwa akan openSUSE daga tsoffin ma'ajin ta amfani da bin umarnin zypper.

$ sudo zypper install postgresql10-server  postgresql10 

Lokacin da tsarin shigarwa ya cika, fara sabis ɗin Postgres, ba shi damar farawa ta atomatik a boot ɗin tsarin kuma tabbatar da matsayinsa ta amfani da bin umarni.

$ sudo systemctl start postgresql
$ sudo systemctl enable postgresql
$ sudo systemctl status postgresql

Yayin shigarwa, Postgres yana ƙirƙirar mai amfani da bayanan gudanarwa mai suna \postgres\ ba tare da kalmar sirri don sarrafa sabar PostgreSQL ba. Mataki na gaba mai mahimmanci shine kiyaye wannan asusun mai amfani ta hanyar saita kalmar sirri don shi.

Da farko canza zuwa asusun mai amfani na postgres, sannan ku shiga harsashin postgres kuma saita sabon kalmar sirri don mai amfani kamar haka.

$ sudo su - postgres
$ psql
# \password postgres

Yana daidaita Sabar Database ta PostgreSQL

A wannan gaba, muna buƙatar saita damar zuwa uwar garken PostgreSQL daga abokan ciniki ta hanyar gyara fayil ɗin daidaitawar abokin ciniki /var/lib/pgsql/data/pg_hba.conf.

$ sudo vim /var/lib/pgsql/data/pg_hba.conf

Nemo layukan da ke biyowa kuma canza hanyar tabbatarwa zuwa md5 kamar yadda aka nuna a cikin hoton allo (koma zuwa takaddun PostgreSQL 10 na hukuma don fahimtar hanyoyin tantancewa daban-daban).

# "local" is for Unix domain socket connections only 
local   all             all                                     md5 
# IPv4 local connections: 
host    all             all             127.0.0.1/32            md5 
# IPv6 local connections: 
host    all             all             ::1/128                 md5

Sannan sake kunna sabis na postgres don canje-canje suyi tasiri.

$ sudo systemctl restart postgresql

Shigarwa da Sanya PhpPgAdmin

Kamar yadda aka bayyana a baya, phpPgAdmin kayan aikin gudanarwa ne na tushen yanar gizo don PostgreSQL. Ta hanyar tsoho, openSUSE yana da phpPgAdmin 5.1 wanda baya goyan bayan postgresql10. Don haka muna buƙatar shigar da phpPgAdmin 5.6 kamar yadda aka nuna.

$ wget -c https://github.com/phppgadmin/phppgadmin/archive/REL_5-6-0.zip
$ unzip REL_5-6-0.zip
$ sudo mv phppgadmin-REL_5-6-0 /srv/www/htdocs/phpPgAdmin

Bayan shigar da phpPgAdmin, kuna buƙatar ƙirƙirar babban fayil ɗin sanyi na phpPgAdmin daga fayil ɗin samfurin da aka bayar. Sannan bude kuma shirya fayil ɗin da aka ƙirƙira ta amfani da editan rubutun da kuka fi so, misali:

$ cd /srv/www/htdocs/phpPgAdmin/conf/
$ cp config.inc.php-dist config.inc.php 
$ sudo vim config.inc.php 

Sa'an nan nemo ma'aunin sanyi na rundunar layin kuma saita ƙimarsa zuwa \localhost don kunna haɗin TCP/IP akan localhost.

$conf['servers'][0]['host'] = 'localhost';

Bugu da kari, nemi ƙarin sigar tsaro ta shiga kuma canza ƙimarta zuwa daga \gaskiya zuwa ƙarya don ba da damar shiga ta hanyar phpPgAdmin ta amfani da wasu sunayen masu amfani kamar pgsql. , postgres, tushen, mai gudanarwa:

$conf['extra_login_security'] = false;

Ajiye canje-canje a fayil ɗin kuma fita.

Na gaba, kunna Apache PHP da nau'ikan nau'ikan nau'ikan da phpPgAdmin ke buƙata kuma sake kunna Apache2 da sabis na postgresql tare da umarni masu zuwa.

$ sudo a2enmod php7
$ sudo a2enmod version
$ sudo systemctl restart postgresql
$ sudo systemctl restart apache2

Shiga Dashboard PhpPgAdmin

Mataki na ƙarshe shine samun damar phpPgAdmin daga mai binciken gidan yanar gizo da gwada haɗin kai zuwa uwar garken bayanai. Yi amfani da adireshin http://localhost/phpPgAdmin/ ko http://SERVER_IP/phpPgAdmin/ don kewayawa.

phpPgAdmin tsoho dubawa yakamata ya bayyana kamar yadda aka nuna. Danna PostgreSQL don samun damar haɗin shiga.

A wurin shiga shiga, shigar da postgres azaman sunayen masu amfani kuma samar da kalmar sirri da kuka saita a baya don mai amfani da bayanan tsoho kuma danna Login.

Taya murna! Kun sami nasarar shigar PostgreSQL 10 da phpPgAdmin 5.6 a cikin openSUSE. Don kowace tambaya ko sharhi, yi amfani da fom ɗin amsa da ke ƙasa.