{"id":14988,"date":"2022-07-31T06:14:00","date_gmt":"2022-07-31T05:14:00","guid":{"rendered":"https:\/\/quike.it\/es\/?p=14988"},"modified":"2023-10-17T18:29:04","modified_gmt":"2023-10-17T17:29:04","slug":"como-instalar-postgresql-en-windows-server","status":"publish","type":"post","link":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/","title":{"rendered":"C\u00f3mo Instalar PostgreSQL en Windows Server"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"14988\" class=\"elementor elementor-14988\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-52efd0b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"52efd0b\" 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-50 elementor-top-column elementor-element elementor-element-7ef9b3f\" data-id=\"7ef9b3f\" 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-736d90b elementor-widget elementor-widget-text-editor\" data-id=\"736d90b\" 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 art\u00edculos pasados hemos visto <a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows\/\" target=\"_blank\" rel=\"noopener\"><em><strong>c\u00f3mo instalar PostgreSQL en Windows 10<\/strong><\/em><\/a> y en <a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-11\/\" target=\"_blank\" rel=\"noopener\"><em><strong>Windows 11<\/strong><\/em><\/a>.<\/p><p>En este art\u00edculo, veremos paso a paso, <strong>como instalar PostgreSQL en Windows Server<\/strong>.<\/p><p>Para el ejemplo utilizar\u00e9 un <a href=\"https:\/\/es.wikipedia.org\/wiki\/Servidor_virtual\" target=\"_blank\" rel=\"noopener\"><em><strong>servidor VPS<\/strong><\/em><\/a> con <a href=\"https:\/\/es.wikipedia.org\/wiki\/Windows_Server_2019\" target=\"_blank\" rel=\"noopener\"><em><strong>Windows Server 2019<\/strong><\/em><\/a> <em><strong>versi\u00f3n 1809 compilaci\u00f3n 17763.3165 <\/strong><\/em>como se aprecia en la <a href=\"https:\/\/quike.it\/es\/como-hacer-la-captura-de-pantalla-en-windows\/\" target=\"_blank\" rel=\"noopener\"><em><strong>captura de pantalla<\/strong><\/em><\/a>.<\/p><p>El idioma del sistema operativo lo he dejado en Ingl\u00e9s, esto porque por mi costumbre personal, he utilizado siempre el idioma ingl\u00e9s cuando trabajo con ambiente <a href=\"https:\/\/es.wikipedia.org\/wiki\/Windows_Server\" target=\"_blank\" rel=\"noopener\"><em><strong>Windows Server<\/strong><\/em><\/a>.<\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-dafa69e\" data-id=\"dafa69e\" 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-3f06a33 elementor-widget elementor-widget-image\" data-id=\"3f06a33\" 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\/2022\/07\/blog_1247.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1247\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMDEsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjQ3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"575\" height=\"521\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1247.jpg\" class=\"attachment-large size-large wp-image-15001\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1247.jpg 575w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1247-300x272.jpg 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-98c5ded elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"98c5ded\" 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-3fb7d26\" data-id=\"3fb7d26\" 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-feada13 elementor-widget elementor-widget-global elementor-global-23404 elementor-widget-table-of-contents\" data-id=\"feada13\" 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__feada13\" 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-050412c articulo elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"050412c\" 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-09671ea\" data-id=\"09671ea\" 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-c4b154c elementor-widget elementor-widget-heading\" data-id=\"c4b154c\" 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\">Descarga del paquete de instalaci\u00f3n de PostgreSQL<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5e4a13 elementor-widget elementor-widget-text-editor\" data-id=\"f5e4a13\" 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 que tenemos que realizar, es la descarga del programa de instalaci\u00f3n de la <strong>base de datos<\/strong>.<\/p><p>Nos dirigimos al <a href=\"https:\/\/www.enterprisedb.com\/downloads\/postgres-postgresql-downloads\" target=\"_blank\" rel=\"noopener\"><strong>link de descarga<\/strong><\/a> en la pagina oficial del producto.<\/p><p>Abre tu <strong>navegador web<\/strong> favorito (<em>te recomiendo <\/em><a href=\"https:\/\/quike.it\/es\/brave-un-navegador-web-nada-mal\/\" target=\"_blank\" rel=\"noopener\"><em><strong>Brave<\/strong><\/em>)<\/a> y escribe o haz <strong>clic<\/strong> en el <strong><a href=\"https:\/\/www.enterprisedb.com\/downloads\/postgres-postgresql-downloads\" target=\"_blank\" rel=\"noopener\"><em>siguiente<\/em> link<\/a>:<\/strong><\/p><pre data-wpview-marker=\"https%3A%2F%2Fwww.enterprisedb.com%2Fdownloads%2Fpostgres-postgresql-downloads\"><a href=\"https:\/\/www.enterprisedb.com\/downloads\/postgres-postgresql-downloads\" target=\"_blank\" rel=\"noopener\"><strong>https:\/\/www.enterprisedb.com\/downloads\/postgres-postgresql-downloads<\/strong><\/a><\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f0d67b8 elementor-widget elementor-widget-image\" data-id=\"f0d67b8\" 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\/2022\/07\/blog_1118.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1118\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM1MTUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTE4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"402\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1118-1024x514.jpg\" class=\"attachment-large size-large wp-image-13515\" alt=\"PostgreSQL en Windows 11\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1118-1024x514.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1118-300x151.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1118-768x386.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1118.jpg 1487w\" 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-33365c6 elementor-widget elementor-widget-text-editor\" data-id=\"33365c6\" 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>Hacemos <strong>clic<\/strong> en la versi\u00f3n que deseamos descargar e instalar (<em>en nuestro caso la <strong>14.4<\/strong><\/em>)<\/p><p>Una vez descargado el paquete de instalaci\u00f3n procedemos a <strong><em>ejecutar<\/em><\/strong> el mismo.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38bc9bf elementor-widget elementor-widget-image\" data-id=\"38bc9bf\" 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<img decoding=\"async\" width=\"800\" height=\"112\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1119-1024x143.jpg\" class=\"attachment-large size-large wp-image-13516\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1119-1024x143.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1119-300x42.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1119-768x107.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1119.jpg 1357w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\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-82260d5 elementor-widget elementor-widget-heading\" data-id=\"82260d5\" 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\">Instalar PostgreSQL en Windows Server<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a782fa3 elementor-widget elementor-widget-image\" data-id=\"a782fa3\" 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\/2022\/07\/blog_1249.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1249\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMDQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjQ5LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"741\" height=\"214\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1249.jpg\" class=\"attachment-large size-large wp-image-15004\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1249.jpg 741w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1249-300x87.jpg 300w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/>\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-45bc9c0 elementor-widget elementor-widget-text-editor\" data-id=\"45bc9c0\" 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>Recordemos siempre de <em><strong>ejecutar el instalador como administrador.<\/strong><\/em><\/p><p>Una vez iniciada la <em><strong>ejecuci\u00f3n<\/strong><\/em> del programa de instalaci\u00f3n, procederemos como se indica a continuaci\u00f3n en las <a href=\"https:\/\/quike.it\/es\/como-hacer-la-captura-de-pantalla-en-windows\/\" target=\"_blank\" rel=\"noopener\"><em><strong>capturas de pantalla<\/strong><\/em><\/a>.<\/p><p>Ten presente que es probable que si el instalador no detecta las librer\u00edas b\u00e1sicas de <a href=\"https:\/\/es.wikipedia.org\/wiki\/Microsoft_Visual_C%2B%2B\" target=\"_blank\" rel=\"noopener\"><em><strong>Visual C++<\/strong><\/em><\/a> se auto-instalar\u00e1n, y luego el proceso iniciar\u00e1.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-444b80a elementor-widget elementor-widget-image\" data-id=\"444b80a\" 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\/2022\/07\/blog_1248.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1248\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMDMsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjQ4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"383\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1248.jpg\" class=\"attachment-full size-full wp-image-15003\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1248.jpg 609w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1248-300x189.jpg 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9980302 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9980302\" 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-50 elementor-top-column elementor-element elementor-element-7dd0b20\" data-id=\"7dd0b20\" 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-58f74f0 elementor-widget elementor-widget-image\" data-id=\"58f74f0\" 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\/2022\/07\/blog_1250.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1250\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMDUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjUwLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1250.jpg\" class=\"attachment-large size-large wp-image-15005\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1250.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1250-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-272cd60 elementor-widget elementor-widget-text-editor\" data-id=\"272cd60\" 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>Presionamos <em><strong>Next.<\/strong><\/em><\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-565aa85\" data-id=\"565aa85\" 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-26785aa elementor-widget elementor-widget-image\" data-id=\"26785aa\" 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\/2022\/07\/blog_1251.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1251\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMDYsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjUxLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1251.jpg\" class=\"attachment-large size-large wp-image-15006\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1251.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1251-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-65582a2 elementor-widget elementor-widget-text-editor\" data-id=\"65582a2\" 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 esta secci\u00f3n podemos especificar la carpeta en donde se instalaran los archivos.\u00a0<\/p><p>Para cambiar la carpeta de instalaci\u00f3n utilizamos el bot\u00f3n con el icono de la carpeta con la<strong> flecha verde<\/strong>.<\/p><p>Presionamos en el bot\u00f3n <em><strong>Next<\/strong><\/em> para proseguir.<\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-70d3b1c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"70d3b1c\" 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-50 elementor-top-column elementor-element elementor-element-cc7f09e\" data-id=\"cc7f09e\" 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-b12b8c1 elementor-widget elementor-widget-image\" data-id=\"b12b8c1\" 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\/2022\/07\/blog_1252.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1252\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMDgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjUyLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1252.jpg\" class=\"attachment-large size-large wp-image-15008\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1252.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1252-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-29a6a2a elementor-widget elementor-widget-text-editor\" data-id=\"29a6a2a\" 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>Dejamos las selecciones que vienen indicadas y presionamos el bot\u00f3n <em><strong>Next.<\/strong><\/em><\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-ccf9baa\" data-id=\"ccf9baa\" 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-70e33b2 elementor-widget elementor-widget-image\" data-id=\"70e33b2\" 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\/2022\/07\/blog_1253.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1253\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMDksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjUzLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1253.jpg\" class=\"attachment-large size-large wp-image-15009\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1253.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1253-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-6f1e15a elementor-widget elementor-widget-text-editor\" data-id=\"6f1e15a\" 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 esta secci\u00f3n se indica el directorio en donde se almacenan los datos, como en el caso de los archivos de instalaci\u00f3n, podemos cambiarlos si queremos.<\/p><p>Para continuar, presionamos el bot\u00f3n\u00a0 <em><strong>Next.<\/strong><\/em><\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-317f05a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"317f05a\" 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-50 elementor-top-column elementor-element elementor-element-ee3e1e3\" data-id=\"ee3e1e3\" 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-4252733 elementor-widget elementor-widget-image\" data-id=\"4252733\" 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\/2022\/07\/blog_1254.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1254\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMTMsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjU0LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1254.jpg\" class=\"attachment-large size-large wp-image-15013\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1254.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1254-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-ca3438c elementor-widget elementor-widget-text-editor\" data-id=\"ca3438c\" 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>Es el momento de indicar la contrase\u00f1a\u00a0 del usuario <em><strong>postgres<\/strong><\/em>, que es el equivalente de <em><strong>root<\/strong><\/em> en <a href=\"https:\/\/es.wikipedia.org\/wiki\/MySQL\" target=\"_blank\" rel=\"noopener\"><em><strong>MySQL<\/strong><\/em><\/a> o <em><strong>admin<\/strong><\/em>\u00a0<\/p><p>Es importante no dejar la clave vac\u00eda, de lo contrario nuestra <strong><em>base de datos<\/em><\/strong> puede ser consultada sin restricciones.<\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-758c71f\" data-id=\"758c71f\" 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-eb9dd8a elementor-widget elementor-widget-image\" data-id=\"eb9dd8a\" 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\/2022\/07\/blog_1255.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1255\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMTQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjU1LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1255.jpg\" class=\"attachment-large size-large wp-image-15014\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1255.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1255-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-3c73b54 elementor-widget elementor-widget-text-editor\" data-id=\"3c73b54\" 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>Por defecto, el puerto a trav\u00e9s del cual <a href=\"https:\/\/quike.it\/es\/postgresql-mi-base-de-datos-favorita\/\" target=\"_blank\" rel=\"noopener\"><strong>PostgreSQL<\/strong><\/a> <strong><em>escucha las conexiones<\/em><\/strong> es el <strong>5432,<\/strong> en esta casilla si es nuestro caso, podemos indicar un puerto diferente.<\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e3eaf9c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e3eaf9c\" 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-50 elementor-top-column elementor-element elementor-element-e1277b1\" data-id=\"e1277b1\" 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-c6c84b8 elementor-widget elementor-widget-image\" data-id=\"c6c84b8\" 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\/2022\/07\/blog_1256.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1256\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMTUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjU2LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1256.jpg\" class=\"attachment-large size-large wp-image-15015\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1256.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1256-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-ce6f23d elementor-widget elementor-widget-text-editor\" data-id=\"ce6f23d\" 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 esta secci\u00f3n podemos indicar la <strong>configuraci\u00f3n regiona<\/strong>l.<\/p><p>Es importante para que los caracteres especiales de alg\u00fan <a href=\"https:\/\/dle.rae.es\/alfabeto?m=form\" target=\"_blank\" rel=\"noopener\"><strong>alfabeto<\/strong><\/a> espec\u00edfico sean reconocidos en el intercambio y escritura de datos.\u00a0<\/p><p>En este caso estoy escogiendo el <em><strong>Espa\u00f1ol, Ecuador<\/strong><\/em><\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-094b0e0\" data-id=\"094b0e0\" 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-48201d1 elementor-widget elementor-widget-image\" data-id=\"48201d1\" 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\/2022\/07\/blog_1257.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1257\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMTYsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjU3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1257.jpg\" class=\"attachment-large size-large wp-image-15016\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1257.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1257-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-b6b1efe elementor-widget elementor-widget-text-editor\" data-id=\"b6b1efe\" 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>Se nos muestra un resumen de lo que hasta el momento hemos indicado al instalador.<\/p><p>Presionamos <em><strong>Next.<\/strong><\/em><\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1310686 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1310686\" 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-50 elementor-top-column elementor-element elementor-element-e896a87\" data-id=\"e896a87\" 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-f3f5a41 elementor-widget elementor-widget-image\" data-id=\"f3f5a41\" 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\/2022\/07\/blog_1258.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1258\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMTcsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjU4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1258.jpg\" class=\"attachment-large size-large wp-image-15017\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1258.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1258-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-96d6e11 elementor-widget elementor-widget-text-editor\" data-id=\"96d6e11\" 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>Es el momento de iniciar con el proceso de instalaci\u00f3n.\u00a0<\/p><p><em><strong>Clic<\/strong> <\/em>en <em><strong>Next.<\/strong><\/em><\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-d8b6bd7\" data-id=\"d8b6bd7\" 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-f8711f6 elementor-widget elementor-widget-image\" data-id=\"f8711f6\" 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\/2022\/07\/blog_1259.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1259\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMTgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjU5LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1259.jpg\" class=\"attachment-large size-large wp-image-15018\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1259.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1259-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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-cd892dd elementor-widget elementor-widget-text-editor\" data-id=\"cd892dd\" 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>Esperamos a que el proceso termine.<\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bd4011d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bd4011d\" 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-50 elementor-top-column elementor-element elementor-element-553edb6\" data-id=\"553edb6\" 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-455d615 elementor-widget elementor-widget-image\" data-id=\"455d615\" 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\/2022\/07\/blog_1260.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1260\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMTksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjYwLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"690\" height=\"540\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1260.jpg\" class=\"attachment-large size-large wp-image-15019\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1260.jpg 690w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1260-300x235.jpg 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-e727bfe\" data-id=\"e727bfe\" 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-92d8466 elementor-widget elementor-widget-text-editor\" data-id=\"92d8466\" 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>Al finalizar, quitamos la selecci\u00f3n del <a href=\"https:\/\/es.wikipedia.org\/wiki\/Casilla_de_verificaci%C3%B3n\" target=\"_blank\" rel=\"noopener\"><strong>checkbox<\/strong><\/a> y luego clic en <em><strong>Finish.<\/strong><\/em><\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-50b3a6e articulo elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50b3a6e\" 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-0757977\" data-id=\"0757977\" 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-a97772d elementor-widget elementor-widget-heading\" data-id=\"a97772d\" 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\">Configuraci\u00f3n del Acceso Remoto<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-469a34c elementor-widget elementor-widget-text-editor\" data-id=\"469a34c\" 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 concluido el proceso de <em><strong>instalaci\u00f3n de PostgreSQL en Windows Server<\/strong><\/em>, debemos configurar el <a href=\"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/\" target=\"_blank\" rel=\"noopener\"><em><strong>acceso remoto a la base de datos<\/strong><\/em><\/a>. Esto porque si estamos instalando en un ambiente de servidor, pues se entiende que la base de datos debe ser consultada por otros dispositivos a trav\u00e9s de la <a href=\"https:\/\/es.wikipedia.org\/wiki\/Intranet\" target=\"_blank\" rel=\"noopener\"><em><strong>intranet<\/strong><\/em><\/a> o <a href=\"https:\/\/es.wikipedia.org\/wiki\/Internet\" target=\"_blank\" rel=\"noopener\"><em><strong>Internet.<\/strong><\/em><\/a><\/p><p>Abrimos el explorador de archivos y buscamos el directorio donde se instal\u00f3 <a href=\"https:\/\/quike.it\/es\/postgresql-mi-base-de-datos-favorita\/\" target=\"_blank\" rel=\"noopener\"><em><strong>PostgreSQL.<\/strong><\/em><\/a><\/p><p>Por lo general se instala en la ruta:<\/p><pre><em><strong>C:\\Program Files\\PostgreSQL<\/strong><\/em><\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-70d520c elementor-widget elementor-widget-image\" data-id=\"70d520c\" 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\/2022\/07\/blog_1261.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1261\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMzIsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjYxLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1041\" height=\"393\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1261.jpg\" class=\"attachment-full size-full wp-image-15032\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1261.jpg 1041w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1261-300x113.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1261-1024x387.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1261-768x290.jpg 768w\" sizes=\"(max-width: 1041px) 100vw, 1041px\" \/>\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-34ed223 elementor-widget elementor-widget-text-editor\" data-id=\"34ed223\" 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>Abrimos la carpeta por medio de un <i><b>doble clic<\/b><\/i> sobre el <em>nombre de la versi\u00f3n<\/em>.<\/p><p>Al interno de la carpeta, individuamos la carpeta llamada <strong>\u00ab<em>data<\/em>\u00bb <\/strong>y accedemos siempre con un <strong><em>doble clic<\/em><\/strong>; debemos poder visualizar los archivos: <em><strong>pg_hba.conf\u00a0<\/strong><\/em> y <em><strong>postgresql.conf<\/strong><\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cffac02 elementor-widget elementor-widget-image\" data-id=\"cffac02\" 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\/2022\/07\/blog_1262.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1262\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMzMsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjYyLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"888\" height=\"507\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1262.jpg\" class=\"attachment-full size-full wp-image-15033\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1262.jpg 888w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1262-300x171.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1262-768x438.jpg 768w\" sizes=\"(max-width: 888px) 100vw, 888px\" \/>\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-6dd96d0 elementor-widget elementor-widget-heading\" data-id=\"6dd96d0\" 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\">Configuraci\u00f3n archivo pg_hba.conf<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-935af16 elementor-widget elementor-widget-text-editor\" data-id=\"935af16\" 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>Procedemos a abrir el archivo <em><strong>pg_hba.conf<\/strong><\/em> con un editor de texto cualquiera. Una vez abierto, deslizamos hasta encontrar la secci\u00f3n: <strong><em># IPv4 local connections<\/em><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c2fecb5 elementor-widget elementor-widget-text-editor\" data-id=\"c2fecb5\" 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 esa secci\u00f3n, agregaremos una nueva l\u00ednea con el siguiente contenido:<\/p><pre><strong>host all all 0.0.0.0\/0 scram-sha-256<\/strong><\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a644453 elementor-widget elementor-widget-text-editor\" data-id=\"a644453\" 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 archivo debe verse tal como se muestra en 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-a4a7af8 elementor-widget elementor-widget-image\" data-id=\"a4a7af8\" 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\/2022\/07\/blog_1264.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1264\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwMzUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjY0LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"877\" height=\"265\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1264.jpg\" class=\"attachment-full size-full wp-image-15035\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1264.jpg 877w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1264-300x91.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1264-768x232.jpg 768w\" sizes=\"(max-width: 877px) 100vw, 877px\" \/>\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-635930c elementor-widget elementor-widget-text-editor\" data-id=\"635930c\" 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>Si est\u00e1s trabajando con una versi\u00f3n precedente de <em><strong>PostgreSQL,<\/strong><\/em> es posible que la l\u00ednea contenga al final en vez de <em><strong>scram-sha-256<\/strong><\/em> el valor <em><strong>md5.<\/strong><\/em><\/p><p>En ese caso es suficiente que cambies el valor para que corresponda al mismo valor:<\/p><pre><strong>host all all 0.0.0.0\/0 md5<\/strong><\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ef8bb3 elementor-alert-warning elementor-widget elementor-widget-alert\" data-id=\"5ef8bb3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"alert.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-alert\" role=\"alert\">\n\n\t\t\t\t\t\t<span class=\"elementor-alert-title\">Recordatorio<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">No olvidar registrar los cambios realizados al archivo.<\/span>\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d6c5c16 elementor-widget elementor-widget-heading\" data-id=\"d6c5c16\" 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\">Configuraci\u00f3n archivo postgresql.conf<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dae01a7 elementor-widget elementor-widget-text-editor\" data-id=\"dae01a7\" 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>Tal como hicimos con el archivo <a href=\"#windows-11-pg_hba\"><em><strong>pg_hba.conf,<\/strong><\/em><\/a> procedemos a abrir el archivo <em><strong>postgresql.conf<\/strong><\/em> con un <strong>editor de texto<\/strong>.<\/p><p>Deslizamos el contenido del archivo, hasta que encontremos la secci\u00f3n: <em><strong># &#8211; Connection Settings &#8211;<\/strong><\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-589c0aa elementor-widget elementor-widget-image\" data-id=\"589c0aa\" 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\/2022\/07\/blog_1141.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1141\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MDQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQxLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"446\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1141-1024x571.jpg\" class=\"attachment-large size-large wp-image-13604\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1141-1024x571.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1141-300x167.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1141-768x429.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1141.jpg 1086w\" 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-8eff181 elementor-widget elementor-widget-text-editor\" data-id=\"8eff181\" 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 esta secci\u00f3n debemos asegurarnos que la l\u00ednea que inicia con <em><strong>listen_addresses<\/strong><\/em> no est\u00e9 comentada (<em>s\u00edmbolo <strong>#<\/strong> al inicio<\/em>) y que como valor asignada tenga: <em><strong>&#8216;*&#8217;<\/strong><\/em><\/p><p>El hecho que se encuentre el<em><strong> &#8216;*&#8217;<\/strong><\/em> significa que la base de datos va a aceptar conexiones en entrada desde cualquier <em><strong>direcci\u00f3n IP<\/strong><\/em> que se la solicite.<\/p><p>Si queremos restringir el acceso remoto a una <em><strong>direcci\u00f3n IP<\/strong><\/em> espec\u00edfica, es suficiente escribir dentro de las comillas simples la <em><strong>direcci\u00f3n IP<\/strong><\/em> que vamos a permitir.<\/p><p>Si fuese el caso que hay mas <em><strong>direcciones IP<\/strong><\/em> individuales, se las debe escribir separadas por una coma (,).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f36d47c elementor-alert-warning elementor-widget elementor-widget-alert\" data-id=\"f36d47c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"alert.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-alert\" role=\"alert\">\n\n\t\t\t\t\t\t<span class=\"elementor-alert-title\">Recordatorio<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">No olvidar registrar los cambios realizados al archivo.<\/span>\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e5d7374 elementor-widget elementor-widget-heading\" data-id=\"e5d7374\" 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\">Abrir Puerto en el Firewall<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a9ba8e elementor-widget elementor-widget-text-editor\" data-id=\"9a9ba8e\" 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>Ahora debemos asegurarnos que las conexiones en entrada no sean bloqueadas por el <em><strong>Firewall<\/strong><\/em> de <em><strong>Windows Server<\/strong><\/em>.<\/p><p>En el caso del <em><strong>servidor VPS<\/strong><\/em> que estoy utilizando en el ejemplo, el <em><strong>Firewall<\/strong><\/em> activo es el que se instala junto con <strong>Windows Server<\/strong>\u00a0en forma predefinida.<\/p><p>Abrimos entonces la secci\u00f3n del <em><strong>Firewall de Windows Server<\/strong><\/em>, escribiendo la palabra <strong><em>firewall<\/em><\/strong> en la <em><strong>barra de b\u00fasqueda<\/strong><\/em> y haciendo <strong><em>clic<\/em><\/strong> en la aplicaci\u00f3n <em><strong>Windows Defender Firewall<\/strong><\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4ce14e6 elementor-widget elementor-widget-image\" data-id=\"4ce14e6\" 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\/2022\/07\/blog_1265.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1265\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNDUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjY1LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"652\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1265-1024x835.jpg\" class=\"attachment-large size-large wp-image-15045\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1265-1024x835.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1265-300x245.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1265-768x626.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1265.jpg 1076w\" 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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-db73612 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"db73612\" 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-50 elementor-top-column elementor-element elementor-element-fcbb9cb\" data-id=\"fcbb9cb\" 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-41b5bac elementor-widget elementor-widget-image\" data-id=\"41b5bac\" 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\/2022\/07\/blog_1266.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1266\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNDYsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjY2LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"292\" height=\"412\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1266.jpg\" class=\"attachment-medium_large size-medium_large wp-image-15046\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1266.jpg 292w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1266-213x300.jpg 213w\" sizes=\"(max-width: 292px) 100vw, 292px\" \/>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-06f0977\" data-id=\"06f0977\" 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-b7b8e1e elementor-widget elementor-widget-text-editor\" data-id=\"b7b8e1e\" 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 hecho <i><b>clic<\/b><\/i>, se nos abre la secci\u00f3n principal del <b><i>Firewall <\/i><\/b><i><b>de Windows Defender<\/b><\/i>.<\/p><p>Utilizamos la opci\u00f3n <em><strong>Advanced Settings<\/strong><\/em> que encontramos en la parte izquierda del men\u00fa que se nos propone.<\/p><p>Se abre una nueva ventana en donde elegiremos siempre en el lado izquierdo la opci\u00f3n <em><strong>Inbound Rules<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f73b5b elementor-widget elementor-widget-image\" data-id=\"6f73b5b\" 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\/2022\/07\/blog_1267.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1267\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNDcsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjY3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"270\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267-1024x346.jpg\" class=\"attachment-large size-large wp-image-15047\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267-1024x346.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267-300x101.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267-768x260.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267.jpg 1307w\" 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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1f84fb9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1f84fb9\" 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-1fd5f66\" data-id=\"1fd5f66\" 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-743a0ee elementor-widget elementor-widget-text-editor\" data-id=\"743a0ee\" 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>Ahora utilizamos la secci\u00f3n derecha en donde encontramos la opci\u00f3n <em><strong>New Rule<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d9a66d6 elementor-widget elementor-widget-image\" data-id=\"d9a66d6\" 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\/2022\/07\/blog_1268.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1268\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNDgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjY4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"162\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1268-1024x207.jpg\" class=\"attachment-large size-large wp-image-15048\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1268-1024x207.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1268-300x61.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1268-768x155.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1268.jpg 1307w\" 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-dee086e elementor-widget elementor-widget-text-editor\" data-id=\"dee086e\" 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>Hacemos <strong>clic<\/strong> en la opci\u00f3n <em><strong>New Rule<\/strong><\/em>\u00a0y seguimos los siguientes pasos:<\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-730fb6e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"730fb6e\" 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-50 elementor-top-column elementor-element elementor-element-ef2df95\" data-id=\"ef2df95\" 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-99ac0e0 elementor-widget elementor-widget-image\" data-id=\"99ac0e0\" 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\/2022\/07\/blog_1269.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1269\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNDksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjY5LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"651\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1269.jpg\" class=\"attachment-large size-large wp-image-15049\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1269.jpg 892w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1269-300x244.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1269-768x625.jpg 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-94e440d elementor-widget elementor-widget-text-editor\" data-id=\"94e440d\" 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>Seleccionamos la segunda opci\u00f3n <strong><em>(port) <\/em><\/strong>y presionamos <em><strong>Next<\/strong><\/em><\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-84dee1a\" data-id=\"84dee1a\" 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-b0564b4 elementor-widget elementor-widget-image\" data-id=\"b0564b4\" 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\/2022\/07\/blog_1270.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1270\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNTAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjcwLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"651\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1270.jpg\" class=\"attachment-large size-large wp-image-15050\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1270.jpg 892w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1270-300x244.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1270-768x625.jpg 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-627272a elementor-widget elementor-widget-text-editor\" data-id=\"627272a\" 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>Dejamos la selecci\u00f3n en <em><strong>TCP<\/strong><\/em> y en el segundo bloque elegimos <em><strong>Specific local ports<\/strong><\/em>. Debemos escribir el puerto especificado en la <strong>instalaci\u00f3n de PostgreSQL<\/strong>, si no hemos cambiado el <em><strong>puerto predeterminado,<\/strong><\/em> el valor deber\u00eda ser <em><strong>5432.<\/strong><\/em><\/p><p>hacemos <strong>clic<\/strong> en <em><strong>Next<\/strong><\/em><\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-38107e5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"38107e5\" 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-50 elementor-top-column elementor-element elementor-element-cd98162\" data-id=\"cd98162\" 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-9930ded elementor-widget elementor-widget-image\" data-id=\"9930ded\" 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\/2022\/07\/blog_1271.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1271\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNTQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjcxLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"651\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1271.jpg\" class=\"attachment-large size-large wp-image-15054\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1271.jpg 892w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1271-300x244.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1271-768x625.jpg 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-0b0240b elementor-widget elementor-widget-text-editor\" data-id=\"0b0240b\" 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>Dejamos la selecci\u00f3n en <em><strong>Allow the connection<\/strong><\/em>. Damos clic en <em><strong>Next.<\/strong><\/em><\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-a4a16e6\" data-id=\"a4a16e6\" 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-10fac57 elementor-widget elementor-widget-image\" data-id=\"10fac57\" 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\/2022\/07\/blog_1272.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1272\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNTUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjcyLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"651\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1272.jpg\" class=\"attachment-large size-large wp-image-15055\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1272.jpg 892w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1272-300x244.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1272-768x625.jpg 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-96a3a24 elementor-widget elementor-widget-text-editor\" data-id=\"96a3a24\" 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><em><strong>Clic<\/strong><\/em> en <em><strong>Next.<\/strong><\/em><\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8dc1e57 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8dc1e57\" 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-50 elementor-top-column elementor-element elementor-element-686888a\" data-id=\"686888a\" 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-900e88e elementor-widget elementor-widget-image\" data-id=\"900e88e\" 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\/2022\/07\/blog_1273.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1273\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNTYsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjczLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"651\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1273.jpg\" class=\"attachment-large size-large wp-image-15056\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1273.jpg 892w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1273-300x244.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1273-768x625.jpg 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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-982ca6c\" data-id=\"982ca6c\" 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-435a749 elementor-widget elementor-widget-text-editor\" data-id=\"435a749\" 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>Por \u00faltimo, debemos asignar un nombre a la nueva regla que se va crear. Una vez hecho, presionamos el bot\u00f3n <em><strong>Finish.<\/strong><\/em><\/p><p>Hemos creado una regla a nivel del <em><strong>Firewall<\/strong><\/em> que permitir\u00e1 de ahora en adelante las conexiones a trav\u00e9s del puerto <em><strong>5432\u00a0<\/strong>(o el que hallamos especificado)<\/em><\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-392fd89 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"392fd89\" 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-7e85381\" data-id=\"7e85381\" 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-729c766 elementor-widget elementor-widget-text-editor\" data-id=\"729c766\" 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>Ahora configuramos la regla de salida. Hacemos siempre clic en la opci\u00f3n <em><strong>Outbound Rules\u00a0<\/strong><\/em>y en la ventana que se nos propone clic en <em><strong>New Rule<\/strong><\/em> y seguimos los siguientes pasos indicados para la regla de entrada.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8776b07 elementor-widget elementor-widget-image\" data-id=\"8776b07\" 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\/2022\/07\/blog_1267.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1267\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNDcsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjY3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"270\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267-1024x346.jpg\" class=\"attachment-large size-large wp-image-15047\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267-1024x346.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267-300x101.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267-768x260.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1267.jpg 1307w\" 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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8555a7d articulo elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8555a7d\" 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-77ecdca\" data-id=\"77ecdca\" 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-ba48d78 elementor-widget elementor-widget-heading\" data-id=\"ba48d78\" 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\">Reinicio del Servicio PostgreSQL<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3fe3f31 elementor-widget elementor-widget-text-editor\" data-id=\"3fe3f31\" 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 \u00faltimo paso que debemos dar para concluir la <em><strong>instalaci\u00f3n de<\/strong> <\/em><b><i>PostgreSQL en Windows Server<\/i><\/b>, es el del reinicio del <em><strong>servicio<\/strong> <strong>PostgreSQL<\/strong><\/em> para que la configuraci\u00f3n que acabamos de realizar inicie a funcionar.<\/p><p>Para esto, abriremos los <strong>servicios<\/strong> de <b>Windows\u00a0<\/b>escribiendo directamente en la <strong>barra de b\u00fasqueda<\/strong> la palabra <strong><em>services<\/em><\/strong> y haciendo clic en la aplicaci\u00f3n <em><strong>Services<\/strong><\/em> que se nos muestra entre los resultados de la b\u00fasqueda.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-78b7c3f elementor-widget elementor-widget-image\" data-id=\"78b7c3f\" 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\/2022\/07\/blog_1274.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1274\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNjAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjc0LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"657\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1274-1024x841.jpg\" class=\"attachment-large size-large wp-image-15060\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1274-1024x841.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1274-300x246.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1274-768x631.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1274.jpg 1078w\" 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-94c517a elementor-widget elementor-widget-text-editor\" data-id=\"94c517a\" 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 aplicaci\u00f3n <em><strong>servicios<\/strong><\/em>, individuamos el motor de la <i><b>base de datos<\/b><\/i> y entre las opciones que se muestran en la parte izquierda optamos por la que dice <strong><em>Reinicia el servicio.<\/em><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f3131a elementor-widget elementor-widget-image\" data-id=\"3f3131a\" 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\/2022\/07\/blog_1275.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1275\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNjEsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjc1LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"492\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1275-1024x630.jpg\" class=\"attachment-large size-large wp-image-15061\" alt=\"PostgreSQL en Windows Server\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1275-1024x630.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1275-300x184.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1275-768x472.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1275.jpg 1205w\" 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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-87639ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"87639ef\" 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-50 elementor-top-column elementor-element elementor-element-a05a524\" data-id=\"a05a524\" 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-1bdf667 elementor-widget elementor-widget-image\" data-id=\"1bdf667\" 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\/2022\/07\/blog_1276.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1276\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTUwNjUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMjc2LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"228\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1276.jpg\" class=\"attachment-large size-large wp-image-15065\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1276.jpg 485w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1276-300x141.jpg 300w\" sizes=\"(max-width: 485px) 100vw, 485px\" \/>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-55456fd\" data-id=\"55456fd\" 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-e321835 elementor-widget elementor-widget-text-editor\" data-id=\"e321835\" 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 el <em><strong>servicio<\/strong><\/em> se ha reiniciado, ya estamos listos para realizar la prueba de que nuestra configuraci\u00f3n fue hecha correctamente.\u00a0<\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-72a084d articulo elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"72a084d\" 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-928e78d\" data-id=\"928e78d\" 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-356ea4e elementor-widget elementor-widget-heading\" data-id=\"356ea4e\" 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\">Verificaci\u00f3n de la Instalacion<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c3bc1d elementor-widget elementor-widget-text-editor\" data-id=\"0c3bc1d\" 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 terminado de <a href=\"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/\" target=\"_blank\" rel=\"noopener\"><em><strong>Configurar el Acceso Remoto PostgreSQL<\/strong><\/em><\/a>, es el momento de realizar la prueba de una <strong>conexi\u00f3n remota<\/strong>, o desde un computador en la <em><strong>intranet<\/strong><\/em> o a trav\u00e9s de <em><strong>Internet.<\/strong><\/em><\/p><p>Antes de iniciar debemos procurarnos la <a href=\"https:\/\/es.wikipedia.org\/wiki\/Direcci%C3%B3n_IP\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> del <em><strong>Servidor.<\/strong><\/em> Si fuere el caso debemos tener a la mano la <a href=\"https:\/\/es.wikipedia.org\/wiki\/Direcci%C3%B3n_IP#IP_fija\" target=\"_blank\" rel=\"noopener\"><strong>direcci\u00f3n IP p\u00fablica<\/strong><\/a>.<\/p><p>En el caso de nuestro ejemplo la <a href=\"https:\/\/es.wikipedia.org\/wiki\/Direcci%C3%B3n_IP\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> asignada en la red al computador en el que instalamos <em><strong>PostgreSQL<\/strong><\/em> es: <strong><em>192.168.113.129<\/em><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fab6d03 elementor-widget elementor-widget-heading\" data-id=\"fab6d03\" 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\">Realizar un PING<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fc7ae31 elementor-widget elementor-widget-text-editor\" data-id=\"fc7ae31\" 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>Si estamos realizando la <strong>prueba de acceso remoto<\/strong> a la <strong><em>base de datos<\/em><\/strong> en un dispositivo con <em><strong>Windows,<\/strong><\/em> independiente de la versi\u00f3n, presionamos la combinaci\u00f3n <em><strong>Win+R<\/strong><\/em> y en la ventanita que se nos muestra, escribimos <strong>cmd<\/strong> y presionamos el bot\u00f3n <em><strong>OK<\/strong><\/em><\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f3afc6f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f3afc6f\" 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-50 elementor-top-column elementor-element elementor-element-9dcf050\" data-id=\"9dcf050\" 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-4760425 elementor-widget elementor-widget-image\" data-id=\"4760425\" 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\/2022\/07\/blog_1152.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1152\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MzMsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTUyLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"617\" height=\"249\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1152.jpg\" class=\"attachment-large size-large wp-image-13633\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1152.jpg 617w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1152-300x121.jpg 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-6a82d36\" data-id=\"6a82d36\" 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-237c641 elementor-widget elementor-widget-text-editor\" data-id=\"237c641\" 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>escribimos el siguiente comando:<\/p><pre>ping 192.168.113.129<\/pre>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cf12a70 elementor-widget elementor-widget-text-editor\" data-id=\"cf12a70\" 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>Recuerda que debes colocar la <a href=\"https:\/\/es.wikipedia.org\/wiki\/Direcci%C3%B3n_IP\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> del dispositivo en el que instalaste PostgreSQL.<\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-19cfa77 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"19cfa77\" 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-50 elementor-top-column elementor-element elementor-element-a3c9f40\" data-id=\"a3c9f40\" 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-a3a2163 elementor-widget elementor-widget-text-editor\" data-id=\"a3a2163\" 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>Deber\u00edas obtener un resultado similar al de la <a href=\"https:\/\/quike.it\/es\/como-hacer-la-captura-de-pantalla-en-windows\/\" target=\"_blank\" rel=\"noopener\"><em><strong>captura de pantalla<\/strong><\/em><\/a> que se muestra a continuaci\u00f3n.<\/p><p>Si no est\u00e1s obteniendo un resultado similar, o vez que el resultado es que no se puede contactar la <a href=\"https:\/\/es.wikipedia.org\/wiki\/Direcci%C3%B3n_IP\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> del dispositivo, hay que resolver ese problema.<\/p><p>Probablemente hay alg\u00fan problema a nivel del <a href=\"https:\/\/es.wikipedia.org\/wiki\/Cableado_estructurado\" target=\"_blank\" rel=\"noopener\"><strong>cableado de red<\/strong><\/a> que hay que resolver antes de proseguir.\u00a0<\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-ef4f01d\" data-id=\"ef4f01d\" 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-4458821 elementor-widget elementor-widget-image\" data-id=\"4458821\" 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\/2022\/07\/blog_1153.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1153\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MzQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTUzLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"617\" height=\"376\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1153.jpg\" class=\"attachment-large size-large wp-image-13634\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1153.jpg 617w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1153-300x183.jpg 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-832c15f articulo elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"832c15f\" 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-c2c054f\" data-id=\"c2c054f\" 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-cef86e5 elementor-widget elementor-widget-heading\" data-id=\"cef86e5\" 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\">Agregar el Servidor a pgAdmin<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b05994 elementor-widget elementor-widget-text-editor\" data-id=\"4b05994\" 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><span class=\"ILfuVd\" lang=\"es\"><span class=\"hgKElc\"><b>pgAdmin<\/b> es una plataforma de administraci\u00f3n y desarrollo de <a href=\"https:\/\/es.wikipedia.org\/wiki\/Software_de_c%C3%B3digo_abierto\" target=\"_blank\" rel=\"noopener\"><strong>c\u00f3digo abierto<\/strong><\/a> para <strong>PostgreSQL<\/strong> y sus sistemas de administraci\u00f3n de <strong>bases de datos<\/strong> relacionales.\u00a0<\/span><\/span><\/p><p>Haremos el procedimiento de agregar el <b><i>servidor de bases de datos<\/i><\/b> a la administraci\u00f3n principal dentro de <em><strong>pgAdmin.<\/strong><\/em><\/p><p>Una vez que estamos dentro de la aplicaci\u00f3n, sea esta en su <i><b>Versi\u00f3n <\/b><\/i>de <strong>Windows, Linux<\/strong> o <strong>iOS<\/strong>, procedemos como explicado a continuaci\u00f3n.<\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e3d89b7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e3d89b7\" 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-50 elementor-top-column elementor-element elementor-element-1c3ca47\" data-id=\"1c3ca47\" 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-a1c0e2b elementor-widget elementor-widget-image\" data-id=\"a1c0e2b\" 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\/2022\/07\/blog_1154.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1154\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MzUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTU0LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"712\" height=\"402\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1154.jpg\" class=\"attachment-large size-large wp-image-13635\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1154.jpg 712w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1154-300x169.jpg 300w\" sizes=\"(max-width: 712px) 100vw, 712px\" \/>\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-e749b2b elementor-widget elementor-widget-text-editor\" data-id=\"e749b2b\" 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>Hacemos clic con el bot\u00f3n derecho del rat\u00f3n en el grupo <em><strong>Server<\/strong><\/em> y seguimos\u00a0 con la opci\u00f3n <em><strong>Register &#8211;&gt; Servidor<\/strong><\/em><\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-2fcbd0d\" data-id=\"2fcbd0d\" 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-f58bfe7 elementor-widget elementor-widget-image\" data-id=\"f58bfe7\" 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\/2022\/07\/blog_1155.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1155\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MzYsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTU1LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"694\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1155.jpg\" class=\"attachment-large size-large wp-image-13636\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1155.jpg 632w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1155-273x300.jpg 273w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/>\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-a5598af elementor-widget elementor-widget-text-editor\" data-id=\"a5598af\" 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 secci\u00f3n que se nos muestra, indicamos un nombre al <em><strong>Servidor<\/strong><\/em> que estamos por registrar.<\/p><p>Luego hacemos clic en la pesta\u00f1a <em><strong>Conexi\u00f3n.<\/strong><\/em><\/p>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f3dd719 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f3dd719\" 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-50 elementor-top-column elementor-element elementor-element-967ec5f\" data-id=\"967ec5f\" 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-1fc91ef elementor-widget elementor-widget-image\" data-id=\"1fc91ef\" 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\/2022\/07\/blog_1156.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1156\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MzcsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTU2LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"696\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1156.jpg\" class=\"attachment-large size-large wp-image-13637\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1156.jpg 632w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1156-272x300.jpg 272w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/>\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-db62bca elementor-widget elementor-widget-text-editor\" data-id=\"db62bca\" 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 primera casilla, indicamos la <a href=\"https:\/\/es.wikipedia.org\/wiki\/Direcci%C3%B3n_IP\" target=\"_blank\" rel=\"noopener\"><strong>direcci\u00f3n IP<\/strong><\/a> correspondiente, si hemos cambiado al momento de la <strong>instalaci\u00f3n de PostgreSQL<\/strong> el puerto, lo indicamos, caso contrario lo dejamos con el valor por defecto.<\/p><p>Escribimos la contrase\u00f1a de acceso y activamos si lo queremos la opci\u00f3n <em><strong>Salvar Contrase\u00f1a.<\/strong><\/em><\/p><p>Para finalizar, presionamos el bot\u00f3n <em><strong>Salvar.<\/strong><\/em><\/p><p>Si la conexi\u00f3n se logra, se cierra la ventana y en la parte izquierda de <strong>pgAdmin<\/strong> se nos muestra el nuevo servidor agregado.<\/p>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-d72fe02\" data-id=\"d72fe02\" 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-cf88418 elementor-widget elementor-widget-image\" data-id=\"cf88418\" 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\/2022\/07\/blog_1157.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1157\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MzgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTU3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"349\" height=\"689\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1157.jpg\" class=\"attachment-large size-large wp-image-13638\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1157.jpg 349w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1157-152x300.jpg 152w\" sizes=\"(max-width: 349px) 100vw, 349px\" \/>\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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b4ccf41 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b4ccf41\" 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-d226b82\" data-id=\"d226b82\" 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-1f7132f elementor-widget elementor-widget-text-editor\" data-id=\"1f7132f\" 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 este punto hemos ya logrado <a href=\"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/\" target=\"_blank\" rel=\"noopener\"><em><strong>Configurar Acceso Remoto PostgreSQL<\/strong><\/em><\/a> satisfactoriamente.<\/p><p>Podemos de este momento en adelante utilizar nuestra <em><strong>base de datos<\/strong><\/em> para los prop\u00f3sitos que nos hemos fijado.<\/p>\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>En art\u00edculos pasados hemos visto c\u00f3mo instalar PostgreSQL en Windows 10 y en Windows 11. En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS con Windows Server 2019 versi\u00f3n 1809 compilaci\u00f3n 17763.3165 como se aprecia en la captura de pantalla. El idioma del sistema [&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,"footnotes":""},"categories":[11,12,28,48],"tags":[],"class_list":["post-14988","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos","category-postgresql","category-windows","category-windows-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>C\u00f3mo Instalar PostgreSQL en Windows Server - Enrique V\u00e1squez -<\/title>\n<meta name=\"description\" content=\"En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS...\" \/>\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\/como-instalar-postgresql-en-windows-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo Instalar PostgreSQL en Windows Server\" \/>\n<meta property=\"og:description\" content=\"En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS con Windows Server 2019\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-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=\"2022-07-31T05:14:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-17T17:29:04+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=\"C\u00f3mo Instalar PostgreSQL en Windows Server\" \/>\n<meta name=\"twitter:description\" content=\"En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS con Windows Server 2019\" \/>\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=\"16 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/\"},\"author\":{\"name\":\"Enrique V\u00e1squez B.\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#\\\/schema\\\/person\\\/e53c62e8ab2e3f878e77d3a617483cc8\"},\"headline\":\"C\u00f3mo Instalar PostgreSQL en Windows Server\",\"datePublished\":\"2022-07-31T05:14:00+00:00\",\"dateModified\":\"2023-10-17T17:29:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/\"},\"wordCount\":1779,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#\\\/schema\\\/person\\\/e53c62e8ab2e3f878e77d3a617483cc8\"},\"image\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgresql_frame1.png\",\"articleSection\":[\"Bases de Datos\",\"PostgreSQL\",\"Windows\",\"Windows Server\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/#respond\"]}]},{\"@type\":[\"WebPage\",\"ItemPage\"],\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/\",\"url\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/\",\"name\":\"C\u00f3mo Instalar PostgreSQL en Windows Server - Enrique V\u00e1squez -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgresql_frame1.png\",\"datePublished\":\"2022-07-31T05:14:00+00:00\",\"dateModified\":\"2023-10-17T17:29:04+00:00\",\"description\":\"En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS...\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-instalar-postgresql-en-windows-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\\\/como-instalar-postgresql-en-windows-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\":\"C\u00f3mo Instalar PostgreSQL en Windows 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":"C\u00f3mo Instalar PostgreSQL en Windows Server - Enrique V\u00e1squez -","description":"En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS...","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\/como-instalar-postgresql-en-windows-server\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00f3mo Instalar PostgreSQL en Windows Server","og_description":"En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS con Windows Server 2019","og_url":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-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":"2022-07-31T05:14:00+00:00","article_modified_time":"2023-10-17T17:29:04+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":"C\u00f3mo Instalar PostgreSQL en Windows Server","twitter_description":"En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS con Windows Server 2019","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":"16 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/#article","isPartOf":{"@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/"},"author":{"name":"Enrique V\u00e1squez B.","@id":"https:\/\/quike.it\/es\/#\/schema\/person\/e53c62e8ab2e3f878e77d3a617483cc8"},"headline":"C\u00f3mo Instalar PostgreSQL en Windows Server","datePublished":"2022-07-31T05:14:00+00:00","dateModified":"2023-10-17T17:29:04+00:00","mainEntityOfPage":{"@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/"},"wordCount":1779,"commentCount":0,"publisher":{"@id":"https:\/\/quike.it\/es\/#\/schema\/person\/e53c62e8ab2e3f878e77d3a617483cc8"},"image":{"@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/#primaryimage"},"thumbnailUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png","articleSection":["Bases de Datos","PostgreSQL","Windows","Windows Server"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/#respond"]}]},{"@type":["WebPage","ItemPage"],"@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/","url":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/","name":"C\u00f3mo Instalar PostgreSQL en Windows Server - Enrique V\u00e1squez -","isPartOf":{"@id":"https:\/\/quike.it\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/#primaryimage"},"image":{"@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/#primaryimage"},"thumbnailUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png","datePublished":"2022-07-31T05:14:00+00:00","dateModified":"2023-10-17T17:29:04+00:00","description":"En este art\u00edculo, veremos paso a paso, como instalar PostgreSQL en Windows Server. Para el ejemplo utilizar\u00e9 un servidor VPS...","breadcrumb":{"@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-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\/como-instalar-postgresql-en-windows-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":"C\u00f3mo Instalar PostgreSQL en Windows 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\/14988","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=14988"}],"version-history":[{"count":52,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/posts\/14988\/revisions"}],"predecessor-version":[{"id":30472,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/posts\/14988\/revisions\/30472"}],"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=14988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/categories?post=14988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/tags?post=14988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}