{"id":26106,"date":"2023-07-31T07:24:00","date_gmt":"2023-07-31T06:24:00","guid":{"rendered":"https:\/\/quike.it\/es\/?p=26106"},"modified":"2023-11-27T13:17:30","modified_gmt":"2023-11-27T12:17:30","slug":"actualizar-postgresql-en-ubuntu-server","status":"publish","type":"post","link":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/","title":{"rendered":"Actualizar PostgreSQL en UBUNTU Server"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"26106\" class=\"elementor elementor-26106\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-588ac3e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"588ac3e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f7a2611\" data-id=\"f7a2611\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1134f64 elementor-widget elementor-widget-text-editor\" data-id=\"1134f64\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><a href=\"https:\/\/quike.it\/es\/postgresql-mi-base-de-datos-favorita\/\" target=\"_blank\" rel=\"noopener\"><strong>PostgreSQL,<\/strong><\/a> uno de los sistemas de <strong>gesti\u00f3n de bases de datos<\/strong> m\u00e1s poderosos y confiables, es ampliamente utilizado en aplicaciones empresariales y proyectos de software en todo el mundo.<\/p><p>Con cada nueva versi\u00f3n, <strong>PostgreSQL<\/strong> trae consigo una variedad de mejoras, caracter\u00edsticas y optimizaciones que mejoran su rendimiento y funcionalidad.<\/p><p>En este art\u00edculo, exploraremos el proceso para <strong>actualizar PostgreSQL en Ubuntu Server<\/strong>, espec\u00edficamente, la transici\u00f3n desde la <strong>versi\u00f3n 12<\/strong> a la <strong>versi\u00f3n 14<\/strong>.<\/p><p>La actualizaci\u00f3n de <strong>PostgreSQL<\/strong> a la versi\u00f3n m\u00e1s reciente no solo ofrece beneficios en t\u00e9rminos de seguridad y estabilidad, sino que tambi\u00e9n brinda acceso a nuevas caracter\u00edsticas y mejoras de rendimiento.<\/p><p>Sin embargo, realizar una actualizaci\u00f3n de este tipo requiere una planificaci\u00f3n cuidadosa y una serie de pasos a seguir para garantizar un proceso fluido y sin complicaciones.<\/p><p>En esta gu\u00eda, realizaremos cada paso del camino para <strong>actualizar PostgreSQL en tu servidor Ubuntu<\/strong> desde la <strong>versi\u00f3n 12<\/strong> a la <strong>versi\u00f3n 14<\/strong>.<\/p><p>Antes de comenzar se aconseja realizar una copia de seguridad del <em><strong>Cluster.<\/strong><\/em><\/p><p>En el contexto de <strong>PostgreSQL,<\/strong> un <strong><em>\u00abcluster\u00bb<\/em><\/strong> se refiere a una colecci\u00f3n de <strong>bases de datos<\/strong> que est\u00e1n administradas y controladas por una \u00fanica instancia del servidor de <strong>PostgreSQL.<\/strong><\/p><p>El t\u00e9rmino <strong><em>\u00abcluster\u00bb<\/em><\/strong> no debe confundirse con el concepto de <em><strong>\u00abcl\u00faster\u00bb<\/strong><\/em> utilizado en la inform\u00e1tica para referirse a un grupo de computadoras trabajando juntas para proporcionar alta disponibilidad o mayor capacidad de procesamiento.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8c3014 elementor-widget elementor-widget-global elementor-global-23404 elementor-widget-table-of-contents\" data-id=\"a8c3014\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;container&quot;:&quot;.articulo&quot;,&quot;marker_view&quot;:&quot;bullets&quot;,&quot;no_headings_message&quot;:&quot;No headings were found on this page.&quot;,&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;icon&quot;:{&quot;value&quot;:&quot;fas fa-circle&quot;,&quot;library&quot;:&quot;fa-solid&quot;},&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tINDICE\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__a8c3014\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<svg class=\"elementor-toc__spinner eicon-animation-spin e-font-icon-svg e-eicon-loading\" aria-hidden=\"true\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M500 975V858C696 858 858 696 858 500S696 142 500 142 142 304 142 500H25C25 237 238 25 500 25S975 237 975 500 763 975 500 975Z\"><\/path><\/svg>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-65f1859 articulo elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65f1859\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a2e2d12\" data-id=\"a2e2d12\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-121803e elementor-widget elementor-widget-heading\" data-id=\"121803e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Actualizar PostgreSQL en UBUNTU Server - Versi\u00f3n 12 a 14<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d728877 elementor-widget elementor-widget-text-editor\" data-id=\"d728877\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Una vez que se ha <a href=\"https:\/\/quike.it\/es\/como-actualizar-ubuntu-server-20-04-a-22-04\/\" target=\"_blank\" rel=\"noopener\"><strong>actualizado el servidor UBUNTU a la versi\u00f3n 22.04<\/strong><\/a> <strong>(<em>Jammy Jellyfish<\/em>)<\/strong> si la versi\u00f3n de <strong>PostgreSQL<\/strong> instalada en el servidor es inferior a la <strong>versi\u00f3n 14<\/strong>, el proceso de instalaci\u00f3n debi\u00f3 mostrar una secci\u00f3n similar a la siguiente <a href=\"https:\/\/quike.it\/es\/como-hacer-la-captura-de-pantalla-en-windows\/\" target=\"_blank\" rel=\"noopener\"><strong>captura de pantalla<\/strong><\/a>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6fdda05 elementor-widget elementor-widget-image\" data-id=\"6fdda05\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-20.04_17_07_2023_22_53_16.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"VirtualBox_Ubuntu Server 20.04_17_07_2023_22_53_16\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjU5MzksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIzXC8wN1wvVmlydHVhbEJveF9VYnVudHUtU2VydmVyLTIwLjA0XzE3XzA3XzIwMjNfMjJfNTNfMTYucG5nIn0%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"600\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-20.04_17_07_2023_22_53_16.png\" class=\"attachment-full size-full wp-image-25939\" alt=\"actualizar ubuntu server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-20.04_17_07_2023_22_53_16.png 800w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-20.04_17_07_2023_22_53_16-300x225.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-20.04_17_07_2023_22_53_16-768x576.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ad6c568 elementor-widget elementor-widget-text-editor\" data-id=\"ad6c568\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Seguimos entonces los pasos que se nos indican en el mensaje.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c97cd83 elementor-widget elementor-widget-heading\" data-id=\"c97cd83\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Instalar PostgreSQL 14<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f58b35c elementor-widget elementor-widget-text-editor\" data-id=\"f58b35c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>El primer paso es <strong>instalar la versi\u00f3n 14<\/strong> de <strong>PostgreSQL.<\/strong> Para esto ejecutamos el comando de instalaci\u00f3n:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ec499f elementor-widget elementor-widget-code-highlight\" data-id=\"2ec499f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo apt-get install postgresql-14<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0226db9 elementor-widget elementor-widget-image\" data-id=\"0226db9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_05_14.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"VirtualBox_Ubuntu Server 22.04.2_19_07_2023_19_05_14\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjYxMTYsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIzXC8wN1wvVmlydHVhbEJveF9VYnVudHUtU2VydmVyLTIyLjA0LjJfMTlfMDdfMjAyM18xOV8wNV8xNC5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"247\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_05_14.png\" class=\"attachment-full size-full wp-image-26116\" alt=\"Actualizar PostgreSQL en UBUNTU\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_05_14.png 800w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_05_14-300x93.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_05_14-768x237.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d79ac3e elementor-widget elementor-widget-text-editor\" data-id=\"d79ac3e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Para una mayor informaci\u00f3n puedes consultar la gu\u00eda <a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-linux\/\" target=\"_blank\" rel=\"noopener\"><strong>C\u00f3mo instalar PostgreSQL en Linux<\/strong><\/a>, la cual aplica a cualquier versi\u00f3n de <strong>PostgreSQL.<\/strong><\/p><p>Una vez que hemos realizado la instalaci\u00f3n, verificamos que ambas versiones est\u00e9n ejecut\u00e1ndose por medio del siguiente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-27dac02 elementor-widget elementor-widget-code-highlight\" data-id=\"27dac02\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>dpkg -l | grep postgresql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d22a89 elementor-widget elementor-widget-image\" data-id=\"8d22a89\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_13_26.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"VirtualBox_Ubuntu Server 22.04.2_19_07_2023_19_13_26\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjYxMTcsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIzXC8wN1wvVmlydHVhbEJveF9VYnVudHUtU2VydmVyLTIyLjA0LjJfMTlfMDdfMjAyM18xOV8xM18yNi5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"247\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_13_26.png\" class=\"attachment-full size-full wp-image-26117\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_13_26.png 800w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_13_26-300x93.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_13_26-768x237.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be27a8b elementor-widget elementor-widget-text-editor\" data-id=\"be27a8b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Confirmamos las rutas en donde est\u00e1n los <em><strong>clusters<\/strong><\/em> de ambas versiones con el siguiente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a964c8 elementor-widget elementor-widget-code-highlight\" data-id=\"0a964c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>pg_lsclusters<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1da7f27 elementor-widget elementor-widget-image\" data-id=\"1da7f27\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_51_49.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"VirtualBox_Ubuntu Server 22.04.2_19_07_2023_19_51_49\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjYxMTgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIzXC8wN1wvVmlydHVhbEJveF9VYnVudHUtU2VydmVyLTIyLjA0LjJfMTlfMDdfMjAyM18xOV81MV80OS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"126\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_51_49.png\" class=\"attachment-full size-full wp-image-26118\" alt=\"Actualizar PostgreSQL en UBUNTU\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_51_49.png 800w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_51_49-300x47.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_19_51_49-768x121.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ff2400 elementor-widget elementor-widget-text-editor\" data-id=\"2ff2400\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Una vez que hemos confirmado que ambas versiones est\u00e1n funcionando, podemos pasar al siguiente paso.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7167368 elementor-widget elementor-widget-heading\" data-id=\"7167368\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Detener y eliminar el cl\u00faster de la versi\u00f3n 14<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-045c058 elementor-widget elementor-widget-text-editor\" data-id=\"045c058\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>En la <strong>versi\u00f3n 14<\/strong>, ya se encuentra disponible un <strong>cl\u00faster<\/strong> denominado <strong>\u00abmain\u00bb,<\/strong> que se crea autom\u00e1ticamente durante la instalaci\u00f3n del paquete.<\/p><p>Esta configuraci\u00f3n predeterminada permite que la nueva instalaci\u00f3n funcione sin problemas, sin necesidad de crear un <strong>cl\u00faster<\/strong> previamente.<\/p><p>Sin embargo, esta situaci\u00f3n puede ocasionar conflictos cuando se intenta actualizar desde la versi\u00f3n <em><strong>12\/main<\/strong><\/em>, mientras tambi\u00e9n existe el cl\u00faster <em><strong>14\/main<\/strong><\/em>.<\/p><p>Para resolver este inconveniente, se recomienda seguir el procedimiento de eliminar el <strong>cl\u00faster 14<\/strong> mediante <em><strong>pg_dropcluster<\/strong><\/em> y luego realizar la actualizaci\u00f3n utilizando <em><strong>pg_upgradecluster.<\/strong><\/em><\/p><p>De esta manera, se evitar\u00e1n problemas y se podr\u00e1 completar la actualizaci\u00f3n de forma adecuada.<\/p><p>Utilizamos entonces el comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-659d00f elementor-widget elementor-widget-code-highlight\" data-id=\"659d00f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo pg_dropcluster 14 main --stop<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-268766d elementor-widget elementor-widget-text-editor\" data-id=\"268766d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>y despu\u00e9s para actualizar el <strong>cl\u00faster 12<\/strong> a la <strong>versi\u00f3n 14:<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e4c6005 elementor-widget elementor-widget-code-highlight\" data-id=\"e4c6005\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo pg_upgradecluster 12 main<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ec76bd elementor-widget elementor-widget-image\" data-id=\"5ec76bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_06_36.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"VirtualBox_Ubuntu Server 22.04.2_19_07_2023_20_06_36\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjYxMTksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIzXC8wN1wvVmlydHVhbEJveF9VYnVudHUtU2VydmVyLTIyLjA0LjJfMTlfMDdfMjAyM18yMF8wNl8zNi5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"600\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_06_36.png\" class=\"attachment-full size-full wp-image-26119\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_06_36.png 800w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_06_36-300x225.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_06_36-768x576.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c491969 elementor-widget elementor-widget-text-editor\" data-id=\"c491969\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Para confirmar que nuestro <strong>cl\u00faster 12<\/strong> est\u00e1 inactivo, puedes ejecutar el comando <em><strong>pg_lsclusters.<\/strong><\/em><\/p><p>De esta manera, podr\u00e1s verificar f\u00e1cilmente su estado actual.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d4d0b2 elementor-widget elementor-widget-image\" data-id=\"6d4d0b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_11_58.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"VirtualBox_Ubuntu Server 22.04.2_19_07_2023_20_11_58\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjYxMjAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIzXC8wN1wvVmlydHVhbEJveF9VYnVudHUtU2VydmVyLTIyLjA0LjJfMTlfMDdfMjAyM18yMF8xMV81OC5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"138\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_11_58.png\" class=\"attachment-full size-full wp-image-26120\" alt=\"Actualizar PostgreSQL en UBUNTU\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_11_58.png 800w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_11_58-300x52.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_11_58-768x132.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec87249 elementor-widget elementor-widget-text-editor\" data-id=\"ec87249\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Despu\u00e9s de actualizar el <strong>cl\u00faster,<\/strong> es importante verificar que est\u00e9 funcionando correctamente.<\/p><p>Una vez que hayas confirmado su correcto funcionamiento, puedes proceder a eliminar el <strong>cl\u00faster 12<\/strong>\u00a0para mantener una configuraci\u00f3n limpia y actualizada.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d0aab7a elementor-widget elementor-widget-code-highlight\" data-id=\"d0aab7a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo pg_dropcluster 12 main<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4fcd3e3 elementor-widget elementor-widget-heading\" data-id=\"4fcd3e3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Eliminar paquetes obsoletos<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02115ea elementor-widget elementor-widget-text-editor\" data-id=\"02115ea\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>Una vez que hayas verificado todos tus datos, puedes proceder a eliminar los paquetes antiguos.<\/p><p>Es importante asegurarse de que ya no necesitas esa informaci\u00f3n antes de eliminarla definitivamente.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-31bf2be elementor-widget elementor-widget-code-highlight\" data-id=\"31bf2be\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo apt-get purge postgresql-12 postgresql-client-12<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40325a4 elementor-widget elementor-widget-image\" data-id=\"40325a4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_17_30.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"VirtualBox_Ubuntu Server 22.04.2_19_07_2023_20_17_30\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjYxMjQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIzXC8wN1wvVmlydHVhbEJveF9VYnVudHUtU2VydmVyLTIyLjA0LjJfMTlfMDdfMjAyM18yMF8xN18zMC5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"399\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_17_30.png\" class=\"attachment-full size-full wp-image-26124\" alt=\"Actualizar PostgreSQL en UBUNTU\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_17_30.png 800w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_17_30-300x150.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/07\/VirtualBox_Ubuntu-Server-22.04.2_19_07_2023_20_17_30-768x383.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>PostgreSQL, uno de los sistemas de gesti\u00f3n de bases de datos m\u00e1s poderosos y confiables, es ampliamente utilizado en aplicaciones empresariales y proyectos de software en todo el mundo. Con cada nueva versi\u00f3n, PostgreSQL trae consigo una variedad de mejoras, caracter\u00edsticas y optimizaciones que mejoran su rendimiento y funcionalidad. En este art\u00edculo, exploraremos el proceso [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":13912,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[12,88],"tags":[],"class_list":["post-26106","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-ubuntu"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Actualizar PostgreSQL en UBUNTU Server - Enrique V\u00e1squez -<\/title>\n<meta name=\"description\" content=\"...exploraremos el proceso para actualizar PostgreSQL en Ubuntu Server, espec\u00edficamente, la transici\u00f3n desde la versi\u00f3n 12 a la versi\u00f3n 14.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Actualizar PostgreSQL en UBUNTU Server\" \/>\n<meta property=\"og:description\" content=\"En este art\u00edculo, exploraremos el proceso para actualizar PostgreSQL en Ubuntu Server, espec\u00edficamente, la transici\u00f3n desde la versi\u00f3n 12 a la versi\u00f3n 14.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/\" \/>\n<meta property=\"og:site_name\" content=\"El BLOG de Enrique V\u00e1squez B.\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/zeven.sa.1\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/zeven.sa.1\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-31T06:24:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-27T12:17:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Enrique V\u00e1squez B.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Actualizar PostgreSQL en UBUNTU Server\" \/>\n<meta name=\"twitter:description\" content=\"En este art\u00edculo, exploraremos el proceso para actualizar PostgreSQL en Ubuntu Server, espec\u00edficamente, la transici\u00f3n desde la versi\u00f3n 12 a la versi\u00f3n 14.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png\" \/>\n<meta name=\"twitter:creator\" content=\"@quike1974\" \/>\n<meta name=\"twitter:site\" content=\"@quike1974\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Enrique V\u00e1squez B.\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/\"},\"author\":{\"name\":\"Enrique V\u00e1squez B.\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#\\\/schema\\\/person\\\/e53c62e8ab2e3f878e77d3a617483cc8\"},\"headline\":\"Actualizar PostgreSQL en UBUNTU Server\",\"datePublished\":\"2023-07-31T06:24:00+00:00\",\"dateModified\":\"2023-11-27T12:17:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/\"},\"wordCount\":655,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#\\\/schema\\\/person\\\/e53c62e8ab2e3f878e77d3a617483cc8\"},\"image\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgresql_frame1.png\",\"articleSection\":[\"PostgreSQL\",\"Ubuntu\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/#respond\"]}]},{\"@type\":[\"WebPage\",\"ItemPage\"],\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/\",\"url\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/\",\"name\":\"Actualizar PostgreSQL en UBUNTU Server - Enrique V\u00e1squez -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgresql_frame1.png\",\"datePublished\":\"2023-07-31T06:24:00+00:00\",\"dateModified\":\"2023-11-27T12:17:30+00:00\",\"description\":\"...exploraremos el proceso para actualizar PostgreSQL en Ubuntu Server, espec\u00edficamente, la transici\u00f3n desde la versi\u00f3n 12 a la versi\u00f3n 14.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgresql_frame1.png\",\"contentUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgresql_frame1.png\",\"width\":900,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/actualizar-postgresql-en-ubuntu-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/quike.it\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Inform\u00e1tica\",\"item\":\"https:\\\/\\\/quike.it\\\/es\\\/category\\\/informatica\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Bases de Datos\",\"item\":\"https:\\\/\\\/quike.it\\\/es\\\/category\\\/informatica\\\/bases-de-datos\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"PostgreSQL\",\"item\":\"https:\\\/\\\/quike.it\\\/es\\\/category\\\/informatica\\\/bases-de-datos\\\/postgresql\\\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Actualizar PostgreSQL en UBUNTU Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/quike.it\\\/es\\\/\",\"name\":\"El BLOG de Enrique V\u00e1squez B.\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#\\\/schema\\\/person\\\/e53c62e8ab2e3f878e77d3a617483cc8\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quike.it\\\/es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#\\\/schema\\\/person\\\/e53c62e8ab2e3f878e77d3a617483cc8\",\"name\":\"Enrique V\u00e1squez B.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2021\\\/02\\\/me.png\",\"url\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2021\\\/02\\\/me.png\",\"contentUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2021\\\/02\\\/me.png\",\"width\":512,\"height\":512,\"caption\":\"Enrique V\u00e1squez B.\"},\"logo\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2021\\\/02\\\/me.png\"},\"description\":\"Programador desde 1988, con pasi\u00f3n por escribir art\u00edculos de todo tipo. Actualmente desarrolla para ZEVEN S.A. el Sistema de Facturaci\u00f3n Electr\u00f3nica. Ecuatoriano de nacimiento e italiano de residencia, escribe desde G\u00e9nova, ciudad que ha llegado a amar tanto como su natal Guayaquil. Padre de dos hijos que son su orgullo y esposo de una mujer excepcional.\",\"sameAs\":[\"https:\\\/\\\/quike.it\",\"https:\\\/\\\/www.facebook.com\\\/zeven.sa.1\",\"https:\\\/\\\/www.instagram.com\\\/quikev1974\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/carlos-enrique-vasquez-bautista-074893b\\\/\",\"https:\\\/\\\/x.com\\\/quike1974\"],\"url\":\"https:\\\/\\\/quike.it\\\/es\\\/author\\\/quike\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Actualizar PostgreSQL en UBUNTU Server - Enrique V\u00e1squez -","description":"...exploraremos el proceso para actualizar PostgreSQL en Ubuntu Server, espec\u00edficamente, la transici\u00f3n desde la versi\u00f3n 12 a la versi\u00f3n 14.","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:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/","og_locale":"es_ES","og_type":"article","og_title":"Actualizar PostgreSQL en UBUNTU Server","og_description":"En este art\u00edculo, exploraremos el proceso para actualizar PostgreSQL en Ubuntu Server, espec\u00edficamente, la transici\u00f3n desde la versi\u00f3n 12 a la versi\u00f3n 14.","og_url":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/","og_site_name":"El BLOG de Enrique V\u00e1squez B.","article_publisher":"https:\/\/www.facebook.com\/zeven.sa.1","article_author":"https:\/\/www.facebook.com\/zeven.sa.1","article_published_time":"2023-07-31T06:24:00+00:00","article_modified_time":"2023-11-27T12:17:30+00:00","og_image":[{"width":900,"height":600,"url":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png","type":"image\/png"}],"author":"Enrique V\u00e1squez B.","twitter_card":"summary_large_image","twitter_title":"Actualizar PostgreSQL en UBUNTU Server","twitter_description":"En este art\u00edculo, exploraremos el proceso para actualizar PostgreSQL en Ubuntu Server, espec\u00edficamente, la transici\u00f3n desde la versi\u00f3n 12 a la versi\u00f3n 14.","twitter_image":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png","twitter_creator":"@quike1974","twitter_site":"@quike1974","twitter_misc":{"Escrito por":"Enrique V\u00e1squez B.","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/#article","isPartOf":{"@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/"},"author":{"name":"Enrique V\u00e1squez B.","@id":"https:\/\/quike.it\/es\/#\/schema\/person\/e53c62e8ab2e3f878e77d3a617483cc8"},"headline":"Actualizar PostgreSQL en UBUNTU Server","datePublished":"2023-07-31T06:24:00+00:00","dateModified":"2023-11-27T12:17:30+00:00","mainEntityOfPage":{"@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/"},"wordCount":655,"commentCount":0,"publisher":{"@id":"https:\/\/quike.it\/es\/#\/schema\/person\/e53c62e8ab2e3f878e77d3a617483cc8"},"image":{"@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/#primaryimage"},"thumbnailUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png","articleSection":["PostgreSQL","Ubuntu"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/#respond"]}]},{"@type":["WebPage","ItemPage"],"@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/","url":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/","name":"Actualizar PostgreSQL en UBUNTU Server - Enrique V\u00e1squez -","isPartOf":{"@id":"https:\/\/quike.it\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/#primaryimage"},"image":{"@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/#primaryimage"},"thumbnailUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png","datePublished":"2023-07-31T06:24:00+00:00","dateModified":"2023-11-27T12:17:30+00:00","description":"...exploraremos el proceso para actualizar PostgreSQL en Ubuntu Server, espec\u00edficamente, la transici\u00f3n desde la versi\u00f3n 12 a la versi\u00f3n 14.","breadcrumb":{"@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/#primaryimage","url":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png","contentUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png","width":900,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/quike.it\/es\/actualizar-postgresql-en-ubuntu-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/quike.it\/es\/"},{"@type":"ListItem","position":2,"name":"Inform\u00e1tica","item":"https:\/\/quike.it\/es\/category\/informatica\/"},{"@type":"ListItem","position":3,"name":"Bases de Datos","item":"https:\/\/quike.it\/es\/category\/informatica\/bases-de-datos\/"},{"@type":"ListItem","position":4,"name":"PostgreSQL","item":"https:\/\/quike.it\/es\/category\/informatica\/bases-de-datos\/postgresql\/"},{"@type":"ListItem","position":5,"name":"Actualizar PostgreSQL en UBUNTU Server"}]},{"@type":"WebSite","@id":"https:\/\/quike.it\/es\/#website","url":"https:\/\/quike.it\/es\/","name":"El BLOG de Enrique V\u00e1squez B.","description":"","publisher":{"@id":"https:\/\/quike.it\/es\/#\/schema\/person\/e53c62e8ab2e3f878e77d3a617483cc8"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quike.it\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/quike.it\/es\/#\/schema\/person\/e53c62e8ab2e3f878e77d3a617483cc8","name":"Enrique V\u00e1squez B.","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/02\/me.png","url":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/02\/me.png","contentUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/02\/me.png","width":512,"height":512,"caption":"Enrique V\u00e1squez B."},"logo":{"@id":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/02\/me.png"},"description":"Programador desde 1988, con pasi\u00f3n por escribir art\u00edculos de todo tipo. Actualmente desarrolla para ZEVEN S.A. el Sistema de Facturaci\u00f3n Electr\u00f3nica. Ecuatoriano de nacimiento e italiano de residencia, escribe desde G\u00e9nova, ciudad que ha llegado a amar tanto como su natal Guayaquil. Padre de dos hijos que son su orgullo y esposo de una mujer excepcional.","sameAs":["https:\/\/quike.it","https:\/\/www.facebook.com\/zeven.sa.1","https:\/\/www.instagram.com\/quikev1974","https:\/\/www.linkedin.com\/in\/carlos-enrique-vasquez-bautista-074893b\/","https:\/\/x.com\/quike1974"],"url":"https:\/\/quike.it\/es\/author\/quike\/"}]}},"_links":{"self":[{"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/posts\/26106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/comments?post=26106"}],"version-history":[{"count":31,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/posts\/26106\/revisions"}],"predecessor-version":[{"id":26955,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/posts\/26106\/revisions\/26955"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/media\/13912"}],"wp:attachment":[{"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/media?parent=26106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/categories?post=26106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/tags?post=26106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}