= Xhuma Isizindalwazi se-Azure se-PostgreSQL Flexible Server nge-private access access method =
**ISEBENZA KU
I-Azure Database ye-PostgreSQL - Iseva Eguquguqukayo
I-Azure Database ye-PostgreSQL Flexible Server iyisevisi ephethwe ongayisebenzisa ukuze usebenzise, ​​uphathe, futhi ukale amaseva e-PostgreSQL atholakala kakhulu efwini. Lesi siqalo esisheshayo sikukhombisa ukuthi ungayakha kanjani iseva eguquguqukayo kunethiwekhi ebonakalayo ngokusebenzisa ingosi ye-Azure

Uma unganakho okubhaliselwe kwe-Azure, dala i-akhawunti yamahhala ye-Azure ngaphambi kokuthi uqale

== Ngena ngemvume kuphothali ye-Azure ==
Iya kuphothali ye-Azure. Faka imininingwane yakho ukuze ungene ngemvume kuphothali. Ukubuka okuzenzakalelayo ideshibhodi yakho yesevisi

== Dala Isizindalwazi se-Azure seseva ye-PostgreSQL eguquguqukayo ==
Udala iseva eguquguqukayo enesethi echaziwe yezinsiza zokubala kanye nesitoreji. Udala iseva ngaphakathi kweqembu lensiza ye-Azure

Qedela lezi zinyathelo ukuze udale iseva evumelana nezimo:
Sesha bese ukhetha
Isizindalwazi se-Azure seseva ye-PostgreSQL ku-portal:
Khetha
Engeza

Use
Khetha Isizindalwazi se-Azure sekhasi lokukhetha lokuthunyelwa kwe-PostgreSQL, khetha amaseva aguqukayo njengenketho yokuthumela:
Use
I-Basicstab, faka okubhalisele, iqoqo lezisetshenziswa, isifunda, negama leseva. Ngamanani azenzakalelayo, lokhu kuzohlinzeka ngeseva ye-PostgreSQL yenguqulo 12 enezinjongo ezijwayelekile isigaba sentengo kusetshenziswa ama-vCores angu-2, i-RAM eyi-8 GiB, nesitoreji esingu-28 GiB. Ukugcinwa kwekhophi yasenqolobaneni yizinsuku eziyisikhombisa. Ungasebenzisa i-Developmentworkload ukuze wenzekalela esigabeni senani eliphansi

Kwe
I-Basicstab, faka igama lomsebenzisi eliyingqayizivele nephasiwedi yomqondisi

Iya ku
Ithebhu yenethiwekhi, bese ukhetha ukufinyelela okuyimfihlo. Awukwazi ukushintsha indlela yokuxhuma ngemva kokudala iseva. Khetha Dala inethiwekhi ebonakalayo ukuze udale inethiwekhi entsha ye-vnetenvironment1. Khetha okuthi OKonce usunikeze igama lenethiwekhi elibonakalayo nolwazi lwe-subnet

Khetha
Buyekeza + dala ukuze ubuyekeze ukucushwa kweseva yakho eguquguqukayo

Khetha
Dala ukuhlinzeka ngeseva. Ukunikeza kungathatha amaminithi ambalwa

Linda kuze kuqedwe ukusetshenziswa futhi kuphumelele

Khetha
Iya kusisetshenziswa ukuze ubuke Ikhasi Lokubuka konke leseva liyavuleka

== Dala umshini we-Azure Linux virtual ==
Njengoba iseva ikunethiwekhi ebonakalayo, ungaxhuma kuseva kuphela kwezinye izinsiza ze-Azure kunethiwekhi efanayo njengeseva. Ukuze uxhume futhi uphathe iseva, masidale umshini obonakalayo we-Linux. Umshini obonakalayo kufanele udalwe ku-
**isifunda esifanayo** kanye **okubhaliselwe okufanayo Umshini we-Linux we-virtual ungasetshenziswa njengomhubhe we-SSH ukuphatha iseva yesizindalwazi sakho


Iya eqenjini lakho lezinsiza lapho iseva idalwe khona. Khetha
Engeza

Khetha
Ubuntu Server 18.04 LTS

Kwe
I-Basicstab, ngaphansi kwemininingwane yephrojekthi, qiniseka ukuthi ukubhalisa okulungile kukhethiwe bese ukhetha Ukudala iqembu lensiza entsha. Thayipha i-myResourceGroup yegama

Ngaphansi
Imininingwane yesibonelo, thayipha i-myVM yegama lomshini obonakalayo, bese ukhetha Isifunda esifanayo neseva yakho yesizindalwazi

Ngaphansi
I-akhawunti yomlawuli, khetha ukhiye womphakathi we-SSH

Ku
Igama lomsebenzisi uhlobo lomsebenzisi we-azure

Ngoba
Umthombo wokhiye womphakathi we-SSH, shiya okumisiwe kokuthi Khiqiza ukubhanqwa kokhiye abasha, bese uthayipha u-myKeyfor the Key pair name

Ngaphansi
Imithetho yembobo engenayo>Izimbobo zokungena ezisesidlangalaleni, khetha okuthi Vumela izimbobo ezikhethiwe bese ukhetha i-SSH (22) kanye ne-HTTP (80) kokudonsela phansi.

Khetha i-
Ikhasi lenethiwekhi ukuze ulungiselele inethiwekhi ebonakalayo. Kunethiwekhi ebonakalayo, khetha i-vnetenvironment1edalelwe iseva yesizindalwazi

Khetha
Phatha ukucushwa kwe-subnet ukuze udale i-subnet entsha yeseva

Engeza i-subnet entsha yomshini obonakalayo

Ngemva kokuthi i-subnet idalwe ngempumelelo, vala ikhasi

Khetha
Buyekeza + Dala

Khetha
Dala. Uma iwindi lokukhiqiza ukhiye omusha livuleka, khetha okuthi Landa ukhiye oyimfihlo bese udala insiza. Ifayela lakho elingukhiye lizolandwa njenge-myKey.pem

Okubalulekile
Qiniseka ukuthi uyazi lapho
.pemfile ilandwe. Uzodinga indlela eya kuyo esinyathelweni esilandelayo

Lapho ukuthunyelwa kuqediwe, khetha
Iya kusisetshenziswa ukuze ubuke Ikhasi Lokubuka konke lomshini obonakalayo

Khetha ikheli le-IP lomphakathi bese ulikopishela ebhodini lakho lokunamathisela

== Faka amathuluzi eklayenti le-PostgreSQL ==
Dala uxhumano lwe-SSH ne-VM usebenzisa i-Bash noma i-PowerShell. Emyalweni wakho, vula uxhumano lwe-SSH emshinini wakho obonakalayo. Faka esikhundleni ikheli le-IP ngalelo elisuka ku-VM yakho, bese ushintsha indlela eya ku-
.pem ngendlela eya lapho ifayela elingukhiye lalandwa khona

ssh -i .\Ukulanda\myKey1.pem [email protected]
Ithiphu
Ukhiye we-SSH owudalile ungasetshenziswa ngokuzayo lapho udala i-VM ku-Azure. Vele ukhethe i
**Sebenzisa ukhiye ogcinwe ku-Azure** ukuze uthole **umthombo wokhiye womphakathi we-SSH** ngokuzayo uma udala i-VM. Usuvele unokhiye oyimfihlo kukhompuyutha yakho, ngakho-ke ngeke udinge ukulanda lutho

Udinga ukufaka ithuluzi le-postgresql-client ukuze ukwazi ukuxhuma kuseva

sudo apt-get update sudo apt-get install postgresql-client
Ukuxhumana kusizindalwazi kuphoqelelwa nge-SSL, yingakho udinga ukulanda isitifiketi somphakathi se-SSL

wget --no-check-certificate httpsdl.cacerts.digicert.com/DigiCertGlobalRootCA.crt.pem
== Xhuma kuseva kusuka emshinini we-virtual we-Azure Linux ==
Nge
**PSql** ithuluzi leklayenti lifakiwe, manje sesingakwazi ukuxhuma kuseva endaweni yangakini
psql --host=mydemoserver-pg.postgres.database.azure.com --port=5432 --username=myadmin --dbname=postgres --set=sslmode=require --set=sslrootcert=DigiCertGlobalRootCA.crt.pem
== Hlanza izinsiza ==
Manje usudale i-Database ye-Azure yeseva ye-PostgreSQL eguquguqukayo eqenjini lezinsiza. Uma ungalindele ukuthi uzodinga lezi zinsiza esikhathini esizayo, ungazisusa ngokususa iqembu lezisetshenziswa, noma ungavele ususe iseva ye-PostgreSQL. Ukuze ususe iqembu lezisetshenziswa, qedela lezi zinyathelo ezilandelayo:
- Kungosi ye-Azure, sesha bese ukhetha
Amaqembu ezinsiza

- Ohlwini lwamaqembu ezinsiza, khetha igama leqembu lakho lezinsiza

- Phakathi
Ikhasi lokubuka leqembu lakho lezisetshenziswa, khetha okuthi Susa iqembu lezisetshenziswa

- Ebhokisini lebhokisi lokuqinisekisa, thayipha igama leqembu lakho lensiza, bese ukhetha
Susa

== Izinyathelo ezilandelayo ==
== Impendulo ==
Thumela futhi ubuke impendulo ye-