{"id":93878,"date":"2020-09-10T19:42:02","date_gmt":"2020-09-10T17:42:02","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/kak-vpisat-svobodnuyu-postgresql-v-surovoe-enterprise-okruzhenie"},"modified":"2020-09-10T19:42:02","modified_gmt":"2020-09-10T17:42:02","slug":"kak-vpisat-svobodnuyu-postgresql-v-surovoe-enterprise-okruzhenie","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-vpisat-svobodnuyu-postgresql-v-surovoe-enterprise-okruzhenie","title":{"rendered":"Si t\u00eb integrosh PostgreSQL 't\u00eb lir\u00eb' n\u00eb nj\u00eb mjedis t\u00eb ashp\u00ebr enterprise","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Shum\u00eb njer\u00ebz e njohin SGBD PostgreSQL, dhe ajo ka treguar performanc\u00eb t\u00eb shk\u00eblqyer n\u00eb instalime t\u00eb vogla. Megjithat\u00eb, tendenca p\u00ebr t\u00eb kaluar n\u00eb Open Source \u00ebsht\u00eb b\u00ebr\u00eb gjithnj\u00eb e m\u00eb e dukshme, edhe kur flitet p\u00ebr kompanit\u00eb e m\u00ebdha dhe k\u00ebrkesat e sip\u00ebrmarrjes. N\u00eb k\u00ebt\u00eb artikull, ne do t\u00eb tregojm\u00eb se si ta integrojm\u00eb Postgres n\u00eb ambientin e korporatave dhe do t\u00eb ndajm\u00eb p\u00ebrvoj\u00ebn ton\u00eb n\u00eb krijimin e nj\u00eb sistemi rezerv\u00eb (SRK) p\u00ebr k\u00ebt\u00eb baz\u00eb t\u00eb dh\u00ebnash, duke u bazuar n\u00eb sistemin e rezervimit Commvault. <\/p>\n<p><img decoding=\"async\" alt=\"Si t\u00eb integrosh PostgreSQL &#039;t\u00eb lir\u00eb&#039; n\u00eb nj\u00eb mjedis t\u00eb ashp\u00ebr enterprise\" src=\"\/wp-content\/uploads\/2020\/09\/054cb60090c1b6df6da0010c5ba35f8b.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nPostgreSQL tashm\u00eb ka provuar vler\u00ebn e saj \u2013 SGBD funksionon shk\u00eblqyesh\u00ebm, e p\u00ebrdorin biznese dixhitale t\u00eb njohura si Alibaba dhe TripAdvisor, dhe mungesa e tarifave licencuese e b\u00ebn at\u00eb nj\u00eb alternativ\u00eb t\u00ebrheq\u00ebse ndaj monstruve si MS SQL ose Oracle DB. Por sapo fillojm\u00eb t\u00eb mendojm\u00eb p\u00ebr PostgreSQL n\u00eb peizazhin e Sip\u00ebrmarrjes, menj\u00ebher\u00eb p\u00ebrballemi me k\u00ebrkesa t\u00eb rrepta: \u201cSi \u00ebsht\u00eb q\u00ebndrueshm\u00ebria e konfiguracionit? q\u00ebndrueshm\u00ebria n\u00eb rast katastrofe? ku \u00ebsht\u00eb monitorimi i gjithansh\u00ebm? a \u00ebsht\u00eb automatizimi i rezervimit? a \u00ebsht\u00eb p\u00ebrdorimi i bibliotekave t\u00eb kasetave si direkt, ashtu edhe si nj\u00eb depo e dyt\u00eb?\u201d<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\n<img decoding=\"async\" alt=\"Si t\u00eb integrosh PostgreSQL &#039;t\u00eb lir\u00eb&#039; n\u00eb nj\u00eb mjedis t\u00eb ashp\u00ebr enterprise\" src=\"\/wp-content\/uploads\/2020\/09\/9b7e3d88c6e5488e1684239b546deb1b.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nNga nj\u00ebra an\u00eb, PostgreSQL nuk ka mjete t\u00eb integruara p\u00ebr rezervim, si\u00e7 jan\u00eb ato \u2018t\u00eb rritura\u2019 t\u00eb SGBD-ve si RMAN p\u00ebr Oracle DB ose SAP Database Backup. Nga ana tjet\u00ebr, ofruesit e sistemeve korporative t\u00eb rezervimit (Veeam, Veritas, Commvault) megjith\u00ebse mb\u00ebshtesin PostgreSQL, n\u00eb t\u00eb v\u00ebrtet\u00eb punojn\u00eb vet\u00ebm me nj\u00eb konfiguracion t\u00eb caktuar (zakonisht standalone) dhe me nj\u00eb grup t\u00eb ndrysh\u00ebm kufizimesh. <\/p>\n<p>Sistemet e rezervimit t\u00eb dizajnuara posa\u00e7\u00ebrisht p\u00ebr PostgreSQL, si Barman, Wal-g, pg_probackup, jan\u00eb shum\u00eb t\u00eb njohura n\u00eb instalime t\u00eb vogla t\u00eb SGBD PostgreSQL ose atje ku nuk nevojiten rezervime t\u00eb r\u00ebnda t\u00eb elementeve t\u00eb tjera t\u00eb peizazhit IT. P\u00ebr shembull, p\u00ebrve\u00e7 PostgreSQL, n\u00eb infrastruktur\u00eb mund t\u00eb ken\u00eb fizik dhe virtual, OpenShift, Oracle, MariaDB, Cassandra, etj. T\u00eb gjitha k\u00ebto preferohet t\u00eb rezervohen me nj\u00eb mjet t\u00eb p\u00ebrbashk\u00ebt. T\u00eb vendos\u00ebsh nj\u00eb zgjidhje t\u00eb ve\u00e7ant\u00eb vet\u00ebm p\u00ebr PostgreSQL \u00ebsht\u00eb nj\u00eb ide e keqe: t\u00eb dh\u00ebnat do t\u00eb kopjohen diku n\u00eb disk dhe pastaj duhet t'i \u00e7osh n\u00eb kaset\u00eb. Ky dyfishim i rezervimeve rrit koh\u00ebn e rezervimit dhe, m\u00eb kritikisht, koh\u00ebn e rikuperimit. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/\"   title=\"server\u00ebt\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"1900\">server\u00ebt<\/a>, OpenShift, Oracle, MariaDB, Cassandra \u0438 \u0442.\u0434. \u0412\u0441\u0451 \u044d\u0442\u043e \u0436\u0435\u043b\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u0431\u044d\u043a\u0430\u043f\u0438\u0442\u044c \u043e\u0431\u0449\u0438\u043c \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u043e\u043c. \u0421\u0442\u0430\u0432\u0438\u0442\u044c \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0435 \u0440\u0435\u0448\u0435\u043d\u0438\u0435 \u0438\u0441\u043a\u043b\u044e\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0434\u043b\u044f PostgreSQL\u2014 \u043d\u0435\u0443\u0434\u0430\u0447\u043d\u0430\u044f \u0437\u0430\u0442\u0435\u044f: \u0434\u0430\u043d\u043d\u044b\u0435 \u0431\u0443\u0434\u0443\u0442 \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u043a\u0443\u0434\u0430-\u0442\u043e \u043d\u0430 \u0434\u0438\u0441\u043a, \u0430 \u043f\u043e\u0442\u043e\u043c \u0438\u0445 \u043d\u0443\u0436\u043d\u043e \u0443\u0431\u0438\u0440\u0430\u0442\u044c \u043d\u0430 \u043b\u0435\u043d\u0442\u0443. \u0422\u0430\u043a\u043e\u0435 \u0437\u0430\u0434\u0432\u043e\u0435\u043d\u0438\u0435 \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0432\u0430\u0435\u0442 \u0432\u0440\u0435\u043c\u044f \u0431\u044d\u043a\u0430\u043f\u0430, \u0430 \u0442\u0430\u043a\u0436\u0435, \u0447\u0442\u043e \u0431\u043e\u043b\u0435\u0435 \u043a\u0440\u0438\u0442\u0438\u0447\u043d\u043e, \u2014 \u0432\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f.<\/p>\n<p>N\u00eb zgjidhjet enterprise, kopjimi i rezerv\u00ebs s\u00eb instalimit ndodh me nj\u00eb num\u00ebr nodash q\u00eb i jan\u00eb kushtuar nj\u00eb klasteri t\u00eb dedikuar. P\u00ebr shembull, Commvault funksionon vet\u00ebm me nj\u00eb klaster dy-nod\u00ebsh, ku Primary dhe Secondary jan\u00eb t\u00eb ngjitura fort pas nodave t\u00eb caktuar. Dhe ka kuptim t\u00eb b\u00ebsh backup vet\u00ebm nga Primary, sepse kopjimi i rezerv\u00ebs nga Secondary ka kufizimet e veta. P\u00ebr shkak t\u00eb ve\u00e7orive t\u00eb DBMS-s\u00eb, dump-i n\u00eb Secondary nuk krijohet, prandaj mbetet vet\u00ebm opsioni i backup-it t\u00eb skedar\u00ebve.<\/p>\n<p>P\u00ebr t\u00eb ulur rrezikun e ndalesave, gjat\u00eb krijimit t\u00eb nj\u00eb sistemi me q\u00ebndrim t\u00eb q\u00ebndruesh\u00ebm formohet nj\u00eb konfigurim klaster \u2018t\u00eb gjall\u00eb\u2019, dhe Primary mund t\u00eb migroj\u00eb gradualisht midis server\u00ebve t\u00eb ndrysh\u00ebm. P\u00ebr shembull, softueri Patroni aktivizon automatikisht Primary n\u00eb nj\u00eb nod t\u00eb zgjedhur rast\u00ebsisht t\u00eb klasterit. SRK nuk ka nj\u00eb m\u00ebnyr\u00eb p\u00ebr t\u00eb ndjekur k\u00ebt\u00eb \u2018nga kutia\u2019, dhe, n\u00ebse nd\u00ebrlikohet konfigurimi, proceset prishen. Pra, implementimi i menaxhimit t\u00eb jasht\u00ebm pengon SRK-t\u00eb q\u00eb t\u00eb funksionojn\u00eb efikas, sepse serveri menaxhues thjesht nuk kupton se nga ku dhe cilat t\u00eb dh\u00ebna duhet t\u00eb kopjohen.<\/p>\n<p>Nj\u00eb problem tjet\u00ebr \u00ebsht\u00eb implementimi i backup-it n\u00eb Postgres. Ai \u00ebsht\u00eb i mundur p\u00ebrmes dump-it, dhe n\u00eb bazat e dh\u00ebnave t\u00eb vogla funksionon. Por n\u00eb BD t\u00eb m\u00ebdha, dump-i b\u00ebhet ngadal\u00eb, k\u00ebrkon shum\u00eb burime dhe mund t\u00eb \u00e7oj\u00eb n\u00eb d\u00ebshtimin e instanc\u00ebs s\u00eb BD-s\u00eb.<\/p>\n<p>Backup-i i skedar\u00ebve e ndihmon situat\u00ebn, por n\u00eb bazat e m\u00ebdha ai realizohet ngadal\u00eb, sepse funksionon n\u00eb modin me nj\u00eb thread. P\u00ebr m\u00eb tep\u00ebr, p\u00ebr furnizuesit shfaqen nj\u00eb mori kufizimesh t\u00eb tjera. Nganj\u00ebher\u00eb nuk mund t\u00eb p\u00ebrdoren p\u00ebr nj\u00ebkoh\u00ebsisht backup-i i skedar\u00ebve dhe dump-i, ndonj\u00ebher\u00eb nuk mb\u00ebshtetet deduplication. Problematika \u00ebsht\u00eb e madhe, dhe shpesh her\u00eb \u00ebsht\u00eb m\u00eb e thjesht\u00eb t\u00eb zgjidhesh nj\u00eb DBMS t\u00eb shtrenjt\u00eb, por t\u00eb provuar se sa t\u00eb p\u00ebrdor\u00ebsh Postgres.<\/p>\n<h2>Nuk ka ku t\u00eb kthehemi! Pas nesh jan\u00eb zhvilluesit e Mosk\u00ebs!<\/h2>\n<p>\nMegjithat\u00eb, koh\u00ebt e fundit ekipi yn\u00eb u p\u00ebrball me nj\u00eb sfid\u00eb t\u00eb v\u00ebshtir\u00eb: n\u00eb projektin p\u00ebr krijimin e AIS OSAGO 2.0, ku ne po krijonim infrastruktur\u00ebn IT, zhvilluesit p\u00ebr sistemin e ri zgjodh\u00ebn PostgreSQL. <\/p>\n<p>P\u00ebr zhvilluesit e m\u00ebdhenj t\u00eb softuerit, \u00ebsht\u00eb shum\u00eb m\u00eb e leht\u00eb t\u00eb p\u00ebrdorin zgjidhje \u2018moderne\u2019 open-source. N\u00eb stafin e Facebook-ut ka mjaft specialist\u00eb q\u00eb mb\u00ebshtesin pun\u00ebn e k\u00ebtij DBMS. N\u00eb rastin e RSA, t\u00eb gjitha detyrat e \u2018dit\u00ebs s\u00eb dyt\u00eb\u2019 ran\u00eb mbi supet tona. Na nevojitej t\u00eb siguronim q\u00ebndrueshm\u00ebrin\u00eb, t\u00eb krijonim klasterin dhe, sigurisht, t\u00eb rregullonim backup-in. Logjika e veprimit ishte k\u00ebshtu: <\/p>\n<ul>\n<li>T\u00eb m\u00ebsojm\u00eb SRK-n\u00eb t\u00eb krijoj\u00eb kopje rezerv\u00eb nga nodi Kryesor i klasterit. P\u00ebr k\u00ebt\u00eb, SRK-ja duhet ta gjej\u00eb at\u00eb \u2014 k\u00ebshtu q\u00eb \u00ebsht\u00eb e nevojshme nj\u00eb integrim me nj\u00eb zgjidhje p\u00ebr menaxhimin e klasterit PostgreSQL. N\u00eb rastin e RSA-s, p\u00ebr k\u00ebt\u00eb ishte p\u00ebrdorur software-i Patroni.<\/li>\n<li>T\u00eb p\u00ebrcaktojm\u00eb llojin e kopjes rezerv\u00eb, duke u mb\u00ebshtetur n\u00eb volumin e t\u00eb dh\u00ebnave dhe k\u00ebrkesat p\u00ebr rivendosje. P\u00ebr shembull, kur k\u00ebrkohet rikthimi i faqeve n\u00eb m\u00ebnyr\u00eb granulare, p\u00ebrdoret dump-i, dhe n\u00ebse bazat jan\u00eb t\u00eb m\u00ebdha dhe rikthimi granular nuk nevojitet \u2014 punojm\u00eb n\u00eb nivelin e skedar\u00ebve.<\/li>\n<li>T\u00eb shtojm\u00eb n\u00eb zgjidhje mund\u00ebsin\u00eb e kopjes rezerv\u00eb bllokuese, q\u00eb t\u00eb krijojm\u00eb kopje rezerv\u00eb n\u00eb m\u00ebnyr\u00eb multi-thread.<\/li>\n<\/ul>\n<p>\nMegjithat\u00eb, fillimisht ne pat\u00ebm si q\u00ebllim t\u00eb krijonim nj\u00eb sistem efektiv dhe t\u00eb thjesht\u00eb pa mb\u00ebshtetje monstruoze nga komponent\u00eb t\u00eb tjer\u00eb. Sa m\u00eb pak mb\u00ebshtetje, aq m\u00eb pak ngarkes\u00eb p\u00ebr stafin dhe rreziku m\u00eb i ul\u00ebt i d\u00ebshtimit t\u00eb SRK-s\u00eb. Qasjet q\u00eb p\u00ebrfshinin Veeam dhe RMAN, i p\u00ebrjashtuam menj\u00ebher\u00eb, sepse kompleti i dy zgjidhjeve sugjeron already nj\u00eb sistem t\u00eb pasigurt.<\/p>\n<h2>Pak magji p\u00ebr enterprise<\/h2>\n<p>\nPra, na duhej t\u00eb garantonim nj\u00eb kopje rezerv\u00eb t\u00eb besueshme p\u00ebr 10 klastera me nga 3 node secili, p\u00ebr m\u00eb tep\u00ebr, n\u00eb Qendr\u00ebn e Dh\u00ebnash rezerv\u00eb \u00ebsht\u00eb nd\u00ebrtuar nj\u00eb infrastruktur\u00eb identike. Qendrat e t\u00eb Dh\u00ebnave n\u00eb aspektin e PostgreSQL punojn\u00eb sipas parimit aktiv-pasiv. V\u00ebllimi i p\u00ebrgjithsh\u00ebm i bazave t\u00eb t\u00eb dh\u00ebnave ishte 50 TB. \u00c7do SRK e nivelit t\u00eb korporatave mund ta p\u00ebrballoj\u00eb at\u00eb leht\u00ebsisht. Por thelbi \u00ebsht\u00eb se fillimisht n\u00eb Postgres nuk ka asnj\u00eb lidhje p\u00ebr compatibilitetin e plot\u00eb dhe t\u00eb thell\u00eb me sistemet e kopjes rezerv\u00eb. Prandaj, na duhej t\u00eb k\u00ebrkonim nj\u00eb zgjidhje q\u00eb fillimisht kishte maksimumin e funksionalitetit n\u00eb lidhje me PostgreSQL, dhe ta p\u00ebrmir\u00ebsonim sistemin. <\/p>\n<p>Ne organizuam 3 \u00abhackathons\u00bb t\u00eb brendsh\u00ebm \u2014 shqyrtuam m\u00eb shum\u00eb se nj\u00eb gjysm\u00eb m\u00eb shum\u00eb angazhimesh, i testuam ato, b\u00ebm\u00eb ndryshime sipas hipotezave tona dhe i verifikonim p\u00ebrs\u00ebri. Pas analizimit t\u00eb opsioneve t\u00eb disponueshme, ne zgjodh\u00ebm Commvault. Ky produkt mund t\u00eb punonte \u00abnga kutia\u00bb me nj\u00eb instalim t\u00eb thjesht\u00eb t\u00eb klasterit PostgreSQL, dhe arkitektura e tij e hapur krijoi shpres\u00eb (e cila u realizua) p\u00ebr nj\u00eb p\u00ebrmir\u00ebsim dhe integrim t\u00eb suksessh\u00ebm. Po ashtu, Commvault dinte t\u00eb b\u00ebnte kopje rezerv\u00eb t\u00eb regjistrimeve t\u00eb PostgreSQL. P\u00ebr shembull, Veritas NetBackup n\u00eb lidhje me PostgreSQL di vet\u00ebm t\u00eb kryej\u00eb kopje rezerv\u00eb t\u00eb plota.<\/p>\n<p>M\u00eb shum\u00eb mbi arkitektur\u00ebn. Server\u00ebt menaxhues t\u00eb Commvault jan\u00eb vendosur n\u00eb secil\u00ebn nga dy qendrat e t\u00eb dh\u00ebnave n\u00eb konfigurimin CommServ HA. Sistemi \u00ebsht\u00eb i miratuar, menaxhohet p\u00ebrmes nj\u00eb konsol\u00eb dhe nga pik\u00ebpamja e HA p\u00ebrmbush t\u00eb gjitha k\u00ebrkesat e nd\u00ebrmarrjeve.<\/p>\n<p><img decoding=\"async\" alt=\"Si t\u00eb integrosh PostgreSQL &#039;t\u00eb lir\u00eb&#039; n\u00eb nj\u00eb mjedis t\u00eb ashp\u00ebr enterprise\" src=\"\/wp-content\/uploads\/2020\/09\/461b05425385435fee233846516e328d.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nPo ashtu, n\u00eb secil\u00ebn qend\u00ebr t\u00eb t\u00eb dh\u00ebnave kemi nisur nga dy servera fizik\u00eb t\u00eb mediave, t\u00eb cil\u00ebt jan\u00eb lidhur p\u00ebrmes SAN p\u00ebrmes Fibre Channel me sisteme diskesh dhe biblioteka kasetash t\u00eb dedikuara ve\u00e7mas p\u00ebr backup. Bazat e shp\u00ebrndara t\u00eb deduplikimit siguruan q\u00eb media-server\u00ebt t\u00eb ishin t\u00eb q\u00ebndruesh\u00ebm ndaj d\u00ebshtimit, dhe lidhja e \u00e7do serveri me \u00e7do CSV mund\u00ebsoi vazhdim\u00ebsin\u00eb e funksionit n\u00eb rast se ndonj\u00eb komponent d\u00ebshton. Arkitektura e sistemit leht\u00ebson kopjimin e rezerv\u00ebs, edhe n\u00ebse ndonj\u00eb nga qendrat e t\u00eb dh\u00ebnave d\u00ebshtojn\u00eb.<\/p>\n<p>Patroni p\u00ebrcakton nod\u00ebn kryesore p\u00ebr \u00e7do klaster. Ajo mund t\u00eb jet\u00eb \u00e7far\u00ebdo nod\u00eb t\u00eb lir\u00eb n\u00eb qendr\u00ebn e t\u00eb dh\u00ebnave \u2014 por vet\u00ebm n\u00eb ato kryesore. N\u00eb ato rezerv\u00eb, t\u00eb gjitha nodat jan\u00eb Sekondare. <\/p>\n<p>Q\u00eb Commvault t\u00eb kuptonte se cila nod\u00eb e klasterit \u00ebsht\u00eb Kryesore, ne integrom\u00eb sistemin (fal\u00eb arkitektur\u00ebs s\u00eb hapur t\u00eb zgjidhjes) me Postgres. P\u00ebr k\u00ebt\u00eb \u00ebsht\u00eb krijuar nj\u00eb skenar q\u00eb njofton p\u00ebr vendndodhjen aktuale t\u00eb nod\u00ebs Kryesore menaxhuesin. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/dts-shicago\/\"   title=\"\u0441\u0435\u0440\u0432\u0435\u0440\u0443\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"2881\">\u0441\u0435\u0440\u0432\u0435\u0440\u0443<\/a> Commvault.<\/p>\n<p>N\u00eb p\u00ebrgjith\u00ebsi, procesi duket k\u00ebshtu:<\/p>\n<p>Patroni zgjedh Kryesoren \u2192 Keepalived ndez IP-klasterin dhe fillon skenarin \u2192 agjenti Commvault n\u00eb nod\u00ebn e zgjedhur t\u00eb klasterit merr njoftimin se kjo \u00ebsht\u00eb Kryesore \u2192 Commvault automatikisht rikonfiguron backupin brenda pseudoklientit.<\/p>\n<p><img decoding=\"async\" alt=\"Si t\u00eb integrosh PostgreSQL &#039;t\u00eb lir\u00eb&#039; n\u00eb nj\u00eb mjedis t\u00eb ashp\u00ebr enterprise\" src=\"\/wp-content\/uploads\/2020\/09\/a3d909bdff1c219fd98cc49cf3054a23.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nP\u00ebrpar\u00ebsia e k\u00ebtij qasjes \u00ebsht\u00eb se zgjidhja nuk ndikon as n\u00eb konsistenc\u00ebn, as n\u00eb korrekt\u00ebsin\u00eb e logeve, as n\u00eb rikuperimin e instanc\u00ebs s\u00eb Postgres. Ajo gjithashtu leht\u00ebsohet p\u00ebr t'u shkall\u00ebzuar, pasi tani nuk \u00ebsht\u00eb e nevojshme t\u00eb regjistrohen p\u00ebr Commvault nodat Kryesore dhe Sekondare. Mjafton q\u00eb sistemi t\u00eb kuptoj\u00eb se ku \u00ebsht\u00eb Kryesore dhe numri i nyjeve mund t\u00eb rritet praktikisht n\u00eb \u00e7do vler\u00eb.<\/p>\n<p>Zgjidhja nuk pretendon t\u00eb jet\u00eb e p\u00ebrsosur dhe ka nuanca t\u00eb saj. Commvault di t\u00eb b\u00ebj\u00eb backup vet\u00ebm t\u00eb instanc\u00ebs s\u00eb plot\u00eb, jo t\u00eb bazave t\u00eb ve\u00e7anta. Prandaj p\u00ebr \u00e7do DB \u00ebsht\u00eb krijuar nj\u00eb instanc\u00eb t\u00eb ve\u00e7ant\u00eb. Klient\u00ebt e v\u00ebrtet\u00eb jan\u00eb t\u00eb grupuar n\u00eb pseudoklient\u00eb virtual\u00eb. \u00c7do pseudoklient Commvault p\u00ebrb\u00ebn nj\u00eb klaster UNIX. N\u00eb t\u00eb shtohen ato nodat e klasterit, mbi t\u00eb cilat \u00ebsht\u00eb instaluar agjenti Commvault p\u00ebr Postgres. Si rezultat, t\u00eb gjitha nyjat virtuale t\u00eb pseudoklientit b\u00ebhen backup si nj\u00eb instanc\u00eb. <\/p>\n<p>Brenda \u00e7do pseudoklienti \u00ebsht\u00eb e sh\u00ebnuar nj\u00eb nod aktiv t\u00eb klasterit. Ky \u00ebsht\u00eb ai q\u00eb zgjidhja jon\u00eb integruese p\u00ebr Commvault e p\u00ebrcakton. Principi i funksionimit t\u00eb saj \u00ebsht\u00eb mjaft i thjesht\u00eb: n\u00ebse n\u00eb nod\u00eb ngrihet nj\u00eb IP klasteri, skripta vendos n\u00eb binarin e agentit Commvault parametrin \"nod aktiv\" \u2014 me t\u00eb v\u00ebrtet\u00eb skripta vendos \"1\" n\u00eb pjes\u00ebn e nevojshme t\u00eb memories. Agenti i d\u00ebrgon k\u00ebto t\u00eb dh\u00ebna n\u00eb CommServe dhe Commvault b\u00ebn backup nga nodi i nevojsh\u00ebm. M\u00eb tej, n\u00eb nivelin e skriptit kontrollohet sakt\u00ebsia e konfigurimit, duke ndihmuar n\u00eb shmangien e gabimeve gjat\u00eb lan\u00e7imit t\u00eb kopjimit rezerv\u00eb.<\/p>\n<p>N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, bazat e m\u00ebdha t\u00eb t\u00eb dh\u00ebnave rezervohen n\u00eb blloqe me disa rrjedha, duke p\u00ebrmbushur k\u00ebrkesat RPO dhe dritaren e kopjimit rezerv\u00eb. Ngarkesa n\u00eb sistem \u00ebsht\u00eb e pak\u00ebt: kopjet e plota nuk ndodhin shpesh, n\u00eb dit\u00ebt e tjera mblidhen vet\u00ebm loge, p\u00ebr m\u00eb tep\u00ebr n\u00eb periudhat e ngarkes\u00ebs s\u00eb ul\u00ebt. <\/p>\n<p>Tani, ne kemi aplikuar politika t\u00eb ve\u00e7anta p\u00ebr kopjimin e log-eve arkivore t\u00eb PostgreSQL \u2014 ato ruhen sipas rregullave t\u00eb tjera, kopjohen sipas nj\u00eb orari t\u00eb ndrysh\u00ebm dhe p\u00ebr to nuk aktivizohet deduplikimi, pasi k\u00ebto loge mbajn\u00eb t\u00eb dh\u00ebna unike.<\/p>\n<p>P\u00ebr t\u00eb siguruar konsistenc\u00ebn e t\u00ebr\u00eb infrastruktur\u00ebs IT, klient\u00eb t\u00eb ve\u00e7ant\u00eb t\u00eb Commvault jan\u00eb instaluar n\u00eb \u00e7do nod t\u00eb klasterit. Ata p\u00ebrjashtojn\u00eb nga kopjet rezerv\u00eb skedar\u00ebt Postgres dhe jan\u00eb t\u00eb dedikuar vet\u00ebm p\u00ebr backup t\u00eb OS-s\u00eb dhe aplikacioneve. P\u00ebr k\u00ebt\u00eb pjes\u00eb t\u00eb t\u00eb dh\u00ebnave \u00ebsht\u00eb parashikuar gjithashtu nj\u00eb politik\u00eb e saj, dhe nj\u00eb periudh\u00eb ruajtjeje. <\/p>\n<p><img decoding=\"async\" alt=\"Si t\u00eb integrosh PostgreSQL &#039;t\u00eb lir\u00eb&#039; n\u00eb nj\u00eb mjedis t\u00eb ashp\u00ebr enterprise\" src=\"\/wp-content\/uploads\/2020\/09\/80c74ee17f441308bd8c3b154c1acafc.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\nAktualisht SRK nuk ndikon n\u00eb sh\u00ebrbimet prodhuese, por n\u00ebse situata ndryshon, n\u00eb Commvault mund t\u00eb aktivizohet sistemi p\u00ebr kufizimin e ngarkes\u00ebs. <\/p>\n<p><strong>\u00cbsht\u00eb n\u00eb rregull? \u00cbsht\u00eb n\u00eb rregull!<\/strong><\/p>\n<p>Pra, ne kemi marr\u00eb jo vet\u00ebm nj\u00eb backup funksional, por gjithashtu nj\u00eb backup t\u00eb plot\u00eb t\u00eb automatizuar p\u00ebr instalimin e klasterit PostgreSQL, p\u00ebr m\u00eb tep\u00ebr q\u00eb i p\u00ebrmbush t\u00eb gjitha k\u00ebrkesat p\u00ebr sfidat enterprise.<\/p>\n<p>Parametrat RPO dhe RTO n\u00eb 1 or\u00eb dhe 2 or\u00eb jan\u00eb mbuluar me nj\u00eb rezerva, prandaj sistemi do t\u00eb p\u00ebrmbush\u00eb ato edhe n\u00eb rritjen e konsiderueshme t\u00eb volumit t\u00eb t\u00eb dh\u00ebnave t\u00eb ruajtura. Pavar\u00ebsisht nga shum\u00eb dyshime, PostgreSQL dhe ambienti enterprise rezultuan t\u00eb jen\u00eb t\u00eb p\u00ebrputhsh\u00ebm. Dhe tani ne nga eksperienca jona dim\u00eb se backup-i p\u00ebr t\u00eb tilla DBMS \u00ebsht\u00eb i mundur n\u00eb konfiguracione shum\u00eb t\u00eb ndryshme. <\/p>\n<p>Sigurisht, n\u00eb k\u00ebt\u00eb rrug\u00eb na duhej t\u00eb konsumonim shtat\u00eb pal\u00eb \u00e7izme hekuri, t\u00eb kalonim nj\u00eb s\u00ebr\u00eb v\u00ebshtir\u00ebsish, t\u00eb hidheshim mbi disa gure dhe t\u00eb korrigjonim nj\u00eb sasi t\u00eb caktuar gabimesh. Por tani metoda tashm\u00eb \u00ebsht\u00eb provuar dhe mund t\u00eb aplikohet p\u00ebr implementimin e Open Source n\u00eb vend t\u00eb DBMS-ve pron\u00ebsor n\u00eb kushtet e ashpra t\u00eb enterprise.<\/p>\n<p>A e keni provuar t\u00eb punoni me PostgreSQL n\u00eb nj\u00eb mjedis t\u00eb korporat\u00ebs?<\/p>\n<p><i>Autor\u00ebt: <\/i><\/p>\n<p><i>Oleg Lavrenov, inxhinier i sistemit t\u00eb projektimit t\u00eb ruajtjes s\u00eb t\u00eb dh\u00ebnave \u00abInfosisitemes Jet\u00bb<\/i><\/p>\n<p><i>Dmitry Yerikin, inxhinier i projektimit t\u00eb komplekseve kompjuterike \u00abInfosisitemes Jet\u00bb<\/i><br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/jetinfosystems\/blog\/518384\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041c\u043d\u043e\u0433\u0438\u0435 \u0437\u043d\u0430\u043a\u043e\u043c\u044b \u0441 \u0421\u0423\u0411\u0414 PostgreSQL, \u0438 \u043e\u043d\u0430 \u043e\u0442\u043b\u0438\u0447\u043d\u043e \u0437\u0430\u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043b\u0430 \u0441\u0435\u0431\u044f \u043d\u0430 \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0438\u043d\u0441\u0442\u0430\u043b\u043b\u044f\u0446\u0438\u044f\u0445. \u041e\u0434\u043d\u0430\u043a\u043e \u0442\u0435\u043d\u0434\u0435\u043d\u0446\u0438\u044f \u043a \u043f\u0435\u0440\u0435\u0445\u043e\u0434\u0443 \u043d\u0430 Open Source \u0441\u0442\u0430\u043b\u0430 \u0432\u0441\u0435 \u0431\u043e\u043b\u0435\u0435 \u044f\u0432\u043d\u043e\u0439, \u0434\u0430\u0436\u0435 \u043a\u043e\u0433\u0434\u0430 \u0440\u0435\u0447\u044c \u0438\u0434\u0435\u0442 \u043e \u043a\u0440\u0443\u043f\u043d\u044b\u0445 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u044f\u0445 \u0438 enterprise \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f\u0445. \u0412 \u044d\u0442\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u0435 \u043c\u044b \u0440\u0430\u0441\u0441\u043a\u0430\u0436\u0435\u043c, \u043a\u0430\u043a \u0432\u0441\u0442\u0440\u043e\u0438\u0442\u044c Postgres \u0432 \u043a\u043e\u0440\u043f\u043e\u0440\u0430\u0442\u0438\u0432\u043d\u0443\u044e \u0441\u0440\u0435\u0434\u0443, \u0438 \u043f\u043e\u0434\u0435\u043b\u0438\u043c\u0441\u044f \u043e\u043f\u044b\u0442\u043e\u043c \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0440\u0435\u0437\u0435\u0440\u0432\u043d\u043e\u0433\u043e \u043a\u043e\u043f\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f (\u0421\u0420\u041a) \u0434\u043b\u044f \u044d\u0442\u043e\u0439 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":93879,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-93878","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041c\u043d\u043e\u0433\u0438\u0435 \u0437\u043d\u0430\u043a\u043e\u043c\u044b \u0441 \u0421\u0423\u0411\u0414 PostgreSQL, \u0438 \u043e\u043d\u0430 \u043e\u0442\u043b\u0438\u0447\u043d\u043e \u0437\u0430\u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043b\u0430 \u0441\u0435\u0431\u044f \u043d\u0430 \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0438\u043d\u0441\u0442\u0430\u043b\u043b\u044f\u0446\u0438\u044f\u0445.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-vpisat-svobodnuyu-postgresql-v-surovoe-enterprise-okruzhenie\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041a\u0430\u043a \u0432\u043f\u0438\u0441\u0430\u0442\u044c \u00ab\u0441\u0432\u043e\u0431\u043e\u0434\u043d\u0443\u044e\u00bb PostgreSQL \u0432 \u0441\u0443\u0440\u043e\u0432\u043e\u0435 enterprise \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041c\u043d\u043e\u0433\u0438\u0435 \u0437\u043d\u0430\u043a\u043e\u043c\u044b \u0441 \u0421\u0423\u0411\u0414 PostgreSQL, \u0438 \u043e\u043d\u0430 \u043e\u0442\u043b\u0438\u0447\u043d\u043e \u0437\u0430\u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043b\u0430 \u0441\u0435\u0431\u044f \u043d\u0430 \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0438\u043d\u0441\u0442\u0430\u043b\u043b\u044f\u0446\u0438\u044f\u0445.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-vpisat-svobodnuyu-postgresql-v-surovoe-enterprise-okruzhenie\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-09-10T17:42:02+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-09-10T17:42:02+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Si ta integroni PostgreSQL \"t\u00eb lir\u00eb\" n\u00eb nj\u00eb mjedis t\u00eb ashp\u00ebr enterprise | ProHoster","description":"Shum\u00eb jan\u00eb t\u00eb njohur me DBMS PostgreSQL, dhe ajo ka treguar performanc\u00eb t\u00eb shk\u00eblqyer n\u00eb instalime t\u00eb vogla.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-vpisat-svobodnuyu-postgresql-v-surovoe-enterprise-okruzhenie","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041a\u0430\u043a \u0432\u043f\u0438\u0441\u0430\u0442\u044c \u00ab\u0441\u0432\u043e\u0431\u043e\u0434\u043d\u0443\u044e\u00bb PostgreSQL \u0432 \u0441\u0443\u0440\u043e\u0432\u043e\u0435 enterprise \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u0435 | ProHoster","og:description":"\u041c\u043d\u043e\u0433\u0438\u0435 \u0437\u043d\u0430\u043a\u043e\u043c\u044b \u0441 \u0421\u0423\u0411\u0414 PostgreSQL, \u0438 \u043e\u043d\u0430 \u043e\u0442\u043b\u0438\u0447\u043d\u043e \u0437\u0430\u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u043e\u0432\u0430\u043b\u0430 \u0441\u0435\u0431\u044f \u043d\u0430 \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u0438\u0445 \u0438\u043d\u0441\u0442\u0430\u043b\u043b\u044f\u0446\u0438\u044f\u0445.","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-vpisat-svobodnuyu-postgresql-v-surovoe-enterprise-okruzhenie","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-09-10T17:42:02+00:00","article:modified_time":"2020-09-10T17:42:02+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"93878","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 11:38:42","updated":"2026-02-09 21:41:55","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/93878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=93878"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/93878\/revisions"}],"predecessor-version":[{"id":160161,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/93878\/revisions\/160161"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/93879"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=93878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=93878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=93878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}