{"id":937,"date":"2021-04-29T11:46:44","date_gmt":"2021-04-29T11:46:44","guid":{"rendered":"https:\/\/dev.sourcecode.sk\/wsczkb\/?post_type=ht_kb&#038;p=937"},"modified":"2021-10-12T14:04:48","modified_gmt":"2021-10-12T12:04:48","slug":"instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/","title":{"rendered":"Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS"},"content":{"rendered":"\n<p><strong>PostgreSQL<\/strong>&nbsp;(nebo t\u00e9\u017e naz\u00fdvan\u00fd Postgres) je&nbsp;typ&nbsp;<strong>objektov\u011b-rela\u010dn\u00edho syst\u00e9mu spr\u00e1vy datab\u00e1z\u00ed<\/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 uve\u0159ej\u0148ovan\u00e1 pod&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.org\/about\/licence\/\" target=\"_blank\">PostgreSQL licenc\u00ed<\/a>, liber\u00e1ln\u00ed odr\u016fdou&nbsp;<strong>open-source<\/strong>&nbsp;syst\u00e9m\u016f.&nbsp;Pro koncov\u00e9ho u\u017eivatele to znamen\u00e1, \u017ee je zadarmo a jej\u00ed zdrojov\u00fd k\u00f3d je ve\u0159ejn\u011b dostupn\u00fd pro ka\u017ed\u00e9ho, kdo by n\u011bj m\u011bl z\u00e1jem pro p\u0159\u00edpadnou modifikaci.<\/p>\n\n\n\n<p>Pod pojmem&nbsp;<strong>rela\u010dn\u00ed datab\u00e1ze<\/strong>&nbsp;se rozum\u00ed m\u00edsto na ukl\u00e1d\u00e1n\u00ed perzistentn\u00edch dat, tedy takov\u00fdch, kter\u00e1 z\u016fstanou ulo\u017een\u00e9 v tabulk\u00e1ch i po vypnut\u00ed aplikace. Ka\u017ed\u00e1 tabulka m\u016f\u017ee b\u00fdt jin\u00e1, obsahuje kone\u010dn\u00fd po\u010det \u0159\u00e1dk\u016f a sloupc\u016f, a vytv\u00e1\u0159\u00ed tak m\u0159\u00ed\u017eku dat (krom\u011b specifick\u00e9ho datov\u00e9ho typu JSON).<\/p>\n\n\n\n<p>Ka\u017ed\u00fd z\u00e1znam datab\u00e1ze p\u0159edstavuje \u0159\u00e1dek v tabulce ozna\u010den\u00fd unik\u00e1tn\u00edm ID, kter\u00e9 je jeho prim\u00e1rn\u00edm kl\u00ed\u010dem. Kdy\u017e se chce jin\u00e1 tabulka dopt\u00e1vat po tomto z\u00e1znamu, pou\u017eije jeho ID jako ciz\u00ed kl\u00ed\u010d (anglicky foreign key).<\/p>\n\n\n\n<p class=\"has-pale-cyan-blue-background-color has-background\"><strong>Tip: <\/strong>Zaj\u00edm\u00e1 v\u00e1s porovn\u00e1n\u00ed r\u016fzn\u00fdch datab\u00e1z\u00ed? Pod\u00edvejte se, jak\u00fd je rozd\u00edl mezi&nbsp;<a href=\"https:\/\/www.websupport.sk\/blog\/2018\/09\/porovnanie-mariadb-a-mysql\/\">MariaDB a MySQL<\/a>.<\/p>\n\n\n\n<p>PostgreSQL tak\u00e9 obsahuje mo\u017enost pou\u017e\u00edt JSON jako datov\u00fd typ, d\u00edky \u010demu\u017e m\u00e1 navrch oproti jin\u00fdm typ\u016fm datab\u00e1zov\u00fdch syst\u00e9m\u016f, jako nap\u0159\u00edklad MariaDB.&nbsp;<\/p>\n\n\n\n<p>Tento jednoduch\u00fd n\u00e1vod vysv\u011btluje instalaci PostgreSQL datab\u00e1ze na\u00a0<a href=\"https:\/\/www.websupport.cz\/servery\/vps\/\">virtu\u00e1ln\u00ed priv\u00e1tn\u00ed servery<\/a>\u00a0(zkr\u00e1cen\u011b VPS) se syst\u00e9mem Ubuntu 18.04.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Instalace a po\u017eadavky na syst\u00e9m<\/strong><\/h2>\n\n\n\n<p>Na instalaci PostgreSQL datab\u00e1ze posta\u010duje 512 MB opera\u010dn\u00ed pam\u011bti, pro re\u00e1ln\u00e9 pou\u017eit\u00ed doporu\u010dujeme alespo\u0148 2 GB RAM. Opera\u010dn\u00ed syst\u00e9m je v tomto p\u0159\u00edpad\u011b Ubuntu 18.04 v 64-bit verzi. Pro instalaci pot\u0159ebujete dostatek voln\u00e9ho prostoru a i data. Po\u017eadavky na v\u00fdkon procesoru nejsou p\u0159i tomto typu datab\u00e1ze \u017e\u00e1dn\u00e9, ale pro produkci jsou alespo\u0148 dv\u011b j\u00e1dra dobr\u00fd start.<\/p>\n\n\n\n<p>Samotn\u00e1 instalace PostgreSQL je pom\u011brn\u011b jednoduch\u00e1. Pot\u0159ebn\u00e9 bal\u00edky jsou obs\u00e1hnut\u00e9 p\u0159\u00edmo v repozit\u00e1\u0159\u00edch Ubuntu (aktu\u00e1ln\u011b pod verz\u00ed 10.5). Nejd\u0159\u00edve doporu\u010dujeme si repozit\u00e1\u0159 aktualizovat:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo apt update<\/pre>\n\n\n\n<p>N\u00e1sledn\u011b se u\u017e jen spust\u00ed instalace 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\u00e1ln\u011b je pot\u0159ebn\u00fd jen bal\u00ed\u010dek&nbsp;<em>postgresql<\/em>, ale bal\u00ed\u010dek s p\u0159\u00edponou&nbsp;<em>-contrib&nbsp;<\/em>p\u0159id\u00e1 do na\u0161\u00ed datab\u00e1ze roz\u0161\u00ed\u0159enou&nbsp;<a href=\"https:\/\/www.postgresql.org\/docs\/9.1\/contrib.html\">funkcionalitu<\/a>, kterou ur\u010dit\u011b n\u011bkte\u0159\u00ed n\u00e1ro\u010dn\u011bj\u0161\u00ed u\u017eivatel\u00e9 ocen\u00ed.&nbsp;<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pou\u017e\u00edv\u00e1n\u00ed rol\u00ed a datab\u00e1ze<\/strong><\/h2>\n\n\n\n<p>PostgreSQL pou\u017e\u00edv\u00e1 koncept rol\u00ed pro autentifikaci, kter\u00fd je podobn\u00fd tomu ze syst\u00e9mu zalo\u017een\u00e9m na Unixe \u2013 konkr\u00e9tn\u011b u\u017eivatel\u00e9 a skupiny. PostgreSQL tento koncept jednodu\u0161e sdru\u017e\u00ed do n\u00e1zvu role.<\/p>\n\n\n\n<p>Okam\u017eit\u011b po instalaci si PostgreSQL osvoj\u00ed u\u017eivatele, kter\u00e9 najde v syst\u00e9mu. To znamen\u00e1, \u017ee pokud byl u\u017eivatel u\u017e vytvo\u0159en\u00fd, PostgreSQL ho p\u0159ebere jako roli a umo\u017en\u00ed mu tak autentifikovat se a pou\u017e\u00edvat datab\u00e1zi. Vytvo\u0159\u00ed se i jeden speci\u00e1ln\u00ed \u00fa\u010det s n\u00e1zvem&nbsp;<em>postgres<\/em>, kter\u00fd je napojen\u00fd na stejnojmennou roli v datab\u00e1zi, aby tak umo\u017enil p\u0159\u00edstup k pr\u00e1ci po p\u0159ihl\u00e1\u0161en\u00ed se do tohoto \u00fa\u010dtu.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>P\u0159epnut\u00ed u\u017eivatelsk\u00e9ho \u00fa\u010dtu<\/strong><\/h2>\n\n\n\n<p>P\u0159epnut\u00ed na \u00fa\u010det&nbsp;<em>postgres&nbsp;<\/em>prob\u011bhne n\u00e1sleduj\u00edc\u00edm \u0159\u00e1dkem:&nbsp;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -i -u postgres<\/pre>\n\n\n\n<p>Te\u010f se m\u016f\u017eeme okam\u017eit\u011b p\u0159epnout do p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku PostgreSQL datab\u00e1ze. N\u00e1sledn\u011b m\u016f\u017eeme interagovat s datab\u00e1zov\u00fdm syst\u00e9mem, vykon\u00e1vat SQL p\u0159\u00edkazy a ovliv\u0148ovat existenci tabulek v datab\u00e1z\u00edch:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># psql<\/pre>\n\n\n\n<p>P\u0159\u00edkazy na p\u0159epnut\u00ed \u00fa\u010dtu a p\u0159ihl\u00e1\u0161en\u00ed se daj\u00ed vykonat i spole\u010dn\u011b:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -u postgres psql<\/pre>\n\n\n\n<p>Na ukon\u010den\u00ed pr\u00e1ce s PostgreSQL sta\u010d\u00ed zadat p\u0159\u00edkaz nebo stla\u010dit kl\u00e1vesovou zkratku Ctrl+D:&nbsp;<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># postgres=# \\g<\/pre>\n\n\n\n<p>P\u0159i pr\u00e1ci s PostgreSQL m\u016f\u017ee nastat situace, kdy je nutn\u00e9 vyu\u017e\u00edt v\u00edce rol\u00ed. Proto je d\u016fle\u017eit\u00e9 nau\u010dit se je mene\u017eovat a\u0165 u\u017e z pozice role&nbsp;<em>postgres,&nbsp;<\/em>nebo p\u0159\u00edmo p\u0159es termin\u00e1l. P\u0159id\u00e1v\u00e1n\u00ed rol\u00ed u\u017eivatel\u016f datab\u00e1zov\u00e9ho syst\u00e9mu nen\u00ed nic n\u00e1ro\u010dn\u00e9ho, sta\u010d\u00ed zadat n\u00e1sledovn\u00e9 p\u0159\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 zp\u016fsoby vyvolaj\u00ed dialog, ve kter\u00e9m u\u017eivatel dop\u00ed\u0161e jm\u00e9no u\u017eivatele a jestli mu chce ud\u011blit pr\u00e1va super administr\u00e1tora. Dialog vypad\u00e1 n\u00e1sledovn\u011b:<\/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 samoz\u0159ejm\u011b mo\u017en\u00e9 pou\u017e\u00edt v\u00edce typ\u016f p\u0159ep\u00edna\u010d\u016f, pro kompletn\u00ed seznam a pou\u017eit\u00ed je vhodn\u00e9 st\u00e1hnout po manu\u00e1lu PostgreSQL p\u0159\u00edmo p\u0159es termin\u00e1l zad\u00e1n\u00edm p\u0159\u00edkazu:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># man createuser<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Vytvo\u0159en\u00ed nov\u00e9 datab\u00e1ze<\/strong><\/h2>\n\n\n\n<p>Dal\u0161\u00ed p\u0159edpoklad, o kter\u00e9m Postgres uva\u017euje, je, \u017ee ka\u017ed\u00e1 role, kter\u00e1 se do syst\u00e9mu p\u0159ihla\u0161uje, m\u00e1 vlastn\u00ed datab\u00e1zi s stejnojmenn\u00fdm n\u00e1zvem.&nbsp;<\/p>\n\n\n\n<p>P\u0159edpokl\u00e1dejme, \u017ee role, kterou jsme vytvo\u0159ili v minul\u00e9m kroku, se naz\u00fdv\u00e1&nbsp;<em>test<\/em>. V tom p\u0159\u00edpad\u011b se bude PostgreSQL p\u0159i p\u0159ihl\u00e1\u0161en\u00ed pod touto rol\u00ed sna\u017eit p\u0159edvolen\u011b p\u0159ipojit do datab\u00e1ze se stejn\u00fdm n\u00e1zvem. Vytvo\u0159en\u00ed takov\u00fdch datab\u00e1z\u00ed prob\u00edh\u00e1 p\u0159\u00edkazem:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -u postgres createdb test<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Otev\u0159en\u00ed p\u0159\u00edkazov\u00e9ho \u0159\u00e1dku p\u0159es autentifikaci&nbsp;<em>ident<\/em><\/strong><\/h2>\n\n\n\n<p>P\u0159i p\u0159ihla\u0161ovan\u00ed se do datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL je mo\u017en\u00e9 vyu\u017e\u00edt takzvan\u00fd&nbsp;<em>ident<\/em>. Jeho p\u0159edpoklad je, \u017ee v po\u010d\u00edta\u010di u\u017e je u\u017eivatel, kter\u00fd m\u00e1 stejnojmennou roli v postgres syst\u00e9mu a stejn\u011b tak \u017ee existuje i p\u0159edvolen\u00e1 datab\u00e1ze. T\u00edmto zp\u016fsobem se tedy d\u00e1 p\u0159ihl\u00e1sit do datab\u00e1ze bez nutnosti zadan\u00ed hesla \u010di jak\u00e9koliv jin\u00e9 autentifikace. P\u0159\u00edkaz je jednoduch\u00fd:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># sudo -u test psql<\/pre>\n\n\n\n<p>P\u0159\u00edkaz&nbsp;<em>sudo -u<\/em>&nbsp;zm\u011bn\u00ed u\u017eivatele na toho, kter\u00fd n\u00e1sleduje jako parametr. N\u00e1sleduje p\u0159\u00edkaz&nbsp;<em>psql<\/em>, kter\u00fd spust\u00ed datab\u00e1zov\u00fd syst\u00e9m a automaticky p\u0159ihl\u00e1s\u00ed u\u017eivatele do stejnojmenn\u00e9 role a datab\u00e1ze. Datab\u00e1zi je v\u0161ak mo\u017en\u00e9 zm\u011bnit, a to p\u0159ep\u00edna\u010dem&nbsp;<em>-d<\/em>&nbsp;n\u00e1sledovan\u00fdm n\u00e1zvem datab\u00e1ze, do kter\u00e9 se chceme p\u0159ipojit. Otestov\u00e1n\u00ed p\u0159ipojen\u00ed je mo\u017en\u00e9 p\u0159\u00edkazem&nbsp;<em>\\conninfo<\/em>.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Vytv\u00e1\u0159en\u00ed a editace tabulek<\/strong><\/h2>\n\n\n\n<p>Kdy\u017e u\u017e jsme p\u0159ipojen\u00ed v datab\u00e1zi, je na\u010dase zkusit z\u00e1kladn\u00ed operace jako vytvo\u0159en\u00ed prostoru, kde si m\u016f\u017eeme uchov\u00e1vat data. Z\u00e1kladn\u00ed syntax je nasleduj\u00edc\u00ed:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE nazev_tabulky (\n Nazev_prvniho_sloupce typ_sloupce (maximalni delka) parametry_sloupce,\n nazev_druheho_sloupce typ_sloupce (maximalni delka),\n Nazev_tretiho_sloupce typ_sloupce (maximalni delka)\n\n);<\/pre>\n\n\n\n<p>Jako p\u0159\u00edklad si m\u016f\u017eeme p\u0159edstavit tabulku elektrospot\u0159ebi\u010d\u016f:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE elektrospotrebi\u010de(\n Id serial PRIMARY KEY,\n Nazev_spotrebice 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 d\u00e1le<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.org\/\" target=\"_blank\">Ofici\u00e1ln\u00ed str\u00e1nky projektu<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.org\/docs\/\" target=\"_blank\">Dokumentace<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"http:\/\/www.postgresqltutorial.com\/postgresql-cheat-sheet\/\" target=\"_blank\">Z\u00e1kladn\u00fd tah\u00e1k s p\u0159\u00edkazy<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/postgresweekly.com\/\" target=\"_blank\">Postgres Weekly<\/a>&nbsp;\u2013 emailov\u00fd newsletter s t\u00fddenn\u00edmi novinkami<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL&nbsp;(nebo t\u00e9\u017e naz\u00fdvan\u00fd Postgres) je&nbsp;typ&nbsp;objektov\u011b-rela\u010dn\u00edho syst\u00e9mu spr\u00e1vy datab\u00e1z\u00ed&nbsp;(z anglick\u00e9ho object-relationship database management system ORDBMS).&nbsp;PostgreSQL&nbsp;je uve\u0159ej\u0148ovan\u00e1 pod&nbsp;PostgreSQL licenc\u00ed, liber\u00e1ln\u00ed odr\u016fdou&nbsp;open-source&nbsp;syst\u00e9m\u016f.&nbsp;Pro koncov\u00e9ho u\u017eivatele to znamen\u00e1, \u017ee je zadarmo a jej\u00ed zdrojov\u00fd k\u00f3d je ve\u0159ejn\u011b dostupn\u00fd pro ka\u017ed\u00e9ho, kdo by n\u011bj m\u011bl z\u00e1jem pro p\u0159\u00edpadnou modifikaci. Pod pojmem&nbsp;rela\u010dn\u00ed datab\u00e1ze&nbsp;se rozum\u00ed m\u00edsto na ukl\u00e1d\u00e1n\u00ed&#8230;<\/p>\n","protected":false},"author":3,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[48],"ht-kb-tag":[],"class_list":["post-937","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-vps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS - Websupport Centrum n\u00e1pov\u011bdy<\/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.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS - Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL&nbsp;(nebo t\u00e9\u017e naz\u00fdvan\u00fd Postgres) je&nbsp;typ&nbsp;objektov\u011b-rela\u010dn\u00edho syst\u00e9mu spr\u00e1vy datab\u00e1z\u00ed&nbsp;(z anglick\u00e9ho object-relationship database management system ORDBMS).&nbsp;PostgreSQL&nbsp;je uve\u0159ej\u0148ovan\u00e1 pod&nbsp;PostgreSQL licenc\u00ed, liber\u00e1ln\u00ed odr\u016fdou&nbsp;open-source&nbsp;syst\u00e9m\u016f.&nbsp;Pro koncov\u00e9ho u\u017eivatele to znamen\u00e1, \u017ee je zadarmo a jej\u00ed zdrojov\u00fd k\u00f3d je ve\u0159ejn\u011b dostupn\u00fd pro ka\u017ed\u00e9ho, kdo by n\u011bj m\u011bl z\u00e1jem pro p\u0159\u00edpadnou modifikaci. Pod pojmem&nbsp;rela\u010dn\u00ed datab\u00e1ze&nbsp;se rozum\u00ed m\u00edsto na ukl\u00e1d\u00e1n\u00ed...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-12T12:04:48+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\\\/\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\\\/\",\"name\":\"Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS - Websupport Centrum n\u00e1pov\u011bdy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/#website\"},\"datePublished\":\"2021-04-29T11:46:44+00:00\",\"dateModified\":\"2021-10-12T12:04:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\\\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/\",\"name\":\"Websupport Centrum n\u00e1pov\u011bdy\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS - Websupport Centrum n\u00e1pov\u011bdy","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.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/","og_locale":"cs_CZ","og_type":"article","og_title":"Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS - Websupport Centrum n\u00e1pov\u011bdy","og_description":"PostgreSQL&nbsp;(nebo t\u00e9\u017e naz\u00fdvan\u00fd Postgres) je&nbsp;typ&nbsp;objektov\u011b-rela\u010dn\u00edho syst\u00e9mu spr\u00e1vy datab\u00e1z\u00ed&nbsp;(z anglick\u00e9ho object-relationship database management system ORDBMS).&nbsp;PostgreSQL&nbsp;je uve\u0159ej\u0148ovan\u00e1 pod&nbsp;PostgreSQL licenc\u00ed, liber\u00e1ln\u00ed odr\u016fdou&nbsp;open-source&nbsp;syst\u00e9m\u016f.&nbsp;Pro koncov\u00e9ho u\u017eivatele to znamen\u00e1, \u017ee je zadarmo a jej\u00ed zdrojov\u00fd k\u00f3d je ve\u0159ejn\u011b dostupn\u00fd pro ka\u017ed\u00e9ho, kdo by n\u011bj m\u011bl z\u00e1jem pro p\u0159\u00edpadnou modifikaci. Pod pojmem&nbsp;rela\u010dn\u00ed datab\u00e1ze&nbsp;se rozum\u00ed m\u00edsto na ukl\u00e1d\u00e1n\u00ed...","og_url":"https:\/\/www.websupport.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/","og_site_name":"Websupport Centrum n\u00e1pov\u011bdy","article_modified_time":"2021-10-12T12:04:48+00:00","twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"4 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/","url":"https:\/\/www.websupport.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/","name":"Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS - Websupport Centrum n\u00e1pov\u011bdy","isPartOf":{"@id":"https:\/\/www.websupport.cz\/podpora\/#website"},"datePublished":"2021-04-29T11:46:44+00:00","dateModified":"2021-10-12T12:04:48+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/instalace-a-pouzivani-databaze-postgresql-na-ubuntu-18-04-lts\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/podpora\/"},{"@type":"ListItem","position":2,"name":"Instalace a pou\u017e\u00edv\u00e1n\u00ed datab\u00e1ze PostgreSQL na Ubuntu 18.04 LTS"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.cz\/podpora\/#website","url":"https:\/\/www.websupport.cz\/podpora\/","name":"Websupport Centrum n\u00e1pov\u011bdy","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.cz\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/937","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":2,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/937\/revisions"}],"predecessor-version":[{"id":7058,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/937\/revisions\/7058"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/media?parent=937"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=937"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=937"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}