Otu esi etinye PostgreSQL na PhpPgAdmin na OpenSUSE

PostgreSQL (nke a na-akpọkarị Postgres) bụ isi iyi dị ike, n'efu na nke mepere emepe, gosipụtara nke ọma, nke ukwuu extensible na cross-platform ihe-mmekọrịta data usoro, wuru maka ntụkwasị obi, atụmatụ siri ike, na arụmọrụ dị elu.

PostgreSQL na-agba na sistemụ arụmọrụ niile gụnyere Linux. Ọ na-eji ma na-agbatị asụsụ SQL yana ọtụtụ atụmatụ na-echekwa ma na-ebuwanye ibu data kachasị mgbagwoju anya n'enweghị nsogbu.

PhpPgAdmin bụ ngwa eji elekọta nchekwa data PostgreSQL na webụ. Ọ na-enye ohere maka ijikwa ọtụtụ sava, na-achịkwa akụkụ dị iche iche nke PostgreSQL, ma na-akwado njikwa data dị mfe.

Ọ na-akwado ịkwatu data tebụl n'ụdị dị iche iche: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump na mbubata scripts SQL, data COPY, XML, CSV, na Tabbed. N'ụzọ dị mkpa, a na-agbatị ya site na iji plugins.

N'isiokwu a, anyị ga-akọwa otu esi etinye PostgreSQL 10 na PhpPgAdmin 5.6 na mbipụta nkesa openSUSE.

Ịwụnye ihe nkesa nchekwa data PostgreSQL

PostgreSQL 10 dị maka ịwụnye na openSUSE site na ebe nchekwa ndabere site na iji iwu zypper.

$ sudo zypper install postgresql10-server  postgresql10 

Mgbe usoro nrụnye zuru ezu, malite ọrụ Postgres, mee ka ọ malite na-akpaghị aka na buut sistemụ wee nyochaa ọkwa ya site na iji iwu ndị a.

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

N'oge nrụnye, Postgres na-emepụta onye ọrụ nchekwa data nhazi aha ya bụ \postgres\ na-enweghị paswọọdụ iji jikwaa ihe nkesa PostgreSQL. Nzọụkwụ ọzọ dị mkpa bụ idobe akaụntụ onye ọrụ a site na ịtọọ paswọọdụ maka ya.

Buru ụzọ gaa na akaụntụ onye ọrụ postgres, wee nweta shei postgres wee tọọ paswọọdụ ọhụrụ maka onye ọrụ ndabara dị ka ndị a.

$ sudo su - postgres
$ psql
# \password postgres

Na-ahazi nkesa nchekwa data PostgreSQL

N'oge a, anyị kwesịrị ịhazi ohere ịnweta ihe nkesa PostgreSQL site na ndị ahịa site na-edezi faịlụ nhazi njirimara ndị ahịa /var/lib/pgsql/data/pg_hba.conf.

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

Chọọ maka ahịrị ndị a wee gbanwee usoro nyocha na md5 dị ka egosiri na nseta ihuenyo ( rụtụ aka na akwụkwọ PostgreSQL 10 gọọmentị iji ghọta ụzọ nyocha dị iche iche).

# "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

Mgbe ahụ malitegharịa ọrụ postgres ka mgbanwe ndị ahụ wee malite.

$ sudo systemctl restart postgresql

Ịwụnye na ịhazi PhpPgAdmin

Dịka akọwara na mbụ, phpPgAdmin bụ ngwa ọrụ nchịkwa webụ maka PostgreSQL. Site na ndabara, openSUSE nwere phpPgAdmin 5.1 nke anaghị akwado postgresql10. Ya mere, anyị kwesịrị ịwụnye phpPgAdmin 5.6 dị ka egosiri.

$ 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

Mgbe ị wụnye phpPgAdmin, ịkwesịrị ịmepụta faịlụ nhazi etiti phpPgAdmin site na faịlụ nlele enyere. Mepee wee dezie faịlụ emepụtara site na iji editọ ederede ọkacha mmasị gị, dịka ọmụmaatụ:

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

Mgbe ahụ chọọ usoro nhazi nhazi akara wee tọọ uru ya na localhost iji mee ka njikọ TCP/IP dị na localhost.

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

Na mgbakwunye, chọọ ihe nchekwa nchekwa nbanye ọzọ wee gbanwee uru ya site na eziokwu ka ọ bụrụ ụgha iji kwe ka nbanye site na phpPgAdmin na-eji ụfọdụ aha njirimara dị ka pgsql. , postgres, mgbọrọgwụ, onye nchịkwa:

$conf['extra_login_security'] = false;

Chekwaa mgbanwe na faịlụ wee pụọ.

Na-esote, mee ka Apache PHP na ụdị modul nke phpPgAdmin chọrọ ma malitegharịa ọrụ Apache2 na postgresql site na iwu ndị a.

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

Ịnweta PhpPgAdmin Dashboard

Nzọụkwụ ikpeazụ bụ ịnweta phpPgAdmin site na ihe nchọgharị weebụ wee nwalee njikọ na sava nchekwa data. Jiri adreesị http://localhost/phpPgAdmin/ ma ọ bụ http://SERVER_IP/phpPgAdmin/ ka ịnyagharịa.

phpPgAdmin ndabara interface kwesịrị ịpụta dị ka egosiri. Pịa PostgreSQL ka ịnweta interface nbanye.

Na nbanye nbanye, tinye postgres dị ka aha njirimara wee nye paswọọdụ ị debere na mbụ maka onye ọrụ nchekwa data ndabara wee pịa Nbanye.

Ekele! Ị tinyela PostgreSQL 10 na phpPgAdmin 5.6 nke ọma na openSUSE. Maka ajụjụ ma ọ bụ nkọwa ọ bụla, jiri ụdị nzaghachi dị n'okpuru.