Yadda ake girka PostgreSQL akan Ubuntu

PostgreSQL shine tsarin sarrafa bayanai kyauta a ƙarƙashin lasisi mai suna iri ɗaya, wanda kuma yana da tallafi don hanyoyin adana a cikin yare kamar Java, C ++, Ruby, Python Perl ...

Yanke shawarar ko amfani da MySQL ko PostgreSQL na iya zama matsala. Da alama na farko yana da ɗan sauri fiye da na biyu, amma na biyu, kasancewa kyauta, ya fi girma ta fuskar fasali. Saboda haka, in Ubunlog muna so mu koya muku yadda download, shigarwa y shirya PostgreSQL don amfani a Ubuntu (ko wani Linux distro) a cikin hanya mafi sauƙi.

Girkawar PostgreSQL

Don shigar da shi, dole ne mu ƙara sabon wurin ajiyewa zuwa jerin wuraren ajiyar mu. Muna iya yin saukinsa ta hanyar ƙara layi zuwa namu sources.list tare da ma'ajiyar tambaya. Saboda wannan muke aiwatarwa:

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

Yanzu yakamata muyi zazzage maɓallin GPG don haka dacewa zai iya bincika ingancin fakitin da muka zazzage daga ma'ajiyar baya. Muna aiwatarwa:

wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O - | sudo-key add -

Sannan mun sabunta wuraren ajiya:

sudo apt-samun sabuntawa

Kuma a ƙarshe, mun shigar da fakitoci daidai PostgreSQL:

 sudo apt-samun shigar postgresql postgresql-bayar

Shirya PostgreSQL don amfani

Domin fara amfani da PostgreSQL, dole ne mu fara haɗa mu da sabarka. Don yin wannan, lokacin shigar PostgreSQL muna da ainihin ƙirƙirar mai amfani da tsarin mai suna "postgres". Wannan mai amfanin yana da gatan gudanarwa na gidan bayanan PostgreSQL, don haka matakin farko shine shiga tare da wannan mai amfani:

sudo su - postgres

Yanzu yakamata muyi fara tashar PostgreSQL don shiga cikin sabar bayanan bayanai. Don yin wannan muna aiwatar da 'psql' kuma mu muna shiga don haɗawa zuwa sabar.

psql

Idan muna so mu kalla a haɗi ko sigar cewa muna da shi daga PostgreSQL, zamu iya aiwatar da wannan umarni:

postgres- # \ conninfo

A ƙarshe, don cire haɗin daga sabar daga bayanan, za mu iya yin ta ta aiwatar da waɗannan masu zuwa:

postgres- # \ q

fita

Lura cewa umarnin «fita» ana aiwatar da shi zuwa zaman fita cewa mun fara a farkon ƙarƙashin mai amfani «postgres».

Idan kun sami matsala yayin girkawa ko shirye-shiryen PostgreSQL, da fatan za a bar su a cikin ɓangaren maganganun kuma za mu yi iya ƙoƙarinmu don taimaka muku. Har sai lokaci na gaba.