{"id":10815,"date":"2019-09-30T09:38:27","date_gmt":"2019-09-30T07:38:27","guid":{"rendered":"https:\/\/www.websupport.sk\/podpora\/?post_type=ht_kb&#038;p=10815"},"modified":"2023-06-08T10:55:14","modified_gmt":"2023-06-08T08:55:14","slug":"instalacia-postgresql-ubuntu","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/","title":{"rendered":"In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS"},"content":{"rendered":"\n<p><strong>PostgreSQL<\/strong>&nbsp;(alebo tie\u017e naz\u00fdvan\u00fd Postgres) je&nbsp;typ&nbsp;<strong>objektovo-rela\u010dn\u00e9ho syst\u00e9mu spr\u00e1vy datab\u00e1z<\/strong>&nbsp;(z anglick\u00e9ho object-relationship database management system ORDBMS).&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.org\/\" target=\"_blank\">PostgreSQL<\/a>&nbsp;je uverej\u0148ovan\u00e1 pod&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.org\/about\/licence\/\" target=\"_blank\">PostgreSQL licenciou<\/a>, liber\u00e1lnou odrodou&nbsp;<strong>open-source<\/strong>&nbsp;syst\u00e9mov.&nbsp;Pre kone\u010dn\u00e9ho pou\u017e\u00edvate\u013ea to znamen\u00e1, \u017ee je zadarmo a jej zdrojov\u00fd k\u00f3d je verejne dostupn\u00fd pre ka\u017ed\u00e9ho, kto by o\u0148 mal z\u00e1ujem pre pr\u00edpadn\u00fa modifik\u00e1ciu.<\/p>\n\n\n\n<p>Pod pojmom&nbsp;<strong>rela\u010dn\u00e1 datab\u00e1za<\/strong>&nbsp;sa rozumie miesto na ukladanie perzistentn\u00fdch d\u00e1t, teda tak\u00fdch, ktor\u00e9 ostan\u00fa ulo\u017een\u00e9 v tabu\u013ek\u00e1ch aj po vypnut\u00ed aplik\u00e1cie. Ka\u017ed\u00e1 tabu\u013eka m\u00f4\u017ee by\u0165 in\u00e1, obsahuje kone\u010dn\u00fd po\u010det riadkov a st\u013apcov, a vytv\u00e1ra tak mrie\u017eku d\u00e1t (okrem \u0161pecifick\u00e9ho d\u00e1tov\u00e9ho typu JSON).<\/p>\n\n\n\n<p>Ka\u017ed\u00fd z\u00e1znam datab\u00e1zy predstavuje riadok v tabu\u013eke ozna\u010den\u00fd unik\u00e1tnym ID, ktor\u00e9 je jeho prim\u00e1rnym k\u013e\u00fa\u010dom. Ak sa chce in\u00e1 tabu\u013eka dopytova\u0165 po tomto z\u00e1zname, pou\u017eije jeho ID ako cudz\u00ed k\u013e\u00fa\u010d (anglicky foreign key).<\/p>\n\n\n\n<p class=\"has-pale-cyan-blue-background-color has-background\"><a href=\"https:\/\/www.websupport.sk\/blog\/2023\/06\/postgresql-pre-serverove-sluzby\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Tip: <\/strong>Chcete vedie\u0165, ako PostgreSQL vznikla, \u010do pon\u00faka a v \u010dom sa l\u00ed\u0161i od MySQL datab\u00e1zy? Pre\u010d\u00edtajte si na na\u0161om blogu.<\/a><\/p>\n\n\n\n<p>PostgreSQL taktie\u017e obsahuje mo\u017enos\u0165 pou\u017ei\u0165 JSON ako d\u00e1tov\u00fd typ, v\u010faka \u010domu m\u00e1 navrch oproti in\u00fdm typom datab\u00e1zov\u00fdch syst\u00e9mov ako napr\u00edklad MariaDB.&nbsp;<\/p>\n\n\n\n<p>Tento jednoduch\u00fd n\u00e1vod vysvet\u013euje in\u0161tal\u00e1ciu PostgreSQL datab\u00e1zy na&nbsp;<a href=\"https:\/\/www.websupport.sk\/virtual-server\">virtu\u00e1lne priv\u00e1tne servery<\/a>&nbsp;(skr\u00e1tene VPS) so syst\u00e9mom Ubuntu 18.04.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>In\u0161tal\u00e1cia a po\u017eiadavky na syst\u00e9m<\/strong><\/h2>\n\n\n\n<p>Na in\u0161tal\u00e1ciu PostgreSQL datab\u00e1zy posta\u010duje 512 MB opera\u010dnej pam\u00e4te, pre re\u00e1lne pou\u017eitie odpor\u00fa\u010dame aspo\u0148 2 GB RAM. Opera\u010dn\u00fd syst\u00e9m je v tomto pr\u00edpade Ubuntu 18.04 v 64-bit verzii. Pre in\u0161tal\u00e1ciu potrebujete dostatok vo\u013en\u00e9ho priestoru a aj d\u00e1ta. Po\u017eiadavky na v\u00fdkon procesora nie s\u00fa pri tento type datab\u00e1zy \u017eiadne, no pre produkciu s\u00fa aspo\u0148 dve jadr\u00e1 dobr\u00fd \u0161tart.<\/p>\n\n\n\n<p>Samotn\u00e1 in\u0161tal\u00e1cia PostgreSQL je pomerne jednoduch\u00e1. Potrebn\u00e9 bal\u00edky s\u00fa obsiahnut\u00e9 priamo v repozit\u00e1roch Ubuntu (aktu\u00e1lne pod verziou 10.5). Najsk\u00f4r odpor\u00fa\u010dame si repozit\u00e1r aktualizova\u0165:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo apt update<\/pre>\n\n\n\n<p>N\u00e1sledne sa u\u017e len spust\u00ed in\u0161tal\u00e1cia PostgreSQL:<br><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo apt install postgresql postgresql-contrib<\/pre>\n\n\n\n<p>Re\u00e1lne je potrebn\u00fd len bal\u00ed\u010dek&nbsp;<em>postgresql<\/em>, no bal\u00ed\u010dek s pr\u00edponou&nbsp;<em>-contrib&nbsp;<\/em>prid\u00e1 do na\u0161ej datab\u00e1zy roz\u0161\u00edren\u00fa&nbsp;<a href=\"https:\/\/www.postgresql.org\/docs\/9.1\/contrib.html\">funkcionalitu<\/a>, ktor\u00fa ur\u010dite niektor\u00ed n\u00e1ro\u010dnej\u0161\u00ed pou\u017e\u00edvatelia ocenia.&nbsp;<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pou\u017e\u00edvanie rol\u00ed a datab\u00e1zy<\/strong><\/h2>\n\n\n\n<p>PostgreSQL pou\u017e\u00edva koncept rol\u00ed pre autentifik\u00e1ciu, ktor\u00fd je podobn\u00fd tomu zo syst\u00e9mu zalo\u017eenom na Unixe \u2013 konkr\u00e9tne pou\u017e\u00edvatelia a skupiny. PostgreSQL tento koncept jednoducho zdru\u017eila do n\u00e1zvu rola.<\/p>\n\n\n\n<p>Okam\u017eite po in\u0161tal\u00e1cii si PostgreSQL osvoj\u00ed pou\u017e\u00edvate\u013eov, ktor\u00fdch n\u00e1jde v syst\u00e9me. To znamen\u00e1, \u017ee pokia\u013e bol pou\u017e\u00edvate\u013e u\u017e vytvoren\u00fd, PostgreSQL ho preberie ako rolu a umo\u017en\u00ed mu tak autentifikova\u0165 sa a pou\u017e\u00edva\u0165 datab\u00e1zu. Vytvor\u00ed sa aj jeden \u0161peci\u00e1lny \u00fa\u010det s n\u00e1zvom&nbsp;<em>postgres<\/em>, ktor\u00fd je napojen\u00fd na rovnomenn\u00fa rolu v datab\u00e1ze, aby tak umo\u017enil pr\u00edstup k pr\u00e1ci po prihl\u00e1sen\u00ed sa do tohto \u00fa\u010dtu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prepnutie pou\u017e\u00edvate\u013esk\u00e9ho \u00fa\u010dtu<\/strong><\/h2>\n\n\n\n<p>Prepnutie na \u00fa\u010det&nbsp;<em>postgres&nbsp;<\/em>prebehne nasleduj\u00facim riadkom:&nbsp;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -i -u postgres<\/pre>\n\n\n\n<p>Teraz sa m\u00f4\u017eeme okam\u017eite prepn\u00fa\u0165 do pr\u00edkazov\u00e9ho riadku PostgreSQL datab\u00e1zy. N\u00e1sledne m\u00f4\u017eeme interagova\u0165 s datab\u00e1zov\u00fdm syst\u00e9mom, vykon\u00e1va\u0165 SQL pr\u00edkazy a ovplyv\u0148ova\u0165 existenciu tabuliek v datab\u00e1zach:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># psql<\/pre>\n\n\n\n<p>Pr\u00edkazy na prepnutie \u00fa\u010dtu a prihl\u00e1senie sa daj\u00fa vykona\u0165 aj spolo\u010dne:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -u postgres psql<\/pre>\n\n\n\n<p>Na ukon\u010denie pr\u00e1ce s PostgreSQL sta\u010d\u00ed zada\u0165 pr\u00edkaz alebo stla\u010di\u0165 kl\u00e1vesov\u00fa skratku Ctrl+D:&nbsp;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># postgres=# \\g<\/pre>\n\n\n\n<p>Pri pr\u00e1ci s PostgreSQL m\u00f4\u017ee nasta\u0165 situ\u00e1cia, ke\u010f je nutn\u00e9 vyu\u017ei\u0165 viac rol\u00ed. Preto je d\u00f4le\u017eit\u00e9 nau\u010di\u0165 sa ich mana\u017eova\u0165 \u010di u\u017e z poz\u00edcie role&nbsp;<em>postgres,&nbsp;<\/em>alebo priamo cez termin\u00e1l. Prid\u00e1vanie rol\u00ed pou\u017e\u00edvate\u013eov datab\u00e1zov\u00e9ho syst\u00e9mu nie je ni\u010d n\u00e1ro\u010dn\u00e9, sta\u010d\u00ed zada\u0165 nasledovn\u00e9 pr\u00edkazy:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">postgres@server:~$ createuser --interactive<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -u postgres createuser --interactive<\/pre>\n\n\n\n<p>Oba sp\u00f4soby vyvolaj\u00fa dial\u00f3g, v ktorom pou\u017eivate\u013e dop\u00ed\u0161e meno pou\u017e\u00edvate\u013ea a \u010di mu chce udeli\u0165 pr\u00e1va super administr\u00e1tora. Dial\u00f3g vyzer\u00e1 nasledovne:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo -u postgres createuser --interactive\nShall the new role be a superuser? (y\/n) y\n<\/pre>\n\n\n\n<p>Je, samozrejme, mo\u017en\u00e9 pou\u017ei\u0165 viac typov prep\u00edna\u010dov, pre kompletn\u00fd zoznam a pou\u017eitie je vhodn\u00e9 siahnu\u0165 po manu\u00e1li PostgreSQL priamo cez termin\u00e1l zadan\u00edm pr\u00edkazu:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># man createuser<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Vytvorenie novej datab\u00e1zy<\/strong><\/h2>\n\n\n\n<p>\u010eal\u0161\u00ed predpoklad, o ktorom Postgres uva\u017euje, je, \u017ee ka\u017ed\u00e1 rola, ktor\u00e1 sa do syst\u00e9mu prihlasuje, m\u00e1 vlastn\u00fa datab\u00e1zu s rovnomenn\u00fdm n\u00e1zvom.&nbsp;<\/p>\n\n\n\n<p>Predpokladajme, \u017ee rola, ktor\u00fa sme vytvorili v minulom kroku, sa naz\u00fdva&nbsp;<em>test<\/em>. V tom pr\u00edpade sa bude PostgreSQL pri prihl\u00e1sen\u00ed pod touto rolou sna\u017ei\u0165 predvolene pripoji\u0165 do datab\u00e1zy s rovnak\u00fdm n\u00e1zvom. Vytvorenie tak\u00fdchto datab\u00e1z prebieha pr\u00edkazom:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -u postgres createdb test<\/pre>\n\n\n\n<p class=\"has-pale-cyan-blue-background-color has-background\"><strong>Tip: <\/strong>Zauj\u00edma v\u00e1s porovnanie r\u00f4znych datab\u00e1z? Pozrite si, ak\u00fd je rozdiel medzi&nbsp;<a href=\"https:\/\/www.websupport.sk\/blog\/2018\/09\/porovnanie-mariadb-a-mysql\/\">MariaDB a MySQL<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Otvorenie pr\u00edkazov\u00e9ho riadku cez autentifik\u00e1ciu&nbsp;<em>ident<\/em><\/strong><\/h2>\n\n\n\n<p>Pri prihlasovan\u00ed sa do datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL je mo\u017en\u00e9 vyu\u017ei\u0165 takzvan\u00fd&nbsp;<em>ident<\/em>. Jeho predpoklad je, \u017ee v po\u010d\u00edta\u010di u\u017e je pou\u017e\u00edvate\u013e, ktor\u00fd m\u00e1 rovnomenn\u00fa rolu v postgres syst\u00e9me a rovnako \u017ee existuje aj predvolen\u00e1 datab\u00e1za. T\u00fdmto sp\u00f4sobom sa teda d\u00e1 prihl\u00e1si\u0165 do datab\u00e1zy bez nutnosti zadania hesla \u010di akejko\u013evek inej autentifik\u00e1cie. Pr\u00edkaz je jednoduch\u00fd:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -u test psql<\/pre>\n\n\n\n<p>Pr\u00edkaz&nbsp;<em>sudo -u<\/em>&nbsp;zmen\u00ed pou\u017e\u00edvate\u013ea na toho, ktor\u00fd nasleduje ako parameter. Nasleduje pr\u00edkaz&nbsp;<em>psql<\/em>, ktor\u00fd spust\u00ed datab\u00e1zov\u00fd syst\u00e9m a automaticky prihl\u00e1si pou\u017e\u00edvate\u013ea do rovnomennej role a datab\u00e1zy. Datab\u00e1zu je v\u0161ak mo\u017en\u00e9 zmeni\u0165, a to prep\u00edna\u010dom&nbsp;<em>-d<\/em>&nbsp;nasledovan\u00fdm n\u00e1zvom datab\u00e1zy, do ktorej sa chceme pripoji\u0165. Otestovanie pripojenia je mo\u017en\u00e9 pr\u00edkazom&nbsp;<em>\\conninfo<\/em>.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Vytv\u00e1ranie a edit\u00e1cia tabuliek<\/strong><\/h2>\n\n\n\n<p>Ke\u010f u\u017e sme pripojen\u00ed v datab\u00e1ze, je na\u010dase sk\u00fasi\u0165 z\u00e1kladn\u00e9 oper\u00e1cie ako vytvorenie priestoru, kde si m\u00f4\u017eeme uchov\u00e1va\u0165 d\u00e1ta. Z\u00e1kladn\u00e1 syntax je nasleduj\u00faca:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE nazov_tabulky (\n Nazov_prveho_stlpca typ_stlpca (maximalna dlzka) parametre_stlpca,\n nazov_druheho_stlpca typ_stlpca (maximalna dlzka),\n Nazov_tretieho_stlpca typ_stlpca (maximalna dlzka)\n\n);<\/pre>\n\n\n\n<p>Ako pr\u00edklad si m\u00f4\u017eeme predstavi\u0165 tabu\u013eku elektrospotrebi\u010dov:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE elektrospotrebi\u010de(\n Id serial PRIMARY KEY,\n Nazov_spotrebi\u010da string (50) NOT NULL,\n Datum_vyroby date NOT NULL,\n Spotreba_el_energie int (4) NOT NULL\n);<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Kam \u010falej<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.org\/\" target=\"_blank\">Ofici\u00e1lne str\u00e1nky projektu<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.org\/docs\/\" target=\"_blank\">Dokument\u00e1cia<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"http:\/\/www.postgresqltutorial.com\/postgresql-cheat-sheet\/\" target=\"_blank\">Z\u00e1kladn\u00fd \u0165ah\u00e1k s pr\u00edkazmi<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/postgresweekly.com\/\" target=\"_blank\">Postgres Weekly<\/a>&nbsp;\u2013 emailov\u00fd newsletter s t\u00fd\u017edenn\u00fdmi novinkami<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL&nbsp;(alebo tie\u017e naz\u00fdvan\u00fd Postgres) je&nbsp;typ&nbsp;objektovo-rela\u010dn\u00e9ho syst\u00e9mu spr\u00e1vy datab\u00e1z&nbsp;(z anglick\u00e9ho object-relationship database management system ORDBMS).&nbsp;PostgreSQL&nbsp;je uverej\u0148ovan\u00e1 pod&nbsp;PostgreSQL licenciou, liber\u00e1lnou odrodou&nbsp;open-source&nbsp;syst\u00e9mov.&nbsp;Pre kone\u010dn\u00e9ho pou\u017e\u00edvate\u013ea to znamen\u00e1, \u017ee je zadarmo a jej zdrojov\u00fd k\u00f3d je verejne dostupn\u00fd pre ka\u017ed\u00e9ho, kto by o\u0148 mal z\u00e1ujem pre pr\u00edpadn\u00fa modifik\u00e1ciu. Pod pojmom&nbsp;rela\u010dn\u00e1 datab\u00e1za&nbsp;sa rozumie miesto na ukladanie&#8230;<\/p>\n","protected":false},"author":28,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[52],"ht-kb-tag":[249,252,198,201],"class_list":["post-10815","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-vps","ht_kb_tag-databaza","ht_kb_tag-postgresql","ht_kb_tag-ubuntu","ht_kb_tag-ubuntu-18-04-lts"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS - Websupport centrum podpory<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS - Websupport centrum podpory\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL&nbsp;(alebo tie\u017e naz\u00fdvan\u00fd Postgres) je&nbsp;typ&nbsp;objektovo-rela\u010dn\u00e9ho syst\u00e9mu spr\u00e1vy datab\u00e1z&nbsp;(z anglick\u00e9ho object-relationship database management system ORDBMS).&nbsp;PostgreSQL&nbsp;je uverej\u0148ovan\u00e1 pod&nbsp;PostgreSQL licenciou, liber\u00e1lnou odrodou&nbsp;open-source&nbsp;syst\u00e9mov.&nbsp;Pre kone\u010dn\u00e9ho pou\u017e\u00edvate\u013ea to znamen\u00e1, \u017ee je zadarmo a jej zdrojov\u00fd k\u00f3d je verejne dostupn\u00fd pre ka\u017ed\u00e9ho, kto by o\u0148 mal z\u00e1ujem pre pr\u00edpadn\u00fa modifik\u00e1ciu. Pod pojmom&nbsp;rela\u010dn\u00e1 datab\u00e1za&nbsp;sa rozumie miesto na ukladanie...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport centrum podpory\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-08T08:55:14+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Predpokladan\u00fd \u010das \u010d\u00edtania\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 min\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/instalacia-postgresql-ubuntu\\\/\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/instalacia-postgresql-ubuntu\\\/\",\"name\":\"In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS - Websupport centrum podpory\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/#website\"},\"datePublished\":\"2019-09-30T07:38:27+00:00\",\"dateModified\":\"2023-06-08T08:55:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/instalacia-postgresql-ubuntu\\\/#breadcrumb\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/instalacia-postgresql-ubuntu\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/instalacia-postgresql-ubuntu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/\",\"name\":\"Websupport centrum podpory\",\"description\":\"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sk-SK\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS - Websupport centrum podpory","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/","og_locale":"sk_SK","og_type":"article","og_title":"In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS - Websupport centrum podpory","og_description":"PostgreSQL&nbsp;(alebo tie\u017e naz\u00fdvan\u00fd Postgres) je&nbsp;typ&nbsp;objektovo-rela\u010dn\u00e9ho syst\u00e9mu spr\u00e1vy datab\u00e1z&nbsp;(z anglick\u00e9ho object-relationship database management system ORDBMS).&nbsp;PostgreSQL&nbsp;je uverej\u0148ovan\u00e1 pod&nbsp;PostgreSQL licenciou, liber\u00e1lnou odrodou&nbsp;open-source&nbsp;syst\u00e9mov.&nbsp;Pre kone\u010dn\u00e9ho pou\u017e\u00edvate\u013ea to znamen\u00e1, \u017ee je zadarmo a jej zdrojov\u00fd k\u00f3d je verejne dostupn\u00fd pre ka\u017ed\u00e9ho, kto by o\u0148 mal z\u00e1ujem pre pr\u00edpadn\u00fa modifik\u00e1ciu. Pod pojmom&nbsp;rela\u010dn\u00e1 datab\u00e1za&nbsp;sa rozumie miesto na ukladanie...","og_url":"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/","og_site_name":"Websupport centrum podpory","article_modified_time":"2023-06-08T08:55:14+00:00","twitter_card":"summary_large_image","twitter_misc":{"Predpokladan\u00fd \u010das \u010d\u00edtania":"5 min\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/","url":"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/","name":"In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS - Websupport centrum podpory","isPartOf":{"@id":"https:\/\/www.websupport.sk\/podpora\/#website"},"datePublished":"2019-09-30T07:38:27+00:00","dateModified":"2023-06-08T08:55:14+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/#breadcrumb"},"inLanguage":"sk-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/instalacia-postgresql-ubuntu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.sk\/podpora\/"},{"@type":"ListItem","position":2,"name":"In\u0161tal\u00e1cia a pou\u017e\u00edvanie datab\u00e1zy PostgreSQL na Ubuntu 18.04 LTS"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.sk\/podpora\/#website","url":"https:\/\/www.websupport.sk\/podpora\/","name":"Websupport centrum podpory","description":"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.sk\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sk-SK"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/10815","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/users\/28"}],"version-history":[{"count":2,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/10815\/revisions"}],"predecessor-version":[{"id":24506,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/10815\/revisions\/24506"}],"wp:attachment":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/media?parent=10815"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=10815"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=10815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}