{"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 Postgres atje, por nuk e di \u00e7far\u00eb t\u00eb b\u00ebj me t\u00eb (c)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\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: «\u0425\u043e\u0440\u043e\u0448\u043e, \u043a\u043e\u0433\u0434\u0430 \u0435\u0441\u0442\u044c \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0439 DBA».<\/p>\n

Por \u00e7far\u00eb t\u00eb b\u00ebsh n\u00ebse nuk ke nj\u00eb DBA t\u00eb njohur? Mund\u00ebsit\u00eb e p\u00ebrgjigjjes mund t\u00eb jen\u00eb t\u00eb shumta, duke filluar nga t\u00eb k\u00ebrkosh mes miqve t\u00eb miqve dhe duke p\u00ebrfunduar me studimin e \u00e7\u00ebshtjes n\u00eb m\u00ebnyr\u00eb t\u00eb pavarur. Por \u00e7far\u00ebdo q\u00eb t\u00eb vij\u00eb n\u00eb mendje, kam nj\u00eb lajm t\u00eb mir\u00eb p\u00ebr ju. Ne kemi lan\u00e7uar 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 n\u00eb k\u00ebt\u00eb pik\u00eb.<\/p>\n

Pse e gjith\u00eb kjo?<\/h2>\n

Postgres \u00ebsht\u00eb t\u00eb pakt\u00ebn jo vet\u00ebm, por ndonj\u00ebher\u00eb edhe shum\u00eb i komplikuar. Varet nga niveli i angazhimit dhe p\u00ebrgjegj\u00ebsis\u00eb.<\/p>\n

\u0422\u0435\u043c \u043a\u0442\u043e \u0432 operations \u043d\u0443\u0436\u043d\u043e \u0441\u043b\u0435\u0434\u0438\u0442\u044c \u0437\u0430 \u0442\u0435\u043c \u0447\u0442\u043e\u0431 Postgres \u043a\u0430\u043a \u0441\u0435\u0440\u0432\u0438\u0441 \u0440\u0430\u0431\u043e\u0442\u0430\u043b \u0438\u0441\u043f\u0440\u0430\u0432\u043d\u043e \u0438 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u043e — \u0441\u043b\u0435\u0434\u0438\u0442\u044c \u0437\u0430 \u0443\u0442\u0438\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u0440\u0435\u0441\u0443\u0440\u0441\u043e\u0432, \u0437\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0441\u0442\u044c\u044e, \u0437\u0430 \u0430\u0434\u0435\u043a\u0432\u0430\u0442\u043d\u043e\u0441\u0442\u044c\u044e \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u0438, \u043f\u0435\u0440\u0438\u043e\u0434\u0438\u0447\u0435\u0441\u043a\u0438 \u043f\u0440\u043e\u0432\u043e\u0434\u0438\u0442\u044c \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u0440\u0435\u0433\u0443\u043b\u044f\u0440\u043d\u044b\u0435 \u043f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u0437\u0434\u043e\u0440\u043e\u0432\u044c\u044f. \u0422\u0435\u043c \u043a\u0442\u043e \u0432 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0435 \u0438 \u043f\u0438\u0448\u0435\u0442 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u044f, \u0432 \u043e\u0431\u0449\u0438\u0445 \u0447\u0435\u0440\u0442\u0430\u0445 \u043d\u0443\u0436\u043d\u043e \u0441\u043b\u0435\u0434\u0438\u0442\u044c \u0437\u0430 \u0442\u0435\u043c \u043a\u0430\u043a \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0443\u0435\u0442 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0438 \u0447\u0442\u043e \u043e\u043d\u043e \u043d\u0435 \u0441\u043e\u0437\u0434\u0430\u0435\u0442 \u0430\u0432\u0430\u0440\u0438\u0439\u043d\u044b\u0445 \u0441\u0438\u0442\u0443\u0430\u0446\u0438\u0439 \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043c\u043e\u0433\u043b\u0438 \u0431\u044b \u043e\u0431\u0440\u0443\u0448\u0438\u0442\u044c \u0431\u0430\u0437\u0443. \u0415\u0441\u043b\u0438 \u0447\u0435\u043b\u043e\u0432\u0435\u043a\u0443 \u043d\u0435 \u043f\u043e\u0432\u0435\u0437\u043b\u043e \u043d\u0430\u0441\u0442\u043e\u043b\u044c\u043a\u043e \u0447\u0442\u043e \u043e\u043d \u0442\u0435\u0445\u043b\u0438\u0434\/\u0442\u0435\u0445\u0434\u0438\u0440, \u0442\u043e \u0435\u043c\u0443 \u0432\u0430\u0436\u043d\u043e \u0447\u0442\u043e\u0431\u044b Postgres \u0432 \u0446\u0435\u043b\u043e\u043c \u0440\u0430\u0431\u043e\u0442\u0430\u043b \u043d\u0430\u0434\u0435\u0436\u043d\u043e, \u043f\u0440\u0435\u0434\u0441\u043a\u0430\u0437\u0443\u0435\u043c\u043e \u0438 \u043d\u0435 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u043b \u043f\u0440\u043e\u0431\u043b\u0435\u043c, \u043f\u0440\u0438 \u044d\u0442\u043e \u0436\u0435\u043b\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u0441\u0430\u043c\u043e\u043c\u0443 \u043d\u0435 \u043f\u043e\u0433\u0440\u0443\u0436\u0430\u0442\u044c\u0441\u044f \u0432 Postgres \u0433\u043b\u0443\u0431\u043e\u043a\u043e \u0438 \u043d\u0430\u0434\u043e\u043b\u0433\u043e.<\/p>\n

N\u00eb \u00e7do rast, ka ti dhe Postgres. P\u00ebr t\u00eb mir\u00ebmbajtur Postgres si\u00e7 duhet, duhet t\u00eb kesh nj\u00eb njohuri t\u00eb mir\u00eb dhe t\u00eb kuptosh se si \u00ebsht\u00eb nd\u00ebrtuar. N\u00ebse Postgres nuk \u00ebsht\u00eb specializimi yt i drejtp\u00ebrdrejt\u00eb, mund t\u00eb harxhosh mjaft koh\u00eb p\u00ebr ta studiuar at\u00eb. N\u00eb rastin ideal, kur ka koh\u00eb dhe d\u00ebshir\u00eb, shpesh nuk \u00ebsht\u00eb e qart\u00eb nga ku t\u00eb fillosh, si dhe n\u00eb cilin drejtim t\u00eb shkosh.<\/p>\n

Edhe n\u00ebse e rrethohesh me monitorim, i cili teori duhet ta leht\u00ebsoj\u00eb operimin, pyetja e njohurive ekspert\u00ebve mbetet e hapur. P\u00ebr t\u00eb qen\u00eb n\u00eb gjendje t\u00eb lexosh dhe kuptosh grafik\u00ebt, duhet gjithashtu t\u00eb kesh nj\u00eb njohuri t\u00eb mir\u00eb p\u00ebr se si funksionon Postgres. Ndryshe, \u00e7do monitorim shnd\u00ebrrohet n\u00eb visuale t\u00eb trishtueshme dhe spamin e alarmeve n\u00eb \u00e7do koh\u00eb t\u00eb dit\u00ebs.<\/p>\n

Armatim<\/a><\/noindex> \u043a\u0430\u043a \u0440\u0430\u0437 \u0441\u0434\u0435\u043b\u0430\u043d \u0434\u043b\u044f \u0442\u043e\u0433\u043e, \u0447\u0442\u043e\u0431\u044b \u043e\u0431\u043b\u0435\u0433\u0447\u0438\u0442\u044c \u044d\u043a\u0441\u043f\u043b\u0443\u0430\u0442\u0430\u0446\u0438\u044e Postgres. \u0421\u0435\u0440\u0432\u0438\u0441 \u0441\u043e\u0431\u0438\u0440\u0430\u0435\u0442 \u0438 \u0430\u043d\u0430\u043b\u0438\u0437\u0438\u0440\u0443\u0435\u0442 \u0434\u0430\u043d\u043d\u044b\u0435 \u043e Postgres’\u0435 \u0438 \u0434\u0430\u0435\u0442 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438 \u043e \u0442\u043e\u043c \u0447\u0442\u043e \u043c\u043e\u0436\u043d\u043e \u0443\u043b\u0443\u0447\u0448\u0438\u0442\u044c. <\/p>\n

Q\u00ebllimi kryesor i sh\u00ebrbimit \u00ebsht\u00eb t\u00eb ofroj\u00eb rekomandime t\u00eb qarta q\u00eb japin nj\u00eb ide se \u00e7far\u00eb po ndodh dhe \u00e7far\u00eb duhet t\u00eb b\u00ebni m\u00eb tej.<\/em> <\/p>\n

P\u00ebr specialist\u00ebt q\u00eb nuk kan\u00eb njohuri ekspert\u00ebsh, rekomandimet ofrojn\u00eb nj\u00eb pik\u00eb fillestare p\u00ebr avancimin e kualifikimeve. P\u00ebr specialist\u00ebt e avancuar, rekomandimet tregojn\u00eb pikat n\u00eb t\u00eb cilat duhet t\u00eb p\u00ebrqendrohen. N\u00eb k\u00ebt\u00eb kuptim, Weaponry vepron si nj\u00eb ndihm\u00ebs q\u00eb p\u00ebrfundon detyrat rutin\u00eb t\u00eb k\u00ebrkimit t\u00eb problemeve ose mang\u00ebsive q\u00eb k\u00ebrkojn\u00eb v\u00ebmendje t\u00eb ve\u00e7ant\u00eb. Weaponry mund t\u00eb krahasohet me nj\u00eb linters q\u00eb kontrollon Postgres dhe tregon mang\u00ebsit\u00eb.<\/p>\n

Si \u00ebsht\u00eb situata tani<\/h2>\n

Aktualisht Armatim<\/a><\/noindex> \u00ebsht\u00eb n\u00eb faz\u00eb testimi dhe n\u00eb nj\u00eb baz\u00eb falas, regjistrimi aktualisht \u00ebsht\u00eb i kufizuar p\u00ebrkoh\u00ebsisht. S\u00eb bashku me disa vullnetar\u00eb po p\u00ebrmir\u00ebsojm\u00eb motorin e rekomandimeve n\u00eb baza af\u00ebr betejave, identifikojm\u00eb falsifikimet dhe punojm\u00eb n\u00eb tekstin e rekomandimeve. <\/p>\n

\u041a \u0441\u043b\u043e\u0432\u0443 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438 \u043f\u043e\u043a\u0430 \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043f\u0440\u044f\u043c\u043e\u043b\u0438\u043d\u0435\u0439\u043d\u044b\u0435 — \u043f\u0440\u043e\u0441\u0442\u043e \u0433\u043e\u0432\u043e\u0440\u044f\u0442 \u0447\u0442\u043e \u0438 \u043a\u0430\u043a \u0434\u0435\u043b\u0430\u0442\u044c, \u0431\u0435\u0437 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e\u0441\u0442\u0435\u0439 — \u0442\u0430\u043a \u0447\u0442\u043e \u043f\u0435\u0440\u0432\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u043f\u0440\u0438\u0434\u0435\u0442\u0441\u044f \u043f\u0435\u0440\u0435\u0445\u043e\u0434\u0438\u0442\u044c \u043f\u043e \u0441\u043e\u043f\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u043c \u0441\u0441\u044b\u043b\u043a\u0430\u043c, \u043b\u0438\u0431\u043e \u0434\u043e\u0433\u0443\u0433\u043b\u0438\u0432\u0430\u0442\u044c. \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0438 \u0438 \u0440\u0435\u043a\u043e\u043c\u0435\u043d\u0434\u0430\u0446\u0438\u0438 \u043e\u0445\u0432\u0430\u0442\u044b\u0432\u0430\u044e\u0442 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0438 \u043e\u0431\u043e\u0440\u0443\u0434\u043e\u0432\u0430\u043d\u0438\u044f, \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0441\u0430\u043c\u043e\u0433\u043e Postgres, \u0441\u0445\u0435\u043c\u0443 \u0432\u043d\u0443\u0442\u0440\u0438, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u043c\u044b\u0435 \u0440\u0435\u0441\u0443\u0440\u0441\u044b. \u0412 \u043f\u043b\u0430\u043d\u0430\u0445 \u0435\u0449\u0435 \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043c\u043d\u043e\u0433\u043e \u0432\u0435\u0449\u0435\u0439 \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043d\u0443\u0436\u043d\u043e \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c. <\/p>\n

Natyrisht, ne po k\u00ebrkojm\u00eb vullnetar\u00eb t\u00eb cil\u00ebt jan\u00eb t\u00eb gatsh\u00ebm p\u00ebr t\u00eb provuar sh\u00ebrbimin dhe t\u00eb japin feedback. \u00c7far\u00eb m\u00eb tep\u00ebr, kemi demo<\/a><\/noindex>, mund t\u00eb hyni dhe t\u00eb shihni. N\u00ebse e kuptoni se keni nevoj\u00eb p\u00ebr k\u00ebt\u00eb dhe jeni t\u00eb gatsh\u00ebm ta provoni, na shkruani n\u00eb email<\/a><\/noindex>.<\/p>\n

P\u00ebrdit\u00ebsuar 2020-09-16. T\u00eb fillojm\u00eb.<\/h2>\n

\u041f\u043e\u0441\u043b\u0435 \u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0430\u0446\u0438\u0438 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u043f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u0435\u0442\u0441\u044f \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u043f\u0440\u043e\u0435\u043a\u0442 — \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u044f\u0442\u044c \u0438\u043d\u0441\u0442\u0430\u043d\u0441\u044b \u0411\u0414 \u0432 \u0433\u0440\u0443\u043f\u043f\u044b. \u041f\u043e\u0441\u043b\u0435 \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044c \u043d\u0430\u043f\u0440\u0430\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0432 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044e \u043f\u043e \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0435 \u0438 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0435 \u0430\u0433\u0435\u043d\u0442\u0430. \u0415\u0441\u043b\u0438 \u0432 \u0434\u0432\u0443\u0445 \u0441\u043b\u043e\u0432\u0430\u0445, \u0442\u043e \u043d\u0443\u0436\u043d\u043e \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 \u0434\u043b\u044f \u0430\u0433\u0435\u043d\u0442\u0430, \u043f\u043e\u0441\u043b\u0435 \u0447\u0435\u0433\u043e \u0441\u043a\u0430\u0447\u0430\u0442\u044c \u0441\u043a\u0440\u0438\u043f\u0442 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u0430\u0433\u0435\u043d\u0442\u0430 \u0438 \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u044c \u0435\u0433\u043e. \u0412 shell \u043a\u043e\u043c\u0430\u043d\u0434\u0430\u0445 \u044d\u0442\u043e \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e \u0442\u0430\u043a:<\/p>\n

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
N\u00ebse ka pgbouncer n\u00eb host, p\u00ebr t\u00eb lidhur agen\u00ebt do t\u00eb nevojitet gjithashtu krijimi i nj\u00eb p\u00ebrdoruesi. M\u00ebnyra e sakt\u00eb e konfigurimit t\u00eb p\u00ebrdoruesit n\u00eb pgbouncer mund t\u00eb jet\u00eb shum\u00eb variative dhe varet shum\u00eb nga konfigurimi i p\u00ebrdorur. N\u00eb p\u00ebrgjith\u00ebsi, konfigurimi p\u00ebrfshin shtimin e p\u00ebrdoruesit n\u00eb stats_users<\/em> skedarin e konfigurimit (zakonisht kjo \u00ebsht\u00eb pgbouncer.ini<\/em>) dhe p\u00ebrcaktimin e fjal\u00ebkalimit (ose hash-it t\u00eb tij) n\u00eb skedarin e caktuar n\u00eb parametrin auth_file.<\/em> Kur t\u00eb ndryshohet stats_users, pgbouncer do t\u00eb k\u00ebrkoj\u00eb nj\u00eb rinisje.<\/p>\n
\u0421\u043a\u0440\u0438\u043f\u0442 install.sh \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u0435\u0442 \u043f\u0430\u0440\u0443 \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0430\u0440\u0433\u0443\u043c\u0435\u043d\u0442\u043e\u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0433\u043e \u043f\u0440\u043e\u0435\u043a\u0442\u0430, \u0438 \u0447\u0435\u0440\u0435\u0437 \u043f\u0435\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0435 \u043e\u043a\u0440\u0443\u0436\u0435\u043d\u0438\u044f \u043f\u0440\u0438\u043d\u0438\u043c\u0430\u0435\u0442 \u0440\u0435\u043a\u0432\u0438\u0437\u0438\u0442\u044b \u0441\u043e\u0437\u0434\u0430\u043d\u043d\u044b\u0445 \u044e\u0437\u0435\u0440\u043e\u0432. \u0414\u0430\u043b\u0435\u0435 \u0441\u043a\u0440\u0438\u043f\u0442 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u0442 \u0430\u0433\u0435\u043d\u0442\u0430 \u0432 bootstrap \u0440\u0435\u0436\u0438\u043c\u0435 — \u0430\u0433\u0435\u043d\u0442 \u043a\u043e\u043f\u0438\u0440\u0443\u0435\u0442 \u0441\u0435\u0431\u044f \u0432 PATH, \u0441\u043e\u0437\u0434\u0430\u0435\u0442 \u043a\u043e\u043d\u0444\u0438\u0433 \u0441 \u0440\u0435\u043a\u0432\u0438\u0437\u0438\u0442\u0430\u043c\u0438, systemd \u044e\u043d\u0438\u0442 \u0438 \u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u0442\u0441\u044f \u043a\u0430\u043a systemd \u0441\u0435\u0440\u0432\u0438\u0441. 
K\u00ebtu p\u00ebrfundon instalimi. N\u00eb nj\u00eb periudh\u00eb prej 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 24 or\u00eb).<\/p>\n
Burimi: habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
\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: «\u0425\u043e\u0440\u043e\u0448\u043e, \u043a\u043e\u0433\u0434\u0430 \u0435\u0441\u0442\u044c \u0437\u043d\u0430\u043a\u043e\u043c\u044b\u0439 DBA». \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 […]<\/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\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Atje kemi Postgres, por nuk di \u00e7far\u00eb t\u00eb b\u00ebj me t\u00eb (c) | ProHoster","description":"Kjo \u00ebsht\u00eb nj\u00eb citat\u00eb e nj\u00eb prej miqve t\u00eb mi q\u00eb nj\u00ebher\u00eb e nj\u00eb koh\u00eb m\u00eb ka pyetur p\u00ebr Postgres.","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.","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","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\/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}]}}