Ungayifaka kanjani iPostgreSQL ku-Ubuntu

I-PostgreSQL iyi- uhlelo lokuphathwa kwemininingwane egciniwe imahhala ngaphansi kwelayisense enegama elifanayo, nayo enokwesekwa kwezinqubo ezigcinwe ngezilimi ezinjengeJava, C ++, Ruby, Python Perl ...

Ukunquma ukuthi uzosebenzisa i-MySQL noma i-PostgreSQL kungaba inkinga. Kubonakala sengathi eyokuqala iyashesha kuneyesibili, kodwa eyesibili, njengoba ikhululekile, iminyene kakhulu ngokwezici. Ngakho-ke, ku Ubunlog sifuna ukukufundisa ukuthi kanjani ukulanda, faka y lungiselela i-PostgreSQL ukuze isetshenziswe ku-Ubuntu (noma enye i-Linux distro) ngendlela elula kakhulu.

Ukufaka i-PostgreSQL

Ukuyifaka, kufanele engeza okugcina okusha ohlwini lwethu lwamakhosombe. Singakwenza kalula ngokungeza umugqa ku- imithombo.luhlu nenqolobane okukhulunywa ngayo. Ngenxa yalokhu senza lokhu:

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

Manje kufanele landa ukhiye we-GPG ukuze ukwazi ukubheka ukusebenza kwamaphakeji esiwalanda endaweni yokugcina yangaphambilini. Sikhipha:

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

Ngemuva kwalokho sivuselela amakhosombe:

sudo apt-get update

Ekugcineni, sifaka amaphakheji i-PostgreSQL ehambisanayo:

 sudo apt-get install postgresql postgresql-contrib

Lungiselela i-PostgreSQL ukuze uyisebenzise

Ukuze uqale ukusebenzisa iPostgreSQL, kufanele siqale isixhume kuseva yakho. Ukwenza lokhu, lapho sifaka iPostgreSQL empeleni sinakho udale umsebenzisi wesistimu obizwa nge- "postgres". Lo msebenzisi unamalungelo okuphatha i-PostgreSQL, ngakho-ke isinyathelo sokuqala ngena ngemvume nalowo msebenzisi:

sudo su - ama-postgres

Manje kufanele qala ukuphela kwePostgreSQL ukungena ngemvume kuseva yedatha. Ukwenza lokhu sisebenzisa i-'psql 'futhi thina thina ungene ukuxhuma kuseva.

psql

Uma sifuna ukubheka i- ukuxhumana noma i version esinayo evela ku-PostgreSQL, singenza umyalo olandelayo:

okuthunyelwe- # \ conninfo

Ekugcineni, kwe nqamula kusuka kuseva kusuka ku-database, singakwenza ngokwenza okulandelayo:

okuthunyelwe- # q

Phuma

Qaphela ukuthi umyalo «wokuphuma» wenziwa ku- isikhathi sokuphuma ukuthi besiqale ekuqaleni ngaphansi komsebenzisi «postgres».

Uma uke waba nezinkinga ngenkathi kufakwa noma kulungiswa iPostgreSQL, sicela ubashiye esigabeni sokuphawula futhi sizokwenza konke okusemandleni ethu ukukusiza. Kuze kube yisikhathi esilandelayo.