Bii o ṣe le Fi PostgreSQL sii pẹlu PhpPgAdmin lori OpenSUSE
PostgreSQL (eyiti a mọ ni Postgres) jẹ agbara, orisun ọfẹ ati ṣiṣi, ẹya ti o ni kikun, ẹya ti o ga julọ ati eto ipilẹ data ibatan ibatan nkan-agbelebu, ti a ṣe fun igbẹkẹle, agbara ẹya, ati iṣẹ giga.
PostgreSQL n ṣiṣẹ lori gbogbo awọn ọna ṣiṣe pataki pẹlu Lainos. O nlo ati faagun ede SQL ni idapo pẹlu ọpọlọpọ awọn ẹya ti o fipamọ lailewu ati wiwọn awọn iṣiṣẹ iṣẹ data ti o nira julọ.
PhpPgAdmin jẹ ọpa ti a lo fun sisakoso ibi ipamọ data PostgreSQL lori oju opo wẹẹbu. O gba laaye fun ṣiṣakoso awọn olupin pupọ, ṣiṣakoso ọpọlọpọ awọn oriṣiriṣi awọn aaye ti PostgreSQL, ati atilẹyin ifọwọyi data rọrun.
O tun ṣe atilẹyin didaakọ data tabili ni ọpọlọpọ awọn ọna kika: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump ati gbigbe wọle awọn iwe afọwọkọ SQL, data COPY, XML, CSV, ati Tabbed. Ni pataki, o jẹ afikun pẹlu lilo awọn afikun.
Ninu àpilẹkọ yii, a yoo ṣalaye bi o ṣe le fi sori ẹrọ PostgreSQL 10 ati PhpPgAdmin 5.6 ninu ẹda olupin openSUSE.
Fifi Server PostgreSQL Alaye data sii
PostgreSQL 10 wa lati fi sori ẹrọ lori openSUSE lati awọn ibi ipamọ aiyipada nipa lilo atẹle pipaṣẹ zypper.
$ sudo zypper install postgresql10-server postgresql10
Nigbati ilana fifi sori ẹrọ ba pari, bẹrẹ iṣẹ Postgres, jẹ ki o bẹrẹ ni idojukọ ni ibẹrẹ eto ati ṣayẹwo ipo rẹ nipa lilo awọn ofin wọnyi.
$ sudo systemctl start postgresql $ sudo systemctl enable postgresql $ sudo systemctl status postgresql
Lakoko fifi sori ẹrọ, Postgres ṣẹda olumulo ibi ipamọ data iṣakoso ti a npè ni \"postgres \" laisi ọrọ igbaniwọle lati ṣakoso olupin PostgreSQL. Igbese pataki ti o tẹle ni lati ni aabo akọọlẹ olumulo yii nipa siseto ọrọigbaniwọle kan fun.
Ni akọkọ yipada si akọọlẹ olumulo postgres, lẹhinna wọle si ikarahun postgres ki o ṣeto ọrọ igbaniwọle titun fun olumulo aiyipada bi atẹle.
$ sudo su - postgres $ psql # \password postgres
Tito leto Server Database PostgreSQL
Ni aaye yii, a nilo lati tunto iraye si olupin PostgreSQL lati ọdọ awọn alabara nipa ṣiṣatunkọ faili iṣeto ni idanimọ alabara /var/lib/pgsql/data/pg_hba.conf.
$ sudo vim /var/lib/pgsql/data/pg_hba.conf
Wa fun awọn ila wọnyi ki o yi ọna ijẹrisi pada si md5 bi o ṣe han ninu sikirinifoto (tọka si iwe aṣẹ osise PostgreSQL 10 lati ni oye awọn ọna ijẹrisi oriṣiriṣi).
# "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
Lẹhinna tun bẹrẹ iṣẹ postgres fun awọn ayipada lati ni ipa.
$ sudo systemctl restart postgresql
Fifi ati tunto PhpPgAdmin
Gẹgẹbi a ti ṣalaye tẹlẹ, phpPgAdmin jẹ ọpa iṣakoso oju-iwe wẹẹbu fun PostgreSQL. Nipa aiyipada, openSUSE ni phpPgAdmin 5.1 eyiti ko ṣe atilẹyin postgresql10. Nitorina a nilo lati fi sori ẹrọ phpPgAdmin 5.6 bi o ti han.
$ 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
Lẹhin fifi phpPgAdmin sori ẹrọ, o nilo lati ṣẹda faili iṣeto aringbungbun phpPgAdmin lati faili apẹẹrẹ ti a pese. Lẹhinna ṣii ati ṣatunkọ faili ti a ṣẹda nipa lilo olootu ọrọ ayanfẹ rẹ, fun apẹẹrẹ:
$ cd /srv/www/htdocs/phpPgAdmin/conf/ $ cp config.inc.php-dist config.inc.php $ sudo vim config.inc.php
Lẹhinna wa fun paramita iṣeto iṣeto ogun laini ati ṣeto iye rẹ si \"localhost" lati jẹki awọn asopọ TCP/IP lori localhost.
$conf['servers'][0]['host'] = 'localhost';
Ni afikun, wa fun afikun aabo aabo wiwọle ati yi iye rẹ pada lati \"otitọ" si \"eke" lati gba awọn ibuwolu wọle nipasẹ phpPgAdmin ni lilo awọn orukọ olumulo kan bii pgsql , postgres, gbongbo, alakoso:
$conf['extra_login_security'] = false;
Fipamọ awọn ayipada si faili ki o jade.
Nigbamii, mu PHP Apache ṣiṣẹ ati awọn modulu ẹya ti o nilo nipasẹ phpPgAdmin ki o tun bẹrẹ Apache2 ati awọn iṣẹ postgresql pẹlu awọn ofin wọnyi.
$ sudo a2enmod php7 $ sudo a2enmod version $ sudo systemctl restart postgresql $ sudo systemctl restart apache2
Wiwọle Dasibodu PhpPgAdmin
Igbesẹ ikẹhin ni lati wọle si phpPgAdmin lati aṣawakiri wẹẹbu kan ati idanwo asopọ si olupin data. Lo adirẹsi http:// localhost/phpPgAdmin/ tabi http:// SERVER_IP/phpPgAdmin/ lati lilö kiri.
Ni wiwo aiyipada phpPgAdmin yẹ ki o han bi o ti han. Tẹ PostgreSQL lati wọle si wiwo Wiwọle.
Ni wiwole iwọle, tẹ awọn postgres bi awọn orukọ olumulo ki o pese ọrọ igbaniwọle ti o ṣeto tẹlẹ fun olumulo aiyipada data ki o tẹ Wọle.
Oriire! O ti fi PostgreSQL 10 ati phpPgAdmin 5.6 sori ẹrọ ni aṣeyọri ni openSUSE. Fun eyikeyi ibeere tabi awọn asọye, lo fọọmu esi ni isalẹ.