{"id":18174,"date":"2023-07-28T10:37:14","date_gmt":"2023-07-28T10:37:14","guid":{"rendered":"https:\/\/soloweb.com.br\/blog\/?p=18174"},"modified":"2023-08-01T13:52:44","modified_gmt":"2023-08-01T13:52:44","slug":"como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/","title":{"rendered":"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04"},"content":{"rendered":"\n<p>No tutorial de hoje vamos ensinar como atualizar seu Postgres para a vers\u00e3o mais atual.<\/p>\n\n\n\n<p>Precisando de ajuda para gerenciar seu Banco de Dados PostgreSQL ou se servidor? Entre em contato conosco, temos o prazer em ajudar. Acesse <a href=\"https:\/\/soloweb.com.br\" class=\"ek-link\">soloweb.com.br<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Passo 1<\/h2>\n\n\n\n<p>Realize a instala\u00e7\u00e3o do Postgres mais atual, para isso ser\u00e1 necess\u00e1rio antes atualizar os pacotes:<\/p>\n\n\n\n<p>obs.: Antes de qualquer modifica\u00e7\u00e3o sempre \u00e9 bom realizar os backups das bases de dados:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>su postgres -c \"pg_dump -F tar -d basededados &gt; basededados.backup\"<\/code><\/pre>\n\n\n\n<p>Continuemos com o procedimento de atualiza\u00e7\u00e3o:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ apt-get update\n$ apt-get upgrade<\/code><\/pre>\n\n\n\n<p>Agora realize a instala\u00e7\u00e3o:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ apt-get install -y postgresql-15<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Passo 2<\/h2>\n\n\n\n<p>Agora ap\u00f3s instalado vamos certificar os clusters que s\u00e3o a instala\u00e7\u00e3o em sua m\u00e1quina.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ pg_lsclusters\n#a sa\u00edda ficar\u00e1 mais ou menos assim\nVer Cluster Port Status Owner    Data directory               Log file\n14 main    5432 online postgres \/var\/lib\/postgresql\/14\/main \/var\/log\/postgresql\/postgresql-14-main.log\n15 main    5433 online postgres \/var\/lib\/postgresql\/15\/main \/var\/log\/postgresql\/postgresql-15-main.log<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Passo 3 <\/h2>\n\n\n\n<p>Agora vamos parar o servi\u00e7o de banco na sua m\u00e1quina\/servidor:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ service postgresql stop<\/code><\/pre>\n\n\n\n<p>Veja tamb\u00e9m:<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-soloweb-tecnologia wp-block-embed-soloweb-tecnologia\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"cxJnIEscw0\"><a href=\"https:\/\/soloweb.com.br\/blog\/2023\/07\/18\/diferenca-entre-os-comandos-copy-e-copy-no-postgresql\/\">Diferen\u00e7a entre os comandos copy e copy no PostgreSQL<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Diferen\u00e7a entre os comandos copy e copy no PostgreSQL&#8221; &#8212; SOLOWEB Tecnologia\" src=\"https:\/\/soloweb.com.br\/blog\/2023\/07\/18\/diferenca-entre-os-comandos-copy-e-copy-no-postgresql\/embed\/#?secret=EXXuorPdvW#?secret=cxJnIEscw0\" data-secret=\"cxJnIEscw0\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Passo 4<\/h2>\n\n\n\n<p>Renomeie a nova vers\u00e3o padr\u00e3o instalada do cluster:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ pg_renamecluster 15 main main_pristine<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Passo 5<\/h2>\n\n\n\n<p>Atualize a vers\u00e3o do cluster antigo para a vers\u00e3o mais recente:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ pg_upgradecluster 14 main<\/code><\/pre>\n\n\n\n<p>obs.: lembre-se de substituir o 14 por sua antiga vers\u00e3o.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Passo 6<\/h2>\n\n\n\n<p>Agora ap\u00f3s atualizado, vamos iniciar novamente o Postgres:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ service postgresql start<\/code><\/pre>\n\n\n\n<p>Verifique se est\u00e1 atualizado:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ pg_lsclusters\nVer Cluster       Port Status Owner    Data directory                       Log file\n14  main          5434 down   postgres \/var\/lib\/postgresql\/14\/main          \/var\/log\/postgresql\/postgresql-14-main.log\n15  main          5432 online postgres \/var\/lib\/postgresql\/15\/main          \/var\/log\/postgresql\/postgresql-15-main.log\n15  main_pristine 5433 online postgres \/var\/lib\/postgresql\/15\/main_pristine \/var\/log\/postgresql\/postgresql-15-main_pristine.log<\/code><\/pre>\n\n\n\n<p>Voc\u00ea vai ver que antiga vers\u00e3o n\u00e3o est\u00e1 sendo mais usada, e um novo cluster foi criado para nova vers\u00e3o.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Passo 7<\/h2>\n\n\n\n<p>Ap\u00f3s tudo atualizado vamos remover os cluster inativos:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ pg_dropcluster 14 main --stop\n\n$ pg_dropcluster 15 main_pristine --stop<\/code><\/pre>\n\n\n\n<p>Pronto, seu Postgres foi atualizado e agora poder\u00e1 trabalhar tranquilamente.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>No tutorial de hoje vamos ensinar como atualizar seu Postgres para a vers\u00e3o mais atual. Precisando de ajuda para gerenciar<\/p>\n","protected":false},"author":5,"featured_media":18178,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","footnotes":""},"categories":[249,302,303,131,118,264],"tags":[411,115,172,144,412,154],"class_list":["post-18174","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-banco-de-dados","category-destaque-principal","category-destaque-secundario","category-gerenciamento","category-performance","category-servidores","tag-banco-de-dados-2","tag-dicas","tag-gerenciamento","tag-linux","tag-postgres","tag-ubuntu"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Como fazer o upgrade do PostgreSQL no Ubuntu 20.04 - SOLOWEB Tecnologia<\/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:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04 - SOLOWEB Tecnologia\" \/>\n<meta property=\"og:description\" content=\"No tutorial de hoje vamos ensinar como atualizar seu Postgres para a vers\u00e3o mais atual. Precisando de ajuda para gerenciar\" \/>\n<meta property=\"og:url\" content=\"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/\" \/>\n<meta property=\"og:site_name\" content=\"SOLOWEB Tecnologia\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T10:37:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-01T13:52:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/07\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"940\" \/>\n\t<meta property=\"og:image:height\" content=\"787\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ademilton Filho\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ademilton Filho\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/\"},\"author\":{\"name\":\"Ademilton Filho\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/f868b83846c5e132dde12db8492335df\"},\"headline\":\"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04\",\"datePublished\":\"2023-07-28T10:37:14+00:00\",\"dateModified\":\"2023-08-01T13:52:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/\"},\"wordCount\":229,\"publisher\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg\",\"keywords\":[\"banco-de-dados\",\"dicas\",\"gerenciamento\",\"linux\",\"postgres\",\"ubuntu\"],\"articleSection\":[\"Banco de dados\",\"Destaque Principal\",\"Destaque Secund\u00e1rio\",\"Gerenciamento\",\"Performance\",\"Servidores\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/\",\"url\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/\",\"name\":\"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04 - SOLOWEB Tecnologia\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg\",\"datePublished\":\"2023-07-28T10:37:14+00:00\",\"dateModified\":\"2023-08-01T13:52:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg\",\"contentUrl\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg\",\"width\":940,\"height\":787},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/2023\\\/07\\\/28\\\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/\",\"name\":\"SOLOWEB Tecnologia\",\"description\":\"SOLOWEB Tecnologia\",\"publisher\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#organization\",\"name\":\"SOLOWEB Tecnologia\",\"url\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/cropped-solo.png\",\"contentUrl\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/cropped-solo.png\",\"width\":341,\"height\":94,\"caption\":\"SOLOWEB Tecnologia\"},\"image\":{\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/#\\\/schema\\\/person\\\/f868b83846c5e132dde12db8492335df\",\"name\":\"Ademilton Filho\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/avatar_user_5_1674994251-96x96.png\",\"url\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/avatar_user_5_1674994251-96x96.png\",\"contentUrl\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/avatar_user_5_1674994251-96x96.png\",\"caption\":\"Ademilton Filho\"},\"sameAs\":[\"http:\\\/\\\/ademiltonsoftware.tk\"],\"url\":\"https:\\\/\\\/soloweb.com.br\\\/blog\\\/author\\\/ademilton\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04 - SOLOWEB Tecnologia","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:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/","og_locale":"pt_BR","og_type":"article","og_title":"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04 - SOLOWEB Tecnologia","og_description":"No tutorial de hoje vamos ensinar como atualizar seu Postgres para a vers\u00e3o mais atual. Precisando de ajuda para gerenciar","og_url":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/","og_site_name":"SOLOWEB Tecnologia","article_published_time":"2023-07-28T10:37:14+00:00","article_modified_time":"2023-08-01T13:52:44+00:00","og_image":[{"width":940,"height":787,"url":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/07\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg","type":"image\/jpeg"}],"author":"Ademilton Filho","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Ademilton Filho","Est. tempo de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/#article","isPartOf":{"@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/"},"author":{"name":"Ademilton Filho","@id":"https:\/\/soloweb.com.br\/blog\/#\/schema\/person\/f868b83846c5e132dde12db8492335df"},"headline":"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04","datePublished":"2023-07-28T10:37:14+00:00","dateModified":"2023-08-01T13:52:44+00:00","mainEntityOfPage":{"@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/"},"wordCount":229,"publisher":{"@id":"https:\/\/soloweb.com.br\/blog\/#organization"},"image":{"@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/07\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg","keywords":["banco-de-dados","dicas","gerenciamento","linux","postgres","ubuntu"],"articleSection":["Banco de dados","Destaque Principal","Destaque Secund\u00e1rio","Gerenciamento","Performance","Servidores"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/","url":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/","name":"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04 - SOLOWEB Tecnologia","isPartOf":{"@id":"https:\/\/soloweb.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/#primaryimage"},"image":{"@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/07\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg","datePublished":"2023-07-28T10:37:14+00:00","dateModified":"2023-08-01T13:52:44+00:00","breadcrumb":{"@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/#primaryimage","url":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/07\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg","contentUrl":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/07\/WhatsApp-Image-2023-07-28-at-07.33.43.jpeg","width":940,"height":787},{"@type":"BreadcrumbList","@id":"https:\/\/soloweb.com.br\/blog\/2023\/07\/28\/como-fazer-o-upgrade-do-postgresql-no-ubuntu-20-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/soloweb.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Como fazer o upgrade do PostgreSQL no Ubuntu 20.04"}]},{"@type":"WebSite","@id":"https:\/\/soloweb.com.br\/blog\/#website","url":"https:\/\/soloweb.com.br\/blog\/","name":"SOLOWEB Tecnologia","description":"SOLOWEB Tecnologia","publisher":{"@id":"https:\/\/soloweb.com.br\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/soloweb.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/soloweb.com.br\/blog\/#organization","name":"SOLOWEB Tecnologia","url":"https:\/\/soloweb.com.br\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/soloweb.com.br\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2022\/04\/cropped-solo.png","contentUrl":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2022\/04\/cropped-solo.png","width":341,"height":94,"caption":"SOLOWEB Tecnologia"},"image":{"@id":"https:\/\/soloweb.com.br\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/soloweb.com.br\/blog\/#\/schema\/person\/f868b83846c5e132dde12db8492335df","name":"Ademilton Filho","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/01\/avatar_user_5_1674994251-96x96.png","url":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/01\/avatar_user_5_1674994251-96x96.png","contentUrl":"https:\/\/soloweb.com.br\/blog\/wp-content\/uploads\/2023\/01\/avatar_user_5_1674994251-96x96.png","caption":"Ademilton Filho"},"sameAs":["http:\/\/ademiltonsoftware.tk"],"url":"https:\/\/soloweb.com.br\/blog\/author\/ademilton\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/posts\/18174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/comments?post=18174"}],"version-history":[{"count":2,"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/posts\/18174\/revisions"}],"predecessor-version":[{"id":18179,"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/posts\/18174\/revisions\/18179"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/media\/18178"}],"wp:attachment":[{"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/media?parent=18174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/categories?post=18174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soloweb.com.br\/blog\/wp-json\/wp\/v2\/tags?post=18174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}