{"id":7336,"date":"2026-08-20T18:28:28","date_gmt":"2026-08-20T16:28:28","guid":{"rendered":"https:\/\/www.webhostingsrbija.rs\/?p=7336"},"modified":"2026-08-20T18:28:28","modified_gmt":"2026-08-20T16:28:28","slug":"postgresql-baze","status":"publish","type":"post","link":"https:\/\/www.webhostingsrbija.rs\/en\/postgresql-baze\/","title":{"rendered":"PostgreSQL databases in WHSPanel"},"content":{"rendered":"

PostgreSQL je napredna relaciona baza, idealna za aplikacije kojima trebaju slo\u017eeni upiti, \u010duvanje JSON podataka, pretraga celog teksta ili strog integritet podataka. U ovom delu panela pravi\u0161 PostgreSQL baze i korisnike, a podatke pregleda\u0161 kroz ugra\u0111eni alat Adminer. Imena se prefiksuju imenom tvog naloga.<\/p>\n\n

1. Pregled<\/h2>\n

U meniju otvori Databases<\/strong> well PostgreSQL baze<\/strong>. Na vrhu su kartice sa brojem baza, ukupnom veli\u010dinom i brojem korisnika, a ispod su tabele baza (svaka sa svojim akcijama) i korisnika.<\/p>\n\n\n

\"PostgreSQL\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button>
Populisano stanje: baza i korisnik sa akcijama Pristup, Adminer, Lozinka.<\/figcaption><\/figure>\n\n\n

2. \u010carobnjak za baze<\/h2>\n

Najbr\u017ei na\u010din je \u010carobnjak za baze<\/strong>: u nekoliko koraka napravi\u0161 bazu, korisnika i dodeli\u0161 pristup odjednom.<\/p>\n\n\n

\"PostgreSQL\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button>
\u010carobnjak za pravljenje PostgreSQL baze i korisnika.<\/figcaption><\/figure>\n\n\n

3. Ru\u010dno pravljenje<\/h2>\n
    \n
  • Kreiraj bazu podataka:<\/strong> upi\u0161i naziv nove baze.<\/li>\n
  • Kreiraj korisnika:<\/strong> napravi korisnika (u PostgreSQL svetu poznat i kao \u201erole“) sa lozinkom.<\/li>\n<\/ul>\n\n

    4. Akcije nad bazom<\/h2>\n\n\n
    Akcija<\/th>\u0160ta radi<\/th><\/tr><\/thead>\n
    Pristup<\/strong><\/td>Odre\u0111uje kojim korisnicima je baza dostupna (pove\u017ei korisnika sa bazom).<\/td><\/tr>\n
    Adminer<\/strong><\/td>Otvara bezbedan veb interfejs baze sa jedinstvenom prijavom, u kome izvr\u0161ava\u0161 SQL upite, gleda\u0161 tabele i pregleda\u0161 podatke. Za Adminer ti ne treba posebna lozinka za bazu.<\/td><\/tr>\n
    Obri\u0161i<\/strong><\/td>Trajno bri\u0161e bazu.<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n

    5. Korisnici (role)<\/h2>\n

    PostgreSQL korisnici (poznati i kao \u201erole“) su nalozi za prijavu koje tvoje aplikacije koriste za povezivanje. Kolona Baze<\/strong> u tabeli korisnika pokazuje kojim bazama svaki korisnik mo\u017ee da pristupi. Dugmetom Password<\/strong> menja\u0161 lozinku korisnika, a Obri\u0161i<\/strong> ga uklanja.<\/p>\n\n

    Kada birati PostgreSQL:<\/strong> ako aplikacija radi sa slo\u017eenim upitima, geo podacima, velikim JSON dokumentima ili tra\u017ei strog integritet, PostgreSQL je odli\u010dan izbor. Za tipi\u010dan WordPress ili prodavnicu obi\u010dno je dovoljan MySQL.<\/p><\/blockquote>\n\n

    Note:<\/strong> pri povezivanju aplikacije koristi pun naziv baze i korisnika sa prefiksom naloga, a kao host localhost<\/code>. Ne zaboravi da korisniku da\u0161 Pristup<\/strong> bazi.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"

    Kako da napravi\u0161 PostgreSQL bazu i korisnika u WHSPanelu i pregleda\u0161 podatke kroz Adminer, bez posebne lozinke za bazu.<\/p>","protected":false},"author":1,"featured_media":7311,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[206,203],"tags":[],"class_list":["post-7336","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-baze-podataka","category-whs-panel"],"_links":{"self":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts\/7336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/comments?post=7336"}],"version-history":[{"count":1,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts\/7336\/revisions"}],"predecessor-version":[{"id":7569,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts\/7336\/revisions\/7569"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/media\/7311"}],"wp:attachment":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/media?parent=7336"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/categories?post=7336"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/tags?post=7336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}