{"id":94417,"date":"2020-09-16T19:42:31","date_gmt":"2020-09-16T17:42:31","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s"},"modified":"2020-09-16T19:42:31","modified_gmt":"2020-09-16T17:42:31","slug":"u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s","title":{"rendered":"Kemi atje Postgres, por nuk kam iden\u00eb se \u00e7far\u00eb t\u00eb b\u00ebj me t\u00eb (c)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Kjo \u00ebsht\u00eb nj\u00eb citat nga nj\u00eb mik i imi q\u00eb dikur m\u00eb ka b\u00ebr\u00eb nj\u00eb pyetje p\u00ebr Postgres. At\u00ebher\u00eb ne zgjidh\u00ebm problemin e tij p\u00ebr disa dit\u00eb dhe pasi m\u00eb fal\u00ebnderoi, ai shtoi: \u00abI mir\u00eb, kur ke nj\u00eb DBA t\u00eb njohur\u00bb.<\/p>\n<p>Por \u00e7far\u00eb t\u00eb b\u00ebsh n\u00ebse s'ke nj\u00eb DBA njohur? Ka shum\u00eb mund\u00ebsi p\u00ebrgjigjeje, filluaj nga k\u00ebrkimi midis miqve t\u00eb miqve dhe deri te studimi i \u00e7\u00ebshtjeve vet\u00eb. Por \u00e7far\u00ebdo p\u00ebrgjigje q\u00eb t\u00eb vij\u00eb n\u00eb mendje, kam nj\u00eb lajm t\u00eb mir\u00eb p\u00ebr ju. N\u00eb modulin e prov\u00ebs kemi lanzuar nj\u00eb sh\u00ebrbim rekomandimesh p\u00ebr Postgres dhe gjith\u00e7ka q\u00eb e rrethon at\u00eb. \u00c7far\u00eb \u00ebsht\u00eb kjo dhe si arrit\u00ebm deri k\u00ebtu?<\/p>\n<h2>P\u00ebrse \u00ebsht\u00eb e gjitha kjo?<\/h2>\n<p>Postgres \u00ebsht\u00eb, t\u00eb pakt\u00ebn, jo vet\u00ebm i thjesht\u00eb, por ndonj\u00ebher\u00eb edhe shum\u00eb i komplikuar. Varet nga niveli i angazhimit dhe p\u00ebrgjegj\u00ebsis\u00eb.<\/p>\n<p>Ata q\u00eb jan\u00eb n\u00eb operacione duhet t\u00eb ndjekin q\u00eb Postgres si sh\u00ebrbim t\u00eb punoj\u00eb pa probleme dhe me stabilitet \u2014 t\u00eb monitorojn\u00eb shfryt\u00ebzimin e burimeve, aksesin, konfiguarcionin e duhur, t\u00eb kryejn\u00eb p\u00ebrdit\u00ebsime periodike dhe kontrolle t\u00eb sh\u00ebndetit. Ata q\u00eb jan\u00eb n\u00eb zhvillim dhe shkruajn\u00eb aplikacione, n\u00eb p\u00ebrmasa t\u00eb gjera, duhet t\u00eb ndjekin se si aplikacioni interuon me baz\u00ebn e t\u00eb dh\u00ebnave dhe se nuk krijon situata emergjente q\u00eb mund t\u00eb \u00e7ojn\u00eb n\u00eb \u00e7arjen e baz\u00ebs. N\u00ebse dikujt nuk i ka shkuar mir\u00eb aq sa t\u00eb jet\u00eb udh\u00ebheq\u00ebsi teknik, \u00ebsht\u00eb e r\u00ebnd\u00ebsishme q\u00eb Postgres n\u00eb p\u00ebrgjith\u00ebsi t\u00eb funksionoj\u00eb me besueshm\u00ebri, parashikueshm\u00ebri dhe t\u00eb mos krijoj\u00eb probleme, dhe \u00ebsht\u00eb e d\u00ebshirueshme q\u00eb t\u00eb mos merret shum\u00eb thell\u00eb me Postgres.<\/p>\n<p>N\u00eb \u00e7do rast, je ti dhe Postgres. P\u00ebr t\u00eb sh\u00ebrbyer mir\u00eb Postgres-in duhet t\u00eb kesh nj\u00eb njohuri t\u00eb mir\u00eb mbi t\u00eb dhe t\u00eb kuptosh se si funksionon. N\u00ebse Postgres nuk \u00ebsht\u00eb specializimi yt i drejtp\u00ebrdrejt\u00eb, \u00ebsht\u00eb e mundur t\u00eb harxhosh shum\u00eb koh\u00eb p\u00ebr ta studiuar at\u00eb. N\u00eb nj\u00eb rast ideal, kur ke koh\u00eb dhe d\u00ebshir\u00eb, nuk \u00ebsht\u00eb gjithmon\u00eb e qart\u00eb se nga duhet t\u00eb fillosh, si dhe drejtim duhet t\u00eb marr\u00ebsh.<\/p>\n<p>Edhe n\u00ebse rrethohesh me nj\u00eb monitorim q\u00eb teorikisht duhet ta leht\u00ebsoj\u00eb funksionimin, pyetja p\u00ebr njohurit\u00eb ekspert \u00ebsht\u00eb akoma n\u00eb aj\u00ebr. P\u00ebr t\u00eb qen\u00eb n\u00eb gjendje t\u00eb lexosh dhe t\u00eb kuptosh grafiket, \u00ebsht\u00eb e domosdoshme t\u00eb kesh nj\u00eb pasqyr\u00eb t\u00eb mir\u00eb se si funksionon Postgres. Ndryshe, \u00e7do monitorim shnd\u00ebrrohet n\u00eb figura t\u00eb trishtueshme dhe spame nga alertrat n\u00eb raste rast\u00ebsore gjat\u00eb nat\u00ebs.<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/weaponry.io\">Weaponry<\/a><\/noindex> \u00ebsht\u00eb krijuar pik\u00ebrisht p\u00ebr t\u00eb leht\u00ebsuar funksionimin e Postgres. Sh\u00ebrbimi mbledh dhe analizon t\u00eb dh\u00ebnat mbi Postgres dhe jep rekomandime p\u00ebr at\u00eb q\u00eb mund t\u00eb p\u00ebrmir\u00ebsohet. <\/p>\n<p><em>Q\u00ebllimi kryesor i sh\u00ebrbimit \u00ebsht\u00eb t\u00eb ofroj\u00eb rekomandime t\u00eb kuptueshme, q\u00eb japin nj\u00eb ide se \u00e7far\u00eb po ndodh dhe \u00e7far\u00eb duhet t\u00eb b\u00ebhet m\u00eb pas.<\/em> <\/p>\n<p>P\u00ebr specialist\u00ebt q\u00eb nuk kan\u00eb njohuri ekspert\u00ebsh, rekomandimet ofrojn\u00eb nj\u00eb pik\u00ebnisje p\u00ebr p\u00ebrmir\u00ebsimin e aft\u00ebsive. P\u00ebr specialist\u00ebt e avancuar, rekomandimet tregojn\u00eb pikat q\u00eb duhet t\u00eb ken\u00eb parasysh. N\u00eb k\u00ebt\u00eb plan, Weaponry vepron si nj\u00eb ndihm\u00ebs q\u00eb kryen detyra rutinore p\u00ebr identifikimin e problemeve ose mang\u00ebsive q\u00eb k\u00ebrkojn\u00eb v\u00ebmendje t\u00eb ve\u00e7ant\u00eb. Weaponry mund t\u00eb krahasohet me nj\u00eb linte q\u00eb kontrollon Postgres dhe tregon p\u00ebr mang\u00ebsit\u00eb.<\/p>\n<h2>Si si ndodhin gj\u00ebrat tani<\/h2>\n<p>Aktualisht <noindex><a rel=\"nofollow\" href=\"https:\/\/weaponry.io\">Weaponry<\/a><\/noindex> \u00ebsht\u00eb n\u00eb faz\u00eb prove dhe p\u00ebr hulumtime falas, regjistrimi \u00ebsht\u00eb p\u00ebrkoh\u00ebsisht i kufizuar. Duke punuar me disa vullnetar\u00eb, po p\u00ebrmir\u00ebsojm\u00eb motorin e rekomandimeve n\u00eb baza praktike, po identifikojm\u00eb falsifikimet dhe po punojm\u00eb n\u00eb tekstin e rekomandimeve. <\/p>\n<p>T\u00eb them t\u00eb drejten, rekomandimet p\u00ebr momentin jan\u00eb mjaft t\u00eb drejtp\u00ebrdrejta \u2014 thjesht thon\u00eb se \u00e7far\u00eb dhe si t\u00eb b\u00ebni, pa detaje shtes\u00eb \u2014 k\u00ebshtu q\u00eb n\u00eb fillim do t\u00eb duhet t\u00eb kaloni tek lidhjet p\u00ebrkat\u00ebse ose t\u00eb k\u00ebrkoni m\u00eb shum\u00eb. Kontrollimet dhe rekomandimet mbulojn\u00eb konfigurimet e sistemit dhe pajisjeve, konfigurimin e Postgres, skem\u00ebn e brendshme, burimet e p\u00ebrdorura. N\u00eb plan jan\u00eb gjithashtu shum\u00eb gj\u00ebra q\u00eb duhet t\u00eb shtohen. <\/p>\n<p>Sigurisht, ne po k\u00ebrkojm\u00eb vullnetar\u00eb q\u00eb jan\u00eb t\u00eb gatsh\u00ebm t\u00eb provojn\u00eb sh\u00ebrbimin dhe t\u00eb japin feedback. Po ashtu kemi <noindex><a rel=\"nofollow\" href=\"https:\/\/demo.weaponry.io\">demo<\/a><\/noindex>, mund t\u00eb hyni dhe t\u00eb shikoni. N\u00ebse e kuptoni q\u00eb ju nevojitet dhe jeni t\u00eb gatsh\u00ebm ta provoni, na shkruani n\u00eb <noindex><a rel=\"nofollow\" href=\"mailto:team@weaponry.io\">email<\/a><\/noindex>.<\/p>\n<h2>E p\u00ebrdit\u00ebsuar 2020-09-16. Si t\u00eb filloni.<\/h2>\n<p>Pas regjistrimit, p\u00ebrdoruesit iu ofrohet krijimi i nj\u00eb projekti \u2014 q\u00eb lejon grupimin e instancave t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Pas krijimit t\u00eb projektit, p\u00ebrdoruesi drejtohet n\u00eb udh\u00ebzimin p\u00ebr konfigurimin dhe instalimin e agentit. N\u00ebse e p\u00ebrmbledhim, duhet t\u00eb krijoni p\u00ebrdorues p\u00ebr agjentin, pastaj t\u00eb shkarkoni skenarin e instalimit t\u00eb agjentit dhe ta ekzekutoni at\u00eb. N\u00eb komandat shell, kjo duket p\u00ebraf\u00ebrsisht k\u00ebshtu:<\/p>\n<pre><code>psql -c \"CREATE ROLE pgscv WITH LOGIN SUPERUSER PASSWORD 'A7H8Wz6XFMh21pwA'\"\nexport PGSCV_PG_PASSWORD=A7H8Wz6XFMh21pwA\ncurl -s https:\/\/dist.weaponry.io\/pgscv\/install.sh |sudo -E sh -s - 1 6ada7a04-a798-4415-9427-da23f72c14a5<\/code><\/pre>\n<p>N\u00ebse n\u00eb host ka pgbouncer, p\u00ebr t'u lidhur me agjentin gjithashtu do t\u00eb duhet t\u00eb krijoni nj\u00eb p\u00ebrdorues. M\u00ebnyra specifike e konfigurimit t\u00eb p\u00ebrdoruesit n\u00eb pgbouncer mund t\u00eb jet\u00eb shum\u00eb variabile dhe varet shum\u00eb nga konfigurimi q\u00eb p\u00ebrdoret. N\u00eb p\u00ebrmbledhje, konfigurimi p\u00ebrfshin shtimin e p\u00ebrdoruesit n\u00eb <em>stats_users<\/em> file konfiguruese (zakonisht \u00ebsht\u00eb <em>pgbouncer.ini<\/em>) dhe shkruajtjen e fjal\u00ebkalimit (ose hashes t\u00eb tij) n\u00eb skedarin e specifikuar n\u00eb parametrin <em>auth_file.<\/em> Kur ndryshoni stats_users, do t\u00eb nevojitet rindizja e pgbouncer.<\/p>\n<p>Skenari install.sh merr disa argumente t\u00eb detyrueshme q\u00eb jan\u00eb unike p\u00ebr \u00e7do projekt dhe p\u00ebrmes variablave t\u00eb ambientit merr kredencialet e p\u00ebrdoruesve t\u00eb krijuar. Pastaj skenari nis agjentin n\u00eb modin bootstrap \u2014 agjenti kopjon veten n\u00eb PATH, krijon nj\u00eb konfigurim me kredencialet, nj\u00eb nj\u00ebs i systemd dhe niset si sh\u00ebrbim systemd. <br \/>K\u00ebtu p\u00ebrfundon instalimi. Brenda disa minutash, instanca e DB do t\u00eb shfaqet n\u00eb list\u00ebn e hosteve n\u00eb nd\u00ebrfaqe dhe mund t\u00eb shikoni rekomandimet e para. Por nj\u00eb pik\u00eb e r\u00ebnd\u00ebsishme, shum\u00eb rekomandime k\u00ebrkojn\u00eb nj\u00eb sasi t\u00eb madhe metricash t\u00eb grumbulluara (t\u00eb pakt\u00ebn p\u00ebr nj\u00eb dit\u00eb).<\/p>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/519240\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u042d\u0442\u043e \u0446\u0438\u0442\u0430\u0442\u0430 \u043e\u0434\u043d\u043e\u0433\u043e \u0438\u0437 \u043c\u043e\u0438\u0445 \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0445 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043a\u043e\u0433\u0434\u0430-\u0442\u043e \u0434\u0430\u0432\u043d\u043e \u043e\u0431\u0440\u0430\u0449\u0430\u043b\u0441\u044f \u043a\u043e \u043c\u043d\u0435 \u0441 \u0432\u043e\u043f\u0440\u043e\u0441\u043e\u043c \u043f\u0440\u043e Postgres. \u0422\u043e\u0433\u0434\u0430 \u043c\u044b \u0437\u0430 \u043f\u0430\u0440\u0443 \u0434\u043d\u0435\u0439 \u043f\u043e\u0440\u0435\u0448\u0430\u043b\u0438 \u0435\u0433\u043e \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0443 \u0438 \u043f\u043e\u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u0438\u0432 \u043c\u0435\u043d\u044f \u043e\u043d \u0434\u043e\u0431\u0430\u0432\u0438\u043b: &#171;\u0425\u043e\u0440\u043e\u0448\u043e, \u043a\u043e\u0433\u0434\u0430 \u0435\u0441\u0442\u044c \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0439 DBA&#187;. \u041d\u043e \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c \u0435\u0441\u043b\u0438 \u043d\u0435\u0442 \u0437\u043d\u0430\u043a\u043e\u043c\u043e\u0433\u043e DBA? \u0412\u0430\u0440\u0438\u0430\u043d\u0442\u043e\u0432 \u043e\u0442\u0432\u0435\u0442\u0430 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043c\u043d\u043e\u0433\u043e, \u043d\u0430\u0447\u0438\u043d\u0430\u044f \u043e\u0442 \u043f\u043e\u0438\u0441\u043a\u0430\u0442\u044c \u0441\u0440\u0435\u0434\u0438 \u0434\u0440\u0443\u0437\u0435\u0439 \u0434\u0440\u0443\u0437\u0435\u0439 \u0438 \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u044f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-94417","post","type-post","status-publish","format-standard","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u042d\u0442\u043e \u0446\u0438\u0442\u0430\u0442\u0430 \u043e\u0434\u043d\u043e\u0433\u043e \u0438\u0437 \u043c\u043e\u0438\u0445 \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0445 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043a\u043e\u0433\u0434\u0430-\u0442\u043e \u0434\u0430\u0432\u043d\u043e \u043e\u0431\u0440\u0430\u0449\u0430\u043b\u0441\u044f \u043a\u043e \u043c\u043d\u0435 \u0441 \u0432\u043e\u043f\u0440\u043e\u0441\u043e\u043c \u043f\u0440\u043e Postgres. \u0422\u043e\u0433\u0434\u0430 \u043c\u044b \u0437\u0430 \u043f\u0430\u0440\u0443 \u0434\u043d\u0435\u0439 \u043f\u043e\u0440\u0435\u0448\u0430\u043b\u0438 \u0435\u0433\u043e \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0443 \u0438 \u043f\u043e\u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u0438\u0432 \u043c\u0435\u043d\u044f \u043e\u043d \u0434\u043e\u0431\u0430\u0432\u0438\u043b: &quot;\u0425\u043e\u0440\u043e\u0448\u043e, \u043a\u043e\u0433\u0434\u0430 \u0435\u0441\u0442\u044c \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0439 DBA&quot;.\u041d\u043e \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c \u0435\u0441\u043b\u0438 \u043d\u0435\u0442 \u0437\u043d\u0430\u043a\u043e\u043c\u043e\u0433\u043e DBA? \u0412\u0430\u0440\u0438\u0430\u043d\u0442\u043e\u0432 \u043e\u0442\u0432\u0435\u0442\u0430 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043c\u043d\u043e\u0433\u043e, \u043d\u0430\u0447\u0438\u043d\u0430\u044f \u043e\u0442 \u043f\u043e\u0438\u0441\u043a\u0430\u0442\u044c \u0441\u0440\u0435\u0434\u0438 \u0434\u0440\u0443\u0437\u0435\u0439 \u0434\u0440\u0443\u0437\u0435\u0439 \u0438 \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u044f \u0434\u043e\" \/>\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\/u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\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\u0423 \u043d\u0430\u0441 \u0442\u0430\u043c Postgres, \u043d\u043e \u044f \u0445\u0437 \u0447\u0442\u043e \u0441 \u043d\u0438\u043c \u0434\u0435\u043b\u0430\u0442\u044c (\u0441) | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u042d\u0442\u043e \u0446\u0438\u0442\u0430\u0442\u0430 \u043e\u0434\u043d\u043e\u0433\u043e \u0438\u0437 \u043c\u043e\u0438\u0445 \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0445 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043a\u043e\u0433\u0434\u0430-\u0442\u043e \u0434\u0430\u0432\u043d\u043e \u043e\u0431\u0440\u0430\u0449\u0430\u043b\u0441\u044f \u043a\u043e \u043c\u043d\u0435 \u0441 \u0432\u043e\u043f\u0440\u043e\u0441\u043e\u043c \u043f\u0440\u043e Postgres. \u0422\u043e\u0433\u0434\u0430 \u043c\u044b \u0437\u0430 \u043f\u0430\u0440\u0443 \u0434\u043d\u0435\u0439 \u043f\u043e\u0440\u0435\u0448\u0430\u043b\u0438 \u0435\u0433\u043e \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0443 \u0438 \u043f\u043e\u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u0438\u0432 \u043c\u0435\u043d\u044f \u043e\u043d \u0434\u043e\u0431\u0430\u0432\u0438\u043b: &quot;\u0425\u043e\u0440\u043e\u0448\u043e, \u043a\u043e\u0433\u0434\u0430 \u0435\u0441\u0442\u044c \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0439 DBA&quot;.\u041d\u043e \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c \u0435\u0441\u043b\u0438 \u043d\u0435\u0442 \u0437\u043d\u0430\u043a\u043e\u043c\u043e\u0433\u043e DBA? \u0412\u0430\u0440\u0438\u0430\u043d\u0442\u043e\u0432 \u043e\u0442\u0432\u0435\u0442\u0430 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043c\u043d\u043e\u0433\u043e, \u043d\u0430\u0447\u0438\u043d\u0430\u044f \u043e\u0442 \u043f\u043e\u0438\u0441\u043a\u0430\u0442\u044c \u0441\u0440\u0435\u0434\u0438 \u0434\u0440\u0443\u0437\u0435\u0439 \u0434\u0440\u0443\u0437\u0435\u0439 \u0438 \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u044f \u0434\u043e\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s\" \/>\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-16T17:42:31+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-09-16T17:42:31+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\udd47Ne kemi Postgres, por nuk di \u00e7far\u00eb t\u00eb b\u00ebj me t\u00eb (c) | ProHoster","description":"Kjo \u00ebsht\u00eb nj\u00eb citat\u00eb nga nj\u00eb mik im q\u00eb nj\u00ebher\u00eb e kishte pyetur p\u00ebr Postgres. At\u00ebher\u00eb ne zgjidh\u00ebm problemin e tij p\u00ebr disa dit\u00eb dhe, pasi m\u00eb fal\u00ebnderoi, ai shtoi: \"Mir\u00eb \u00ebsht\u00eb kur ke nj\u00eb DBA t\u00eb njohur\". Por \u00e7far\u00eb t\u00eb b\u00ebsh n\u00ebse nuk ke nj\u00eb DBA t\u00eb njohur? Ka shum\u00eb mund\u00ebsi p\u00ebrgjigjeje, duke filluar nga t\u00eb k\u00ebrkosh mes miqve t\u00eb miqve dhe deri te","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s","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\u0423 \u043d\u0430\u0441 \u0442\u0430\u043c Postgres, \u043d\u043e \u044f \u0445\u0437 \u0447\u0442\u043e \u0441 \u043d\u0438\u043c \u0434\u0435\u043b\u0430\u0442\u044c (\u0441) | ProHoster","og:description":"\u042d\u0442\u043e \u0446\u0438\u0442\u0430\u0442\u0430 \u043e\u0434\u043d\u043e\u0433\u043e \u0438\u0437 \u043c\u043e\u0438\u0445 \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0445 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043a\u043e\u0433\u0434\u0430-\u0442\u043e \u0434\u0430\u0432\u043d\u043e \u043e\u0431\u0440\u0430\u0449\u0430\u043b\u0441\u044f \u043a\u043e \u043c\u043d\u0435 \u0441 \u0432\u043e\u043f\u0440\u043e\u0441\u043e\u043c \u043f\u0440\u043e Postgres. \u0422\u043e\u0433\u0434\u0430 \u043c\u044b \u0437\u0430 \u043f\u0430\u0440\u0443 \u0434\u043d\u0435\u0439 \u043f\u043e\u0440\u0435\u0448\u0430\u043b\u0438 \u0435\u0433\u043e \u043f\u0440\u043e\u0431\u043b\u0435\u043c\u0443 \u0438 \u043f\u043e\u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u0438\u0432 \u043c\u0435\u043d\u044f \u043e\u043d \u0434\u043e\u0431\u0430\u0432\u0438\u043b: &quot;\u0425\u043e\u0440\u043e\u0448\u043e, \u043a\u043e\u0433\u0434\u0430 \u0435\u0441\u0442\u044c \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0439 DBA&quot;.\u041d\u043e \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c \u0435\u0441\u043b\u0438 \u043d\u0435\u0442 \u0437\u043d\u0430\u043a\u043e\u043c\u043e\u0433\u043e DBA? \u0412\u0430\u0440\u0438\u0430\u043d\u0442\u043e\u0432 \u043e\u0442\u0432\u0435\u0442\u0430 \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043c\u043d\u043e\u0433\u043e, \u043d\u0430\u0447\u0438\u043d\u0430\u044f \u043e\u0442 \u043f\u043e\u0438\u0441\u043a\u0430\u0442\u044c \u0441\u0440\u0435\u0434\u0438 \u0434\u0440\u0443\u0437\u0435\u0439 \u0434\u0440\u0443\u0437\u0435\u0439 \u0438 \u0437\u0430\u043a\u0430\u043d\u0447\u0438\u0432\u0430\u044f \u0434\u043e","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/u-nas-tam-postgres-no-ya-hz-chto-s-nim-delat-s","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-16T17:42:31+00:00","article:modified_time":"2020-09-16T17:42:31+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"94417","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 10:49:20","updated":"2022-10-03 07:44:37"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/94417","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=94417"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/94417\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=94417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=94417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=94417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}