Maitiro ekuisa PostgreSQL paUbuntu

PostgreSQL ndeye Dhatabhesi manejimendi system yemahara pasi pezinesi rine zita rimwe chete, iro zvakare rine rutsigiro rwemaitiro akachengetwa mumitauro yakadai seJava, C ++, Ruby, Python Perl ...

Kusarudza kushandisa MySQL kana PostgreSQL kunogona kuve dambudziko. Zvinoita sekuti yekutanga inokurumidza kupfuura yechipiri, asi yechipiri, kusununguka, yakanyanya kusimba maererano nemaitiro. Naizvozvo, mu Ubunlog tinoda kukudzidzisa kuti sei download, instalar y gadzirira PostgreSQL yekushandisa muUbuntu (kana chero imwe Linux distro) nenzira yakapusa inogoneka.

Kuisa PostgreSQL

Kuti tiise iyo, isu tinofanirwa wedzera nyowani nyowani kune yedu runyorwa rwezvinyorwa. Tinogona kuzviita nyore nekuwedzera tambo kune yedu zvinyorwa.list neiyo repositori iri kubvunzwa. Kune izvi isu tinoita:

sudo sh -c 'echo «deb http: // apt.postgresql.org / pub / repos / apt /` lsb_release -cs`-pgdg main »>> /etc/apt/source.list.d/pgdg.list'

Iye zvino tinofanira kudaro download GPG kiyi kuitira kuti apt inogona kutarisa huchokwadi hwemapakeji atinotora kubva kune yapfuura repository. Isu tinoita:

wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | sudo apt-kiyi yekuwedzera -

Ipapo isu tinogadziridza zvinyorwa:

sudo apt-get update

Uye pakupedzisira, isu tinoisa mapakeji inoenderana PostgreSQL:

 sudo apt-tora kuisa postgresql postgresql-contrib

Gadzirira PostgreSQL yekushandisa

Kuti titange kushandisa PostgreSQL, isu tinofanirwa kutanga tadaro batanidza isu kune server yako. Kuti uite izvi, kana tichiisa PostgreSQL isu tine chaizvo yakagadzira mushandisi wesisitimu anonzi "postgres". Uyu mushandisi ane PostgreSQL dhatabhesi manejimendi manejimendi, saka danho rekutanga ndere pinda nemushandisi iyeye:

sudo su - postgres

Iye zvino tinofanira kudaro tanga PostgreSQL terminal kuti upinde mu database dura. Kuti tiite izvi isu tinoita 'psql' uye isu isu danda kubatanidza kune server.

psql

Kana isu tichida kutarisa iyo kubatana kana the shanduro iyo yatinayo kubva kuPostgreSQL, tinogona kuita unotevera kuraira:

postgres- # \ conninfo

Pakupedzisira, ye patsanura kubva kuseva kubva kudhatabhesi, tinogona kuzviita nekuita zvinotevera:

postgres- # q

mbudo

Ziva kuti rairo «yekubuda» inoitwa ku kubuda chikamu izvo zvataive tatanga pakutanga pasi pemushandisi «postgres».

Kana iwe wakambove nematambudziko panguva yekumisikidza kana kugadzirira kwePostgreSQL, ndokumbira utisiye muchikamu chemashoko uye tichaita zvatinogona kuti tikubatsire. Kusvikira nguva inotevera.