{"id":13563,"date":"2022-07-19T06:37:00","date_gmt":"2022-07-19T05:37:00","guid":{"rendered":"https:\/\/quike.it\/es\/?p=13563"},"modified":"2024-07-24T14:21:41","modified_gmt":"2024-07-24T13:21:41","slug":"como-configurar-acceso-remoto-postgresql","status":"publish","type":"post","link":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/","title":{"rendered":"C\u00f3mo Configurar Acceso Remoto PostgreSQL"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"13563\" class=\"elementor elementor-13563\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4769ebe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4769ebe\" 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-3eeed4c\" data-id=\"3eeed4c\" 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-48a35e6 elementor-widget elementor-widget-text-editor\" data-id=\"48a35e6\" 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 <strong>instalado <em>PostgreSQL<\/em>,<\/strong> sea en ambiente <a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-linux\/\" target=\"_blank\" rel=\"noopener\"><strong>Linux<\/strong><\/a> o en ambiente <strong>Windows<\/strong> (<strong><em><a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows\/\" target=\"_blank\" rel=\"noopener\">Windows 10<\/a> o <a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows-11\/\" target=\"_blank\" rel=\"noopener\">Windows 11<\/a><\/em><\/strong>), es posible que surja la necesidad de permitir el <em><strong>acceso remoto a la base de datos.<\/strong><\/em><\/p><p>En este art\u00edculo explicaremos paso por paso <em><strong>c\u00f3mo configurar el Acceso Remoto PostgreSQL<\/strong><\/em> en los diferentes posibles escenarios en los que nos podr\u00edamos encontrar.<\/p><p>Cuando se ha instalado <em><strong>PostgreSQL,<\/strong><\/em> el acceso a la <strong>base de datos<\/strong> est\u00e1 disponible \u00fanicamente en modo local.<\/p><p>Esto significa que solo en el dispositivo que hace de <a href=\"https:\/\/es.wikipedia.org\/wiki\/Servidor#Tipos_de_servidor\" target=\"_blank\" rel=\"noopener\"><em><strong>servidor de datos<\/strong><\/em><\/a> es posible acceder a los mismos.<\/p><p>Si intentamos acceder a la <em><strong>base de datos<\/strong><\/em> desde otro pc en una <em><strong>intranet<\/strong><\/em> o desde una <em><strong>conexi\u00f3n remota<\/strong><\/em> a trav\u00e9s de <em><strong>internet,<\/strong><\/em> debemos configurar la <strong><em>base de datos<\/em> <\/strong>en modo que <em><b>reciba\/acepte<\/b><\/em> accesos desde <a href=\"https:\/\/es.wikipedia.org\/wiki\/Direcci%C3%B3n_IP\" target=\"_blank\" rel=\"noopener\"><em><strong>direcciones IP<\/strong><\/em><\/a> fuera de la local <a href=\"https:\/\/es.wikipedia.org\/wiki\/Localhost\" target=\"_blank\" rel=\"noopener\"><strong><em>(localhost)<\/em><\/strong><\/a><\/p><p>Para facilitar la configuraci\u00f3n, elije el escenario en el que te encuentres en la siguiente secci\u00f3n.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d56414 elementor-widget elementor-widget-global elementor-global-23404 elementor-widget-table-of-contents\" data-id=\"8d56414\" 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__8d56414\" 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<div class=\"elementor-element elementor-element-3f25a05 elementor-grid-1 elementor-grid-tablet-2 elementor-grid-mobile-1 elementor-widget elementor-widget-loop-grid\" data-id=\"3f25a05\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;template_id&quot;:&quot;30519&quot;,&quot;columns&quot;:1,&quot;_skin&quot;:&quot;post&quot;,&quot;columns_tablet&quot;:&quot;2&quot;,&quot;columns_mobile&quot;:&quot;1&quot;,&quot;edit_handle_selector&quot;:&quot;[data-elementor-type=\\&quot;loop-item\\&quot;]&quot;,&quot;row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"loop-grid.post\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-loop-container elementor-grid\" role=\"list\">\n\t\t<style id=\"loop-30519\">.elementor-30519 .elementor-element.elementor-element-98493d2 .elementor-column-gap-custom .elementor-column > .elementor-element-populated{padding:2px;}.elementor-30519 .elementor-element.elementor-element-ccee508 > .elementor-widget-wrap > .elementor-widget:not(.elementor-widget__width-auto):not(.elementor-widget__width-initial):not(:last-child):not(.elementor-absolute){--kit-widget-spacing:1px;}.elementor-widget-image .widget-image-caption{font-family:var( --e-global-typography-text-font-family ), Sans-serif;font-weight:var( --e-global-typography-text-font-weight );}.elementor-30519 .elementor-element.elementor-element-80149f2 img{height:85px;object-fit:cover;object-position:center center;}.elementor-30519 .elementor-element.elementor-element-80149f2:not( .elementor-widget-image ), .elementor-30519 .elementor-element.elementor-element-80149f2.elementor-widget-image img{-webkit-mask-image:url( https:\/\/quike.it\/es\/wp-content\/plugins\/elementor\/assets\/mask-shapes\/circle.svg );-webkit-mask-size:contain;-webkit-mask-position:center center;-webkit-mask-repeat:no-repeat;}.elementor-30519 .elementor-element.elementor-element-2109b1e > .elementor-widget-wrap > .elementor-widget:not(.elementor-widget__width-auto):not(.elementor-widget__width-initial):not(:last-child):not(.elementor-absolute){--kit-widget-spacing:3px;}.elementor-widget-post-info .elementor-icon-list-item{font-family:var( --e-global-typography-text-font-family ), Sans-serif;font-weight:var( --e-global-typography-text-font-weight );}.elementor-30519 .elementor-element.elementor-element-26a68f7 .elementor-icon-list-icon{width:17px;}.elementor-30519 .elementor-element.elementor-element-26a68f7 .elementor-icon-list-icon i{font-size:17px;}.elementor-30519 .elementor-element.elementor-element-26a68f7 .elementor-icon-list-icon svg{--e-icon-list-icon-size:17px;}body:not(.rtl) .elementor-30519 .elementor-element.elementor-element-26a68f7 .elementor-icon-list-text{padding-left:5px;}body.rtl .elementor-30519 .elementor-element.elementor-element-26a68f7 .elementor-icon-list-text{padding-right:5px;}.elementor-30519 .elementor-element.elementor-element-26a68f7 .elementor-icon-list-item{font-family:\"Work Sans\", Sans-serif;font-weight:600;text-transform:uppercase;word-spacing:0px;}.elementor-30519 .elementor-element.elementor-element-26a68f7{width:100%;max-width:100%;align-self:center;}.elementor-widget-heading .elementor-heading-title{font-family:var( --e-global-typography-primary-font-family ), Sans-serif;font-weight:var( --e-global-typography-primary-font-weight );}.elementor-30519 .elementor-element.elementor-element-1ed9e84 .elementor-heading-title{font-family:\"Roboto\", Sans-serif;font-weight:600;color:#000000;}.elementor-widget-icon-list .elementor-icon-list-item > .elementor-icon-list-text, .elementor-widget-icon-list .elementor-icon-list-item > a{font-family:var( --e-global-typography-text-font-family ), Sans-serif;font-weight:var( --e-global-typography-text-font-weight );}.elementor-30519 .elementor-element.elementor-element-714486b .elementor-icon-list-icon i{color:#000000;transition:color 0.3s;}.elementor-30519 .elementor-element.elementor-element-714486b .elementor-icon-list-icon svg{fill:#000000;transition:fill 0.3s;}.elementor-30519 .elementor-element.elementor-element-714486b{--e-icon-list-icon-size:13px;--e-icon-list-icon-align:left;--e-icon-list-icon-margin:0 calc(var(--e-icon-list-icon-size, 1em) * 0.25) 0 0;--icon-vertical-align:center;--icon-vertical-offset:0px;margin:0px 0px calc(var(--kit-widget-spacing, 0px) + 0px) 0px;padding:0px 0px 0px 0px;width:100%;max-width:100%;}.elementor-30519 .elementor-element.elementor-element-714486b .elementor-icon-list-item > .elementor-icon-list-text, .elementor-30519 .elementor-element.elementor-element-714486b .elementor-icon-list-item > a{font-family:\"Work Sans\", Sans-serif;font-size:11px;font-weight:500;text-transform:capitalize;line-height:16px;letter-spacing:1px;}.elementor-30519 .elementor-element.elementor-element-714486b .elementor-icon-list-text{color:#333333;transition:color 0.3s;}.elementor-30519 .elementor-element.elementor-element-0a32de7 .elementor-icon-list-icon i{color:#000000;transition:color 0.3s;}.elementor-30519 .elementor-element.elementor-element-0a32de7 .elementor-icon-list-icon svg{fill:#000000;transition:fill 0.3s;}.elementor-30519 .elementor-element.elementor-element-0a32de7{--e-icon-list-icon-size:13px;--e-icon-list-icon-align:left;--e-icon-list-icon-margin:0 calc(var(--e-icon-list-icon-size, 1em) * 0.25) 0 0;--icon-vertical-align:center;--icon-vertical-offset:0px;margin:0px 0px calc(var(--kit-widget-spacing, 0px) + 0px) 0px;padding:0px 0px 0px 0px;width:100%;max-width:100%;}.elementor-30519 .elementor-element.elementor-element-0a32de7 .elementor-icon-list-item > .elementor-icon-list-text, .elementor-30519 .elementor-element.elementor-element-0a32de7 .elementor-icon-list-item > a{font-family:\"Work Sans\", Sans-serif;font-size:11px;font-weight:500;text-transform:capitalize;line-height:16px;letter-spacing:1px;}.elementor-30519 .elementor-element.elementor-element-0a32de7 .elementor-icon-list-text{color:#333333;transition:color 0.3s;}@media(min-width:768px){.elementor-30519 .elementor-element.elementor-element-ccee508{width:20%;}.elementor-30519 .elementor-element.elementor-element-2109b1e{width:79.997%;}}@media(max-width:767px){.elementor-30519 .elementor-element.elementor-element-98493d2 .elementor-column-gap-custom .elementor-column > .elementor-element-populated{padding:2px;}.elementor-30519 .elementor-element.elementor-element-ccee508{width:25%;}.elementor-30519 .elementor-element.elementor-element-2109b1e{width:75%;}.elementor-30519 .elementor-element.elementor-element-1ed9e84 .elementor-heading-title{font-size:15px;}}<\/style>\t\t<div data-elementor-type=\"loop-item\" data-elementor-id=\"30519\" class=\"elementor elementor-30519 e-loop-item e-loop-item-28627 post-28627 post type-post status-publish format-standard has-post-thumbnail hentry category-bases-de-datos category-postgresql\" data-elementor-post-type=\"elementor_library\" data-custom-edit-handle=\"1\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-98493d2 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"98493d2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-custom\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-ccee508\" data-id=\"ccee508\" 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-80149f2 elementor-widget elementor-widget-image\" data-id=\"80149f2\" 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\/postgresql-16-liberado\/\" target=\"_blank\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"900\" height=\"600\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png\" class=\"attachment-full size-full wp-image-13912\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1.png 900w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1-300x200.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgresql_frame1-768x512.png 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/>\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-2109b1e\" data-id=\"2109b1e\" 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-26a68f7 elementor-align-left elementor-widget__width-inherit elementor-widget elementor-widget-post-info\" data-id=\"26a68f7\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"categorias-post\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-dfd774d elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-custom\">\n\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/category\/informatica\/bases-de-datos\/\" rel=\"tag\">Bases de Datos<\/a> <a href=\"https:\/\/quike.it\/es\/category\/informatica\/bases-de-datos\/postgresql\/\" rel=\"tag\">PostgreSQL<\/a>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ed9e84 elementor-widget elementor-widget-heading\" data-id=\"1ed9e84\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"top-post\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<div class=\"elementor-heading-title elementor-size-default\"><a href=\"https:\/\/quike.it\/es\/postgresql-16-liberado\/\" target=\"_blank\">PostgreSQL 16 Liberado!<\/a><\/div>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-714486b elementor-icon-list--layout-inline elementor-align-start elementor-hidden-tablet elementor-hidden-mobile elementor-widget__width-inherit elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"714486b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/postgresql-16-liberado\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-book-reader\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M352 96c0-53.02-42.98-96-96-96s-96 42.98-96 96 42.98 96 96 96 96-42.98 96-96zM233.59 241.1c-59.33-36.32-155.43-46.3-203.79-49.05C13.55 191.13 0 203.51 0 219.14v222.8c0 14.33 11.59 26.28 26.49 27.05 43.66 2.29 131.99 10.68 193.04 41.43 9.37 4.72 20.48-1.71 20.48-11.87V252.56c-.01-4.67-2.32-8.95-6.42-11.46zm248.61-49.05c-48.35 2.74-144.46 12.73-203.78 49.05-4.1 2.51-6.41 6.96-6.41 11.63v245.79c0 10.19 11.14 16.63 20.54 11.9 61.04-30.72 149.32-39.11 192.97-41.4 14.9-.78 26.49-12.73 26.49-27.06V219.14c-.01-15.63-13.56-28.01-29.81-27.09z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">132 lecturas<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-comments\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 192c0-88.4-93.1-160-208-160S0 103.6 0 192c0 34.3 14.1 65.9 38 92-13.4 30.2-35.5 54.2-35.8 54.5-2.2 2.3-2.8 5.7-1.5 8.7S4.8 352 8 352c36.6 0 66.9-12.3 88.7-25 32.2 15.7 70.3 25 111.3 25 114.9 0 208-71.6 208-160zm122 220c23.9-26 38-57.7 38-92 0-66.9-53.5-124.2-129.3-148.1.9 6.6 1.3 13.3 1.3 20.1 0 105.9-107.7 192-240 192-10.8 0-21.3-.8-31.7-1.9C207.8 439.6 281.8 480 368 480c41 0 79.1-9.2 111.3-25 21.8 12.7 52.1 25 88.7 25 3.2 0 6.1-1.9 7.3-4.8 1.3-2.9.7-6.3-1.5-8.7-.3-.3-22.4-24.2-35.8-54.5z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/quike.it\/es\/postgresql-16-liberado\/#respond\">sin comentarios<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a32de7 elementor-icon-list--layout-inline elementor-align-start elementor-widget__width-inherit elementor-hidden-desktop elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"0a32de7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/postgresql-16-liberado\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-book-reader\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M352 96c0-53.02-42.98-96-96-96s-96 42.98-96 96 42.98 96 96 96 96-42.98 96-96zM233.59 241.1c-59.33-36.32-155.43-46.3-203.79-49.05C13.55 191.13 0 203.51 0 219.14v222.8c0 14.33 11.59 26.28 26.49 27.05 43.66 2.29 131.99 10.68 193.04 41.43 9.37 4.72 20.48-1.71 20.48-11.87V252.56c-.01-4.67-2.32-8.95-6.42-11.46zm248.61-49.05c-48.35 2.74-144.46 12.73-203.78 49.05-4.1 2.51-6.41 6.96-6.41 11.63v245.79c0 10.19 11.14 16.63 20.54 11.9 61.04-30.72 149.32-39.11 192.97-41.4 14.9-.78 26.49-12.73 26.49-27.06V219.14c-.01-15.63-13.56-28.01-29.81-27.09z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">132 lecturas<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-comments\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 192c0-88.4-93.1-160-208-160S0 103.6 0 192c0 34.3 14.1 65.9 38 92-13.4 30.2-35.5 54.2-35.8 54.5-2.2 2.3-2.8 5.7-1.5 8.7S4.8 352 8 352c36.6 0 66.9-12.3 88.7-25 32.2 15.7 70.3 25 111.3 25 114.9 0 208-71.6 208-160zm122 220c23.9-26 38-57.7 38-92 0-66.9-53.5-124.2-129.3-148.1.9 6.6 1.3 13.3 1.3 20.1 0 105.9-107.7 192-240 192-10.8 0-21.3-.8-31.7-1.9C207.8 439.6 281.8 480 368 480c41 0 79.1-9.2 111.3-25 21.8 12.7 52.1 25 88.7 25 3.2 0 6.1-1.9 7.3-4.8 1.3-2.9.7-6.3-1.5-8.7-.3-.3-22.4-24.2-35.8-54.5z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/quike.it\/es\/postgresql-16-liberado\/#respond\">0<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\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<\/div>\n\t\t\t\t<\/div>\n\t\t\n\t\t\t\t\t\t<\/div>\n\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-a1a2fda articulo elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a1a2fda\" 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-b9b9d33\" data-id=\"b9b9d33\" 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-0c79fc0 elementor-widget elementor-widget-heading\" data-id=\"0c79fc0\" 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\">Configurar Acceso Remoto PostgreSQL en Windows 10<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7db7921 elementor-widget elementor-widget-text-editor\" data-id=\"7db7921\" 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>Luego de haber <a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows\/\" target=\"_blank\" rel=\"noopener\"><strong>instalado PostgreSQL en Windows 10<\/strong><\/a>, abrimos el <strong>explorador de archivos<\/strong> y nos colocamos en la carpeta en donde se instal\u00f3 <em><strong>PostgreSQL.<\/strong><\/em><\/p><p>Por lo general se instala en la ruta:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25659d2 elementor-widget elementor-widget-code-highlight\" data-id=\"25659d2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>C:\\Program Files\\PostgreSQL<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-63716e4 elementor-widget elementor-widget-image\" data-id=\"63716e4\" 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_1158.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1158\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NTksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTU4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1365\" height=\"299\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1158.jpg\" class=\"attachment-full size-full wp-image-13659\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1158.jpg 1365w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1158-300x66.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1158-1024x224.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1158-768x168.jpg 768w\" sizes=\"(max-width: 1365px) 100vw, 1365px\" \/>\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-3fad83d elementor-widget elementor-widget-text-editor\" data-id=\"3fad83d\" 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 el caso ilustrado en la <a href=\"https:\/\/quike.it\/es\/como-hacer-la-captura-de-pantalla-en-windows\/\" target=\"_blank\" rel=\"noopener\"><strong>captura de pantalla<\/strong><\/a> anterior, notamos que contamos con una instalaci\u00f3n de <em><strong>PostgreSQL versi\u00f3n 13.<\/strong><\/em><\/p><p>Es posible que el dispositivo en el que estemos trabajando, se halla instalado una versi\u00f3n diversa, pero eso poco importa a fines de esta configuraci\u00f3n.<\/p><p>Abrimos la carpeta por medio de un <em><strong>doble clic<\/strong><\/em> sobre el <em>nombre de la versi\u00f3n<\/em>.<\/p><p>Una vez dentro, individuamos la carpeta llamada <strong>\u00ab<em>data<\/em>\u00bb <\/strong>y accedemos. 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-ec54218 elementor-widget elementor-widget-image\" data-id=\"ec54218\" 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_1159.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1159\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NjAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTU5LmpwZyJ9\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1359\" height=\"447\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1159.jpg\" class=\"attachment-full size-full wp-image-13660\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1159.jpg 1359w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1159-300x99.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1159-1024x337.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1159-768x253.jpg 768w\" sizes=\"(max-width: 1359px) 100vw, 1359px\" \/>\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-4c3571f elementor-widget elementor-widget-heading\" data-id=\"4c3571f\" 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-f0adcb6 elementor-widget elementor-widget-text-editor\" data-id=\"f0adcb6\" 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-acbb102 elementor-widget elementor-widget-image\" data-id=\"acbb102\" 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_1160.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1160\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NjEsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTYwLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1081\" height=\"590\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1160.jpg\" class=\"attachment-full size-full wp-image-13661\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1160.jpg 1081w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1160-300x164.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1160-1024x559.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1160-768x419.jpg 768w\" sizes=\"(max-width: 1081px) 100vw, 1081px\" \/>\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-d8afb10 elementor-widget elementor-widget-text-editor\" data-id=\"d8afb10\" 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>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed9af1f elementor-widget elementor-widget-code-highlight\" data-id=\"ed9af1f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sass \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sass\">\n\t\t\t\t\t<xmp>host all all 0.0.0.0\/0 scram-sha-256<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-10ca58c elementor-widget elementor-widget-text-editor\" data-id=\"10ca58c\" 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-a45cfcd elementor-widget elementor-widget-image\" data-id=\"a45cfcd\" 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_1161.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1161\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NjIsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTYxLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1117\" height=\"215\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1161.jpg\" class=\"attachment-full size-full wp-image-13662\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1161.jpg 1117w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1161-300x58.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1161-1024x197.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1161-768x148.jpg 768w\" sizes=\"(max-width: 1117px) 100vw, 1117px\" \/>\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-4d7d8ff elementor-widget elementor-widget-text-editor\" data-id=\"4d7d8ff\" 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>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-37bb033 elementor-widget elementor-widget-code-highlight\" data-id=\"37bb033\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sass \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sass\">\n\t\t\t\t\t<xmp>host all all 0.0.0.0\/0 md5<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f5ccca elementor-alert-warning elementor-widget elementor-widget-alert\" data-id=\"1f5ccca\" 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-1685305 elementor-widget elementor-widget-heading\" data-id=\"1685305\" 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-f8b57f2 elementor-widget elementor-widget-text-editor\" data-id=\"f8b57f2\" 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-1528c1f elementor-widget elementor-widget-image\" data-id=\"1528c1f\" 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_1162.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1162\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NjMsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTYyLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1063\" height=\"501\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1162.jpg\" class=\"attachment-full size-full wp-image-13663\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1162.jpg 1063w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1162-300x141.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1162-1024x483.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1162-768x362.jpg 768w\" sizes=\"(max-width: 1063px) 100vw, 1063px\" \/>\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-7eeb572 elementor-widget elementor-widget-text-editor\" data-id=\"7eeb572\" 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 asignado tenga: <em><strong>&#8216;*&#8217;<\/strong><\/em><\/p><p>El hecho que se encuentre el<em><strong> &#8216;*&#8217;<\/strong><\/em> significa que la <b><i>base de datos<\/i><\/b> va a aceptar conexiones en entrada desde cualquier <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> que se la solicite.<\/p><p>Si queremos restringir el acceso remoto a una <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> espec\u00edfica, es suficiente escribir dentro de las comillas simples la <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> que vamos a permitir.<\/p><p>Si fuese el caso que hay mas <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcciones IP<\/strong><\/em><\/a> individuales, se las debe escribir separadas por una coma (,).<\/p><p>Una vez realizados los cambios, <em><strong>hay que registrar las modificaciones<\/strong><\/em>, si se han hecho, <em><strong>del archivo<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-758e6f3 elementor-widget elementor-widget-heading\" data-id=\"758e6f3\" 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-3e7cfae elementor-widget elementor-widget-text-editor\" data-id=\"3e7cfae\" 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> que tengamos instalado en el dispositivo que hace las veces de<a href=\"https:\/\/es.wikipedia.org\/wiki\/Servidor#Tipos_de_servidor\" target=\"_blank\" rel=\"noopener\"> <strong>servidor de datos<\/strong><\/a>.<\/p><p>En el caso de la <a href=\"https:\/\/quike.it\/es\/que-es-una-maquina-virtual\/\" target=\"_blank\" rel=\"noopener\"><strong>m\u00e1quina virtual<\/strong><\/a> que estoy utilizando en el ejemplo, el <em><strong>Firewall<\/strong><\/em> activo es el que se instala junto con <strong>Windows 10<\/strong>\u00a0en forma predefinida.<\/p><p>Abrimos entonces la secci\u00f3n del <em><strong>Firewall de Windows 10<\/strong><\/em>, escribiendo la palabra <i>firewall <\/i>en la barra de b\u00fasqueda y haciendo clic en la aplicaci\u00f3n <em><strong>Firewall<\/strong> <strong>de Windows Defender<\/strong><\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a52227d elementor-widget elementor-widget-image\" data-id=\"a52227d\" 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_1163.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1163\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NjcsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTYzLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"834\" height=\"685\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1163.jpg\" class=\"attachment-full size-full wp-image-13667\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1163.jpg 834w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1163-300x246.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1163-768x631.jpg 768w\" sizes=\"(max-width: 834px) 100vw, 834px\" \/>\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<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-5330bb6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5330bb6\" 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-inner-column elementor-element elementor-element-d0fec4a\" data-id=\"d0fec4a\" 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-8af913a elementor-widget elementor-widget-image\" data-id=\"8af913a\" 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_1164.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1164\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NjgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTY0LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"223\" height=\"372\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1164.jpg\" class=\"attachment-medium_large size-medium_large wp-image-13668\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1164.jpg 223w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1164-180x300.jpg 180w\" sizes=\"(max-width: 223px) 100vw, 223px\" \/>\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-inner-column elementor-element elementor-element-53b808b\" data-id=\"53b808b\" 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-92f0616 elementor-widget elementor-widget-text-editor\" data-id=\"92f0616\" 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 clic, se nos abre la secci\u00f3n principal del <strong><em>Firewall de Windows Defender<\/em><\/strong>.<\/p><p>Utilizamos la opci\u00f3n <em><strong>Configuraci\u00f3n avanzada<\/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>Reglas de entrada<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e64bf3b elementor-widget elementor-widget-image\" data-id=\"e64bf3b\" 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_1165.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1165\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NjksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTY1LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1059\" height=\"202\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1165.jpg\" class=\"attachment-full size-full wp-image-13669\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1165.jpg 1059w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1165-300x57.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1165-1024x195.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1165-768x146.jpg 768w\" sizes=\"(max-width: 1059px) 100vw, 1059px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-841f8aa elementor-widget elementor-widget-text-editor\" data-id=\"841f8aa\" 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>Nueva regla<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b950a0c elementor-widget elementor-widget-image\" data-id=\"b950a0c\" 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_1166.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1166\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NzAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTY2LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1062\" height=\"230\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1166.jpg\" class=\"attachment-full size-full wp-image-13670\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1166.jpg 1062w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1166-300x65.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1166-1024x222.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1166-768x166.jpg 768w\" sizes=\"(max-width: 1062px) 100vw, 1062px\" \/>\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-17d2a05 elementor-widget elementor-widget-text-editor\" data-id=\"17d2a05\" 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>Nueva regla<\/strong><\/em> y seguimos los siguientes pasos:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-6773216 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6773216\" 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-inner-column elementor-element elementor-element-ab41714\" data-id=\"ab41714\" 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-507da89 elementor-widget elementor-widget-image\" data-id=\"507da89\" 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_1167.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1167\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NzEsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTY3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1167.jpg\" class=\"attachment-large size-large wp-image-13671\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1167.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1167-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-53f3755 elementor-widget elementor-widget-text-editor\" data-id=\"53f3755\" 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>(puerto)\u00a0<\/em><\/strong>y presionamos <em><strong>Siguiente<\/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-inner-column elementor-element elementor-element-40b256b\" data-id=\"40b256b\" 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-015295e elementor-widget elementor-widget-image\" data-id=\"015295e\" 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_1168.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1168\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NzIsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTY4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1168.jpg\" class=\"attachment-large size-large wp-image-13672\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1168.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1168-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-0bdc9d5 elementor-widget elementor-widget-text-editor\" data-id=\"0bdc9d5\" 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>Puertos locales espec\u00edficos<\/strong><\/em>. Debemos escribir el puerto especificado en la <a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-windows\/\" target=\"_blank\" rel=\"noopener\"><strong>instalaci\u00f3n de PostgreSQL<\/strong><\/a>, 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>Siguiente<\/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-inner-section elementor-element elementor-element-9c2f38f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9c2f38f\" 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-inner-column elementor-element elementor-element-0b73954\" data-id=\"0b73954\" 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-e0928c9 elementor-widget elementor-widget-image\" data-id=\"e0928c9\" 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_1169.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1169\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NzMsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTY5LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1169.jpg\" class=\"attachment-large size-large wp-image-13673\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1169.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1169-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-64238c6 elementor-widget elementor-widget-text-editor\" data-id=\"64238c6\" 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>Permitir la conexi\u00f3n<\/strong><\/em>. Damos clic en <em><strong>Siguiente.<\/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-inner-column elementor-element elementor-element-1a46771\" data-id=\"1a46771\" 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-fe1c515 elementor-widget elementor-widget-image\" data-id=\"fe1c515\" 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_1170.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1170\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NzQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTcwLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1170.jpg\" class=\"attachment-large size-large wp-image-13674\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1170.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1170-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-db9e5ee elementor-widget elementor-widget-text-editor\" data-id=\"db9e5ee\" 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>Siguiente.<\/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-inner-section elementor-element elementor-element-36a70c6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"36a70c6\" 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-inner-column elementor-element elementor-element-f19d917\" data-id=\"f19d917\" 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-69ef7ff elementor-widget elementor-widget-image\" data-id=\"69ef7ff\" 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_1171.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1171\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2NzUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTcxLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1171.jpg\" class=\"attachment-large size-large wp-image-13675\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1171.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1171-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-inner-column elementor-element elementor-element-e9f4bae\" data-id=\"e9f4bae\" 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-0f262f0 elementor-widget elementor-widget-text-editor\" data-id=\"0f262f0\" 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 <i><b>nueva regla<\/b><\/i> que se va crear. Una vez hecho, presionamos el bot\u00f3n <em><strong>Finalizar.<\/strong><\/em><\/p><p>Hemos creado una <i>regla <\/i>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<div class=\"elementor-element elementor-element-477ceb8 elementor-widget elementor-widget-heading\" data-id=\"477ceb8\" 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-da0db05 elementor-widget elementor-widget-text-editor\" data-id=\"da0db05\" 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 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>servicios<\/em><\/strong> y haciendo <b>clic <\/b>en la aplicaci\u00f3n <em><strong>Servicios<\/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-f14fb4d elementor-widget elementor-widget-image\" data-id=\"f14fb4d\" 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\/2021\/07\/blog_581.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_581\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NzcxNywidXJsIjoiaHR0cHM6XC9cL3F1aWtlLml0XC9lc1wvd3AtY29udGVudFwvdXBsb2Fkc1wvc2l0ZXNcLzNcLzIwMjFcLzA3XC9ibG9nXzU4MS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"833\" height=\"682\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_581.png\" class=\"attachment-full size-full wp-image-7717\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_581.png 833w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_581-300x246.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_581-768x629.png 768w\" sizes=\"(max-width: 833px) 100vw, 833px\" \/>\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-585e8ee elementor-widget elementor-widget-text-editor\" data-id=\"585e8ee\" 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 servicios, individuamos el motor de la <strong>base de datos<\/strong> y entre las opciones que se muestran en la parte izquierda optamos por la que dice <strong><em>Reiniciar 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-35d0e93 elementor-widget elementor-widget-image\" data-id=\"35d0e93\" 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\/2021\/07\/blog_582.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_582\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NzcxOCwidXJsIjoiaHR0cHM6XC9cL3F1aWtlLml0XC9lc1wvd3AtY29udGVudFwvdXBsb2Fkc1wvc2l0ZXNcLzNcLzIwMjFcLzA3XC9ibG9nXzU4Mi5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"384\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_582-1024x492.png\" class=\"attachment-large size-large wp-image-7718\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_582-1024x492.png 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_582-300x144.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_582-768x369.png 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2021\/07\/blog_582.png 1235w\" 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<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-6803596 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6803596\" 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-inner-column elementor-element elementor-element-9a2e8f2\" data-id=\"9a2e8f2\" 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-1c746ac elementor-widget elementor-widget-image\" data-id=\"1c746ac\" 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_1172.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1172\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2ODUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTcyLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"406\" height=\"179\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1172.jpg\" class=\"attachment-large size-large wp-image-13685\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1172.jpg 406w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1172-300x132.jpg 300w\" sizes=\"(max-width: 406px) 100vw, 406px\" \/>\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-inner-column elementor-element elementor-element-e6ef7c2\" data-id=\"e6ef7c2\" 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-7093bb0 elementor-widget elementor-widget-text-editor\" data-id=\"7093bb0\" 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 <strong><em>servicio<\/em><\/strong> se ha reiniciado, ya estamos listos para realizar la prueba de que nuestra configuraci\u00f3n fue hecha correctamente.\u00a0<\/p><p>Podemos ir a la secci\u00f3n <strong>Probar el Acceso Remoto<\/strong>.<\/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 class=\"elementor-element elementor-element-b3f3f03 elementor-grid-1 elementor-grid-tablet-2 elementor-grid-mobile-1 elementor-widget elementor-widget-loop-grid\" data-id=\"b3f3f03\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;template_id&quot;:&quot;30519&quot;,&quot;columns&quot;:1,&quot;_skin&quot;:&quot;post&quot;,&quot;columns_tablet&quot;:&quot;2&quot;,&quot;columns_mobile&quot;:&quot;1&quot;,&quot;edit_handle_selector&quot;:&quot;[data-elementor-type=\\&quot;loop-item\\&quot;]&quot;,&quot;row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"loop-grid.post\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-loop-container elementor-grid\" role=\"list\">\n\t\t\t\t<div data-elementor-type=\"loop-item\" data-elementor-id=\"30519\" class=\"elementor elementor-30519 e-loop-item e-loop-item-37475 post-37475 post type-post status-publish format-standard has-post-thumbnail hentry category-bases-de-datos category-postgresql\" data-elementor-post-type=\"elementor_library\" data-custom-edit-handle=\"1\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-98493d2 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"98493d2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-custom\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-ccee508\" data-id=\"ccee508\" 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-80149f2 elementor-widget elementor-widget-image\" data-id=\"80149f2\" 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\/consejos-practicos-sobre-el-manejo-de-nulls-en-postgresql\/\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1120\" height=\"600\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/04\/PostgreSQL_new.jpg\" class=\"attachment-full size-full wp-image-37477\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/04\/PostgreSQL_new.jpg 1120w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/04\/PostgreSQL_new-300x161.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/04\/PostgreSQL_new-1024x549.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/04\/PostgreSQL_new-768x411.jpg 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" \/>\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-2109b1e\" data-id=\"2109b1e\" 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-26a68f7 elementor-align-left elementor-widget__width-inherit elementor-widget elementor-widget-post-info\" data-id=\"26a68f7\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"categorias-post\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-dfd774d elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-custom\">\n\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/category\/informatica\/bases-de-datos\/\" rel=\"tag\">Bases de Datos<\/a> <a href=\"https:\/\/quike.it\/es\/category\/informatica\/bases-de-datos\/postgresql\/\" rel=\"tag\">PostgreSQL<\/a>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ed9e84 elementor-widget elementor-widget-heading\" data-id=\"1ed9e84\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"top-post\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<div class=\"elementor-heading-title elementor-size-default\"><a href=\"https:\/\/quike.it\/es\/consejos-practicos-sobre-el-manejo-de-nulls-en-postgresql\/\" target=\"_blank\">Consejos Pr\u00e1cticos sobre el Manejo de NULLs en PostgreSQL<\/a><\/div>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-714486b elementor-icon-list--layout-inline elementor-align-start elementor-hidden-tablet elementor-hidden-mobile elementor-widget__width-inherit elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"714486b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/consejos-practicos-sobre-el-manejo-de-nulls-en-postgresql\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-book-reader\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M352 96c0-53.02-42.98-96-96-96s-96 42.98-96 96 42.98 96 96 96 96-42.98 96-96zM233.59 241.1c-59.33-36.32-155.43-46.3-203.79-49.05C13.55 191.13 0 203.51 0 219.14v222.8c0 14.33 11.59 26.28 26.49 27.05 43.66 2.29 131.99 10.68 193.04 41.43 9.37 4.72 20.48-1.71 20.48-11.87V252.56c-.01-4.67-2.32-8.95-6.42-11.46zm248.61-49.05c-48.35 2.74-144.46 12.73-203.78 49.05-4.1 2.51-6.41 6.96-6.41 11.63v245.79c0 10.19 11.14 16.63 20.54 11.9 61.04-30.72 149.32-39.11 192.97-41.4 14.9-.78 26.49-12.73 26.49-27.06V219.14c-.01-15.63-13.56-28.01-29.81-27.09z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">228 lecturas<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-comments\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 192c0-88.4-93.1-160-208-160S0 103.6 0 192c0 34.3 14.1 65.9 38 92-13.4 30.2-35.5 54.2-35.8 54.5-2.2 2.3-2.8 5.7-1.5 8.7S4.8 352 8 352c36.6 0 66.9-12.3 88.7-25 32.2 15.7 70.3 25 111.3 25 114.9 0 208-71.6 208-160zm122 220c23.9-26 38-57.7 38-92 0-66.9-53.5-124.2-129.3-148.1.9 6.6 1.3 13.3 1.3 20.1 0 105.9-107.7 192-240 192-10.8 0-21.3-.8-31.7-1.9C207.8 439.6 281.8 480 368 480c41 0 79.1-9.2 111.3-25 21.8 12.7 52.1 25 88.7 25 3.2 0 6.1-1.9 7.3-4.8 1.3-2.9.7-6.3-1.5-8.7-.3-.3-22.4-24.2-35.8-54.5z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/quike.it\/es\/consejos-practicos-sobre-el-manejo-de-nulls-en-postgresql\/#respond\">sin comentarios<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a32de7 elementor-icon-list--layout-inline elementor-align-start elementor-widget__width-inherit elementor-hidden-desktop elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"0a32de7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/consejos-practicos-sobre-el-manejo-de-nulls-en-postgresql\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-book-reader\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M352 96c0-53.02-42.98-96-96-96s-96 42.98-96 96 42.98 96 96 96 96-42.98 96-96zM233.59 241.1c-59.33-36.32-155.43-46.3-203.79-49.05C13.55 191.13 0 203.51 0 219.14v222.8c0 14.33 11.59 26.28 26.49 27.05 43.66 2.29 131.99 10.68 193.04 41.43 9.37 4.72 20.48-1.71 20.48-11.87V252.56c-.01-4.67-2.32-8.95-6.42-11.46zm248.61-49.05c-48.35 2.74-144.46 12.73-203.78 49.05-4.1 2.51-6.41 6.96-6.41 11.63v245.79c0 10.19 11.14 16.63 20.54 11.9 61.04-30.72 149.32-39.11 192.97-41.4 14.9-.78 26.49-12.73 26.49-27.06V219.14c-.01-15.63-13.56-28.01-29.81-27.09z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">228 lecturas<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-comments\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 192c0-88.4-93.1-160-208-160S0 103.6 0 192c0 34.3 14.1 65.9 38 92-13.4 30.2-35.5 54.2-35.8 54.5-2.2 2.3-2.8 5.7-1.5 8.7S4.8 352 8 352c36.6 0 66.9-12.3 88.7-25 32.2 15.7 70.3 25 111.3 25 114.9 0 208-71.6 208-160zm122 220c23.9-26 38-57.7 38-92 0-66.9-53.5-124.2-129.3-148.1.9 6.6 1.3 13.3 1.3 20.1 0 105.9-107.7 192-240 192-10.8 0-21.3-.8-31.7-1.9C207.8 439.6 281.8 480 368 480c41 0 79.1-9.2 111.3-25 21.8 12.7 52.1 25 88.7 25 3.2 0 6.1-1.9 7.3-4.8 1.3-2.9.7-6.3-1.5-8.7-.3-.3-22.4-24.2-35.8-54.5z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/quike.it\/es\/consejos-practicos-sobre-el-manejo-de-nulls-en-postgresql\/#respond\">0<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\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<\/div>\n\t\t\t\t<\/div>\n\t\t\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de892fe elementor-widget elementor-widget-heading\" data-id=\"de892fe\" 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\">Configurar Acceso Remoto PostgreSQL en Windows 11<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dbdc679 elementor-widget elementor-widget-text-editor\" data-id=\"dbdc679\" 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>Luego de haber <strong>instalado PostgreSQL en Windows 11<\/strong>, abrimos el <strong>explorador de archivos<\/strong> y nos colocamos en la carpeta en donde se instal\u00f3 <em><strong>PostgreSQL.<\/strong><\/em><\/p><p>Por lo general se instala en la ruta:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4e1280 elementor-widget elementor-widget-code-highlight\" data-id=\"c4e1280\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>C:\\Program Files\\PostgreSQL<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5f6f838 elementor-widget elementor-widget-image\" data-id=\"5f6f838\" 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_1137.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1137\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM1ODMsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTM3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1350\" height=\"308\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1137.jpg\" class=\"attachment-full size-full wp-image-13583\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1137.jpg 1350w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1137-300x68.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1137-1024x234.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1137-768x175.jpg 768w\" sizes=\"(max-width: 1350px) 100vw, 1350px\" \/>\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-0283fe1 elementor-widget elementor-widget-text-editor\" data-id=\"0283fe1\" 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 el caso ilustrado en la <a href=\"https:\/\/quike.it\/es\/como-hacer-la-captura-de-pantalla-en-windows\/\" target=\"_blank\" rel=\"noopener\"><strong>captura de pantalla<\/strong><\/a> anterior, notamos que contamos con una instalaci\u00f3n de <em><strong>PostgreSQL versi\u00f3n 14.<\/strong><\/em><\/p><p>Es posible que el dispositivo en el que estemos trabajando, halla una versi\u00f3n diversa, pero eso poco importa a fines de esta configuraci\u00f3n.<\/p><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. debemos poder visualizar los archivos:\u00a0<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-0f4c36e elementor-widget elementor-widget-image\" data-id=\"0f4c36e\" 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_1138.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1138\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM1ODQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTM4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1124\" height=\"472\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1138.jpg\" class=\"attachment-full size-full wp-image-13584\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1138.jpg 1124w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1138-300x126.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1138-1024x430.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1138-768x323.jpg 768w\" sizes=\"(max-width: 1124px) 100vw, 1124px\" \/>\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-c5987fd elementor-widget elementor-widget-heading\" data-id=\"c5987fd\" 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-f637073 elementor-widget elementor-widget-text-editor\" data-id=\"f637073\" 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 <a href=\"https:\/\/quike.it\/es\/descargar-e-instalar-libreoffice\/\" target=\"_blank\" rel=\"noopener\"><strong>editor de texto<\/strong><\/a> cualquiera.<\/p><p>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-26c23eb elementor-widget elementor-widget-image\" data-id=\"26c23eb\" 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_1139.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1139\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM1ODUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTM5LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1086\" height=\"606\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1139.jpg\" class=\"attachment-full size-full wp-image-13585\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1139.jpg 1086w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1139-300x167.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1139-1024x571.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1139-768x429.jpg 768w\" sizes=\"(max-width: 1086px) 100vw, 1086px\" \/>\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-fd71279 elementor-widget elementor-widget-text-editor\" data-id=\"fd71279\" 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>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e2b58c2 elementor-widget elementor-widget-code-highlight\" data-id=\"e2b58c2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>host all all 0.0.0.0\/0 scram-sha-256<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ce8de5 elementor-widget elementor-widget-text-editor\" data-id=\"2ce8de5\" 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-1183897 elementor-widget elementor-widget-image\" data-id=\"1183897\" 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_1140.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1140\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM1OTAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQwLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1142\" height=\"207\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1140.jpg\" class=\"attachment-full size-full wp-image-13590\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1140.jpg 1142w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1140-300x54.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1140-1024x186.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1140-768x139.jpg 768w\" sizes=\"(max-width: 1142px) 100vw, 1142px\" \/>\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-26632a0 elementor-widget elementor-widget-text-editor\" data-id=\"26632a0\" 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>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-07083e3 elementor-widget elementor-widget-code-highlight\" data-id=\"07083e3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>host all all 0.0.0.0\/0 md5<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1da5f38 elementor-alert-warning elementor-widget elementor-widget-alert\" data-id=\"1da5f38\" 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-0d630b4 elementor-widget elementor-widget-heading\" data-id=\"0d630b4\" 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-bc51fdd elementor-widget elementor-widget-text-editor\" data-id=\"bc51fdd\" 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-a79e057 elementor-widget elementor-widget-image\" data-id=\"a79e057\" 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=\"1086\" height=\"606\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1141.jpg\" class=\"attachment-full size-full wp-image-13604\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1141.jpg 1086w, 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-1024x571.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1141-768x429.jpg 768w\" sizes=\"(max-width: 1086px) 100vw, 1086px\" \/>\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-193659e elementor-widget elementor-widget-text-editor\" data-id=\"193659e\" 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 <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> que se la solicite.<\/p><p>Si queremos restringir el acceso remoto a una <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> espec\u00edfica, es suficiente escribir dentro de las comillas simples la <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> que vamos a permitir.<\/p><p>Si fuese el caso que hay mas <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcciones IP<\/strong><\/em><\/a> individuales, se las debe escribir separadas por una coma (,).<\/p><p>Una vez realizados los cambios, <em><strong>hay que registrar las modificaciones<\/strong><\/em>, si se han hecho, <em><strong>del archivo<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-20fc83d elementor-widget elementor-widget-heading\" data-id=\"20fc83d\" 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-668ae92 elementor-widget elementor-widget-text-editor\" data-id=\"668ae92\" 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> que tengamos instalado en el dispositivo que hace las veces de<a href=\"https:\/\/es.wikipedia.org\/wiki\/Servidor#Tipos_de_servidor\" target=\"_blank\" rel=\"noopener\"> <strong>servidor de datos<\/strong><\/a>.<\/p><p>En el caso de la <a href=\"https:\/\/quike.it\/es\/que-es-una-maquina-virtual\/\" target=\"_blank\" rel=\"noopener\"><strong>m\u00e1quina virtual<\/strong><\/a> que estoy utilizando en el ejemplo, el <em><strong>Firewall<\/strong><\/em> activo es el que se instala junto con <strong>Windows 11<\/strong> en forma predefinida.<\/p><p>Abrimos entonces la secci\u00f3n del <em><strong>Firewall de Windows 11<\/strong><\/em>, escribiendo la palabra firewall en la barra de b\u00fasqueda y haciendo clic en la aplicaci\u00f3n <em><strong>Firewall<\/strong> <strong>de Windows Defender<\/strong><\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7ac1465 elementor-widget elementor-widget-image\" data-id=\"7ac1465\" 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_1142.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1142\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MDUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQyLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"750\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1142.jpg\" class=\"attachment-full size-full wp-image-13605\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1142.jpg 800w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1142-300x281.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1142-768x720.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<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-95059c0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"95059c0\" 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-inner-column elementor-element elementor-element-a009561\" data-id=\"a009561\" 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-d5d6dc9 elementor-widget elementor-widget-image\" data-id=\"d5d6dc9\" 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_1143.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1143\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MDYsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQzLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"221\" height=\"430\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1143.jpg\" class=\"attachment-medium_large size-medium_large wp-image-13606\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1143.jpg 221w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1143-154x300.jpg 154w\" sizes=\"(max-width: 221px) 100vw, 221px\" \/>\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-inner-column elementor-element elementor-element-75804e9\" data-id=\"75804e9\" 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-ab82806 elementor-widget elementor-widget-text-editor\" data-id=\"ab82806\" 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>Configuraci\u00f3n avanzada<\/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>Reglas de entrada<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d3aa269 elementor-widget elementor-widget-image\" data-id=\"d3aa269\" 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_1144.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1144\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MDcsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQ0LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"179\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1144-1024x229.jpg\" class=\"attachment-large size-large wp-image-13607\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1144-1024x229.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1144-300x67.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1144-768x171.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1144.jpg 1044w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-e8830c0 elementor-widget elementor-widget-text-editor\" data-id=\"e8830c0\" 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>Nueva regla<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b2ba70a elementor-widget elementor-widget-image\" data-id=\"b2ba70a\" 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_1145.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1145\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MDgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQ1LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1110\" height=\"334\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1145.jpg\" class=\"attachment-full size-full wp-image-13608\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1145.jpg 1110w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1145-300x90.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1145-1024x308.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1145-768x231.jpg 768w\" sizes=\"(max-width: 1110px) 100vw, 1110px\" \/>\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-e5d7359 elementor-widget elementor-widget-text-editor\" data-id=\"e5d7359\" 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>Nueva regla<\/strong><\/em> y seguimos los siguientes pasos:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-89e7398 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89e7398\" 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-inner-column elementor-element elementor-element-71da8d0\" data-id=\"71da8d0\" 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-3457f2c elementor-widget elementor-widget-image\" data-id=\"3457f2c\" 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_1146.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1146\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MDksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQ2LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1146.jpg\" class=\"attachment-large size-large wp-image-13609\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1146.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1146-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-92cc6a2 elementor-widget elementor-widget-text-editor\" data-id=\"92cc6a2\" 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>(puerto)\u00a0<\/em><\/strong>y presionamos <em><strong>Siguiente<\/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-inner-column elementor-element elementor-element-5ec7e54\" data-id=\"5ec7e54\" 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-f228641 elementor-widget elementor-widget-image\" data-id=\"f228641\" 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_1147.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1147\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MTAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQ3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1147.jpg\" class=\"attachment-large size-large wp-image-13610\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1147.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1147-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-45de51e elementor-widget elementor-widget-text-editor\" data-id=\"45de51e\" 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>Puertos locales espec\u00edficos<\/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>Siguiente<\/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-inner-section elementor-element elementor-element-e46a6c4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e46a6c4\" 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-inner-column elementor-element elementor-element-dd9a7f4\" data-id=\"dd9a7f4\" 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-94b3259 elementor-widget elementor-widget-image\" data-id=\"94b3259\" 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_1148.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1148\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MTEsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQ4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1148.jpg\" class=\"attachment-large size-large wp-image-13611\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1148.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1148-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-1245c09 elementor-widget elementor-widget-text-editor\" data-id=\"1245c09\" 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>Permitir la conexi\u00f3n<\/strong><\/em>. Damos clic en <em><strong>Siguiente.<\/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-inner-column elementor-element elementor-element-8d6af8e\" data-id=\"8d6af8e\" 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-788262e elementor-widget elementor-widget-image\" data-id=\"788262e\" 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_1149.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1149\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MTIsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTQ5LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1149.jpg\" class=\"attachment-large size-large wp-image-13612\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1149.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1149-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-ed1a6d6 elementor-widget elementor-widget-text-editor\" data-id=\"ed1a6d6\" 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>Siguiente.<\/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-inner-section elementor-element elementor-element-77ba510 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"77ba510\" 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-inner-column elementor-element elementor-element-3d310fd\" data-id=\"3d310fd\" 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-8bea879 elementor-widget elementor-widget-image\" data-id=\"8bea879\" 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_1150.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1150\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MTMsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTUwLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"714\" height=\"581\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1150.jpg\" class=\"attachment-large size-large wp-image-13613\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1150.jpg 714w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1150-300x244.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/>\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-inner-column elementor-element elementor-element-9541472\" data-id=\"9541472\" 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-7004e57 elementor-widget elementor-widget-text-editor\" data-id=\"7004e57\" 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>Finalizar.<\/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<div class=\"elementor-element elementor-element-653d41d elementor-widget elementor-widget-heading\" data-id=\"653d41d\" 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-3e7744f elementor-widget elementor-widget-text-editor\" data-id=\"3e7744f\" 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 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>servicios<\/em><\/strong> y haciendo clic en la aplicaci\u00f3n <em><strong>Servicios<\/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-a99dd9c elementor-widget elementor-widget-image\" data-id=\"a99dd9c\" 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_1131.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1131\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM1MzEsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTMxLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"574\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1131-1024x735.jpg\" class=\"attachment-large size-large wp-image-13531\" alt=\"PostgreSQL en Windows 11\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1131-1024x735.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1131-300x215.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1131-768x551.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1131.jpg 1133w\" 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-a686fe6 elementor-widget elementor-widget-text-editor\" data-id=\"a686fe6\" 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 servicios, 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-e832d9b elementor-widget elementor-widget-image\" data-id=\"e832d9b\" 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_1132.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1132\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM1MzUsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTMyLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"398\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1132-1024x509.jpg\" class=\"attachment-large size-large wp-image-13535\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1132-1024x509.jpg 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1132-300x149.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1132-768x381.jpg 768w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1132.jpg 1194w\" 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<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-b420b19 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b420b19\" 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-inner-column elementor-element elementor-element-9ea50c8\" data-id=\"9ea50c8\" 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-14b2409 elementor-widget elementor-widget-image\" data-id=\"14b2409\" 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_1151.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1151\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM2MjAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTUxLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"417\" height=\"190\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1151.jpg\" class=\"attachment-large size-large wp-image-13620\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1151.jpg 417w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1151-300x137.jpg 300w\" sizes=\"(max-width: 417px) 100vw, 417px\" \/>\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-inner-column elementor-element elementor-element-6cad63e\" data-id=\"6cad63e\" 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-b5f2924 elementor-widget elementor-widget-text-editor\" data-id=\"b5f2924\" 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 servicio se ha reiniciado, ya estamos listos para realizar la prueba de que nuestra configuraci\u00f3n fue hecha correctamente.\u00a0<\/p><p>Podemos ir a la secci\u00f3n <a href=\"#probar-acceso-remoto\"><strong>Probar el Acceso Remoto<\/strong><\/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\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-388123c elementor-grid-1 elementor-grid-tablet-2 elementor-grid-mobile-1 elementor-widget elementor-widget-loop-grid\" data-id=\"388123c\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;template_id&quot;:&quot;30519&quot;,&quot;columns&quot;:1,&quot;_skin&quot;:&quot;post&quot;,&quot;columns_tablet&quot;:&quot;2&quot;,&quot;columns_mobile&quot;:&quot;1&quot;,&quot;edit_handle_selector&quot;:&quot;[data-elementor-type=\\&quot;loop-item\\&quot;]&quot;,&quot;row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"loop-grid.post\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-loop-container elementor-grid\" role=\"list\">\n\t\t\t\t<div data-elementor-type=\"loop-item\" data-elementor-id=\"30519\" class=\"elementor elementor-30519 e-loop-item e-loop-item-38455 post-38455 post type-post status-publish format-standard has-post-thumbnail hentry category-linux category-seguridad\" data-elementor-post-type=\"elementor_library\" data-custom-edit-handle=\"1\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-98493d2 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"98493d2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-custom\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-ccee508\" data-id=\"ccee508\" 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-80149f2 elementor-widget elementor-widget-image\" data-id=\"80149f2\" 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\/regresshion-en-openssh-permite-acceso-root-en-linux\/\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1120\" height=\"600\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/07\/Linux_fail.png\" class=\"attachment-full size-full wp-image-38457\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/07\/Linux_fail.png 1120w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/07\/Linux_fail-300x161.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/07\/Linux_fail-1024x549.png 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2024\/07\/Linux_fail-768x411.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" \/>\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-2109b1e\" data-id=\"2109b1e\" 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-26a68f7 elementor-align-left elementor-widget__width-inherit elementor-widget elementor-widget-post-info\" data-id=\"26a68f7\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"categorias-post\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-dfd774d elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-custom\">\n\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/category\/informatica\/sistemas-operativos\/linux\/\" rel=\"tag\">Linux<\/a> <a href=\"https:\/\/quike.it\/es\/category\/informatica\/seguridad\/\" rel=\"tag\">Seguridad<\/a>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ed9e84 elementor-widget elementor-widget-heading\" data-id=\"1ed9e84\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"top-post\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<div class=\"elementor-heading-title elementor-size-default\"><a href=\"https:\/\/quike.it\/es\/regresshion-en-openssh-permite-acceso-root-en-linux\/\" target=\"_blank\">RegreSSHion en OpenSSH permite acceso root en Linux<\/a><\/div>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-714486b elementor-icon-list--layout-inline elementor-align-start elementor-hidden-tablet elementor-hidden-mobile elementor-widget__width-inherit elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"714486b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/regresshion-en-openssh-permite-acceso-root-en-linux\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-book-reader\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M352 96c0-53.02-42.98-96-96-96s-96 42.98-96 96 42.98 96 96 96 96-42.98 96-96zM233.59 241.1c-59.33-36.32-155.43-46.3-203.79-49.05C13.55 191.13 0 203.51 0 219.14v222.8c0 14.33 11.59 26.28 26.49 27.05 43.66 2.29 131.99 10.68 193.04 41.43 9.37 4.72 20.48-1.71 20.48-11.87V252.56c-.01-4.67-2.32-8.95-6.42-11.46zm248.61-49.05c-48.35 2.74-144.46 12.73-203.78 49.05-4.1 2.51-6.41 6.96-6.41 11.63v245.79c0 10.19 11.14 16.63 20.54 11.9 61.04-30.72 149.32-39.11 192.97-41.4 14.9-.78 26.49-12.73 26.49-27.06V219.14c-.01-15.63-13.56-28.01-29.81-27.09z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">156 lecturas<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-comments\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 192c0-88.4-93.1-160-208-160S0 103.6 0 192c0 34.3 14.1 65.9 38 92-13.4 30.2-35.5 54.2-35.8 54.5-2.2 2.3-2.8 5.7-1.5 8.7S4.8 352 8 352c36.6 0 66.9-12.3 88.7-25 32.2 15.7 70.3 25 111.3 25 114.9 0 208-71.6 208-160zm122 220c23.9-26 38-57.7 38-92 0-66.9-53.5-124.2-129.3-148.1.9 6.6 1.3 13.3 1.3 20.1 0 105.9-107.7 192-240 192-10.8 0-21.3-.8-31.7-1.9C207.8 439.6 281.8 480 368 480c41 0 79.1-9.2 111.3-25 21.8 12.7 52.1 25 88.7 25 3.2 0 6.1-1.9 7.3-4.8 1.3-2.9.7-6.3-1.5-8.7-.3-.3-22.4-24.2-35.8-54.5z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/quike.it\/es\/regresshion-en-openssh-permite-acceso-root-en-linux\/#respond\">sin comentarios<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a32de7 elementor-icon-list--layout-inline elementor-align-start elementor-widget__width-inherit elementor-hidden-desktop elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"0a32de7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/regresshion-en-openssh-permite-acceso-root-en-linux\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-book-reader\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M352 96c0-53.02-42.98-96-96-96s-96 42.98-96 96 42.98 96 96 96 96-42.98 96-96zM233.59 241.1c-59.33-36.32-155.43-46.3-203.79-49.05C13.55 191.13 0 203.51 0 219.14v222.8c0 14.33 11.59 26.28 26.49 27.05 43.66 2.29 131.99 10.68 193.04 41.43 9.37 4.72 20.48-1.71 20.48-11.87V252.56c-.01-4.67-2.32-8.95-6.42-11.46zm248.61-49.05c-48.35 2.74-144.46 12.73-203.78 49.05-4.1 2.51-6.41 6.96-6.41 11.63v245.79c0 10.19 11.14 16.63 20.54 11.9 61.04-30.72 149.32-39.11 192.97-41.4 14.9-.78 26.49-12.73 26.49-27.06V219.14c-.01-15.63-13.56-28.01-29.81-27.09z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">156 lecturas<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-comments\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 192c0-88.4-93.1-160-208-160S0 103.6 0 192c0 34.3 14.1 65.9 38 92-13.4 30.2-35.5 54.2-35.8 54.5-2.2 2.3-2.8 5.7-1.5 8.7S4.8 352 8 352c36.6 0 66.9-12.3 88.7-25 32.2 15.7 70.3 25 111.3 25 114.9 0 208-71.6 208-160zm122 220c23.9-26 38-57.7 38-92 0-66.9-53.5-124.2-129.3-148.1.9 6.6 1.3 13.3 1.3 20.1 0 105.9-107.7 192-240 192-10.8 0-21.3-.8-31.7-1.9C207.8 439.6 281.8 480 368 480c41 0 79.1-9.2 111.3-25 21.8 12.7 52.1 25 88.7 25 3.2 0 6.1-1.9 7.3-4.8 1.3-2.9.7-6.3-1.5-8.7-.3-.3-22.4-24.2-35.8-54.5z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/quike.it\/es\/regresshion-en-openssh-permite-acceso-root-en-linux\/#respond\">0<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\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<\/div>\n\t\t\t\t<\/div>\n\t\t\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3aee468 elementor-widget elementor-widget-heading\" data-id=\"3aee468\" 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\">Configurar Acceso Remoto PostgreSQL en Linux<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-13f7ee1 elementor-widget elementor-widget-text-editor\" data-id=\"13f7ee1\" 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 has <a href=\"https:\/\/quike.it\/es\/como-instalar-postgresql-en-linux\/\" target=\"_blank\" rel=\"noopener\"><strong>instalado PostgreSQL en Linux<\/strong><\/a>, sea en modo gr\u00e1fico que en modo texto, al igual que en las instalaciones de <em><strong>Windows,<\/strong><\/em> debemos acceder a los dos archivos de configuraci\u00f3n que sirven para <em><strong>configurar acceso<\/strong><\/em><strong> remoto<\/strong><em><strong> Postgresql<\/strong><\/em><\/p><p>En nuestro caso utilizaremos <a href=\"https:\/\/quike.it\/es\/como-instalar-ubuntu-server-20-04-2\/\" target=\"_blank\" rel=\"noopener\"><em><strong>Linux UBUNTU Server 20.04<\/strong><\/em><\/a> en <i>modo texto.<\/i><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5a48b9 elementor-widget elementor-widget-heading\" data-id=\"f5a48b9\" 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 del archivo pg_hba.conf<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c15249 elementor-widget elementor-widget-text-editor\" data-id=\"8c15249\" 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>Utilizamos un editor de texto para abrir el archivo <em><strong>pg_hba.conf.<\/strong><\/em>\u00a0<\/p><p>En el caso de nuestro ejemplo utilizaremos el editor <em><strong>nano.<\/strong><\/em><\/p><p>Escribimos el comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2208a99 elementor-widget elementor-widget-code-highlight\" data-id=\"2208a99\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo nano \/etc\/postgresql\/12\/main\/pg_hba.conf<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-715fb5d elementor-widget elementor-widget-image\" data-id=\"715fb5d\" 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_1173.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1173\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM3MDgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTczLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"824\" height=\"140\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1173.jpg\" class=\"attachment-full size-full wp-image-13708\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1173.jpg 824w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1173-300x51.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1173-768x130.jpg 768w\" sizes=\"(max-width: 824px) 100vw, 824px\" \/>\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-3c01320 elementor-widget elementor-widget-text-editor\" data-id=\"3c01320\" 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>La ruta en donde se encuentran los archivos de configuraci\u00f3n depende de qu\u00e9 versi\u00f3n de <em><strong>PostgreSQL<\/strong><\/em> hemos instalado. En el caso del ejemplo tenemos instalado la <em><strong>versi\u00f3n 12<\/strong><\/em>.<\/p><p>Una vez que se ha abierto el archivo, nos deslizamos con las flechas del teclado hasta la secci\u00f3n: Una vez abierto, deslizamos hasta encontrar la secci\u00f3n: <strong><em># IPv4 local connections.<\/em><\/strong><\/p><p>En esa secci\u00f3n, agregaremos una nueva l\u00ednea con el siguiente contenido:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-95517dc elementor-widget elementor-widget-code-highlight\" data-id=\"95517dc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-scala \">\n\t\t\t\t<code readonly=\"true\" class=\"language-scala\">\n\t\t\t\t\t<xmp>host all all 0.0.0.0\/0 md5<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e7bdbf elementor-widget elementor-widget-image\" data-id=\"9e7bdbf\" 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_1174.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1174\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM3MTAsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTc0LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"821\" height=\"699\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1174.jpg\" class=\"attachment-full size-full wp-image-13710\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1174.jpg 821w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1174-300x255.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1174-768x654.jpg 768w\" sizes=\"(max-width: 821px) 100vw, 821px\" \/>\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-8ec0234 elementor-widget elementor-widget-text-editor\" data-id=\"8ec0234\" 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>Seg\u00fan sea la versi\u00f3n de <em><strong>PostgreSQL<\/strong><\/em> con la que estemos trabajando, es posible que como <em><strong>METHOD<\/strong><\/em> encontremos en lugar de <em><strong>md5,<\/strong><\/em> el valor <em><strong>scram-sha-256<\/strong><\/em><\/p><p>En ese caso colocamos la l\u00ednea as\u00ed:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-704cd30 elementor-widget elementor-widget-code-highlight\" data-id=\"704cd30\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-scala \">\n\t\t\t\t<code readonly=\"true\" class=\"language-scala\">\n\t\t\t\t\t<xmp>host all all 0.0.0.0\/0 scram-sha-256<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8421391 elementor-alert-warning elementor-widget elementor-widget-alert\" data-id=\"8421391\" 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-abf73b9 elementor-widget elementor-widget-heading\" data-id=\"abf73b9\" 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-72048e7 elementor-widget elementor-widget-text-editor\" data-id=\"72048e7\" 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 es el turno del segundo archivo de configuraci\u00f3n, <em><strong>postgresql.conf.<\/strong><\/em><\/p><p>Ejecutamos el comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-69a1f2e elementor-widget elementor-widget-code-highlight\" data-id=\"69a1f2e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo nano \/etc\/postgresql\/12\/main\/postgresql.conf<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-281ee62 elementor-widget elementor-widget-image\" data-id=\"281ee62\" 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_1175.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1175\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM3MTQsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTc1LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"101\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1175.jpg\" class=\"attachment-full size-full wp-image-13714\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1175.jpg 830w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1175-300x37.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1175-768x93.jpg 768w\" sizes=\"(max-width: 830px) 100vw, 830px\" \/>\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-2ce5774 elementor-widget elementor-widget-text-editor\" data-id=\"2ce5774\" 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 abierto el archivo, deslizamos el contenido del archivo, hasta que encontremos la secci\u00f3n:<\/p><p><strong><em># &#8211; Connection Settings &#8211;<\/em><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a48f4f5 elementor-widget elementor-widget-image\" data-id=\"a48f4f5\" 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 loading=\"lazy\" decoding=\"async\" width=\"804\" height=\"604\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1176.jpg\" class=\"attachment-full size-full wp-image-13715\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1176.jpg 804w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1176-300x225.jpg 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1176-768x577.jpg 768w\" sizes=\"(max-width: 804px) 100vw, 804px\" \/>\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-6bb0783 elementor-widget elementor-widget-text-editor\" data-id=\"6bb0783\" 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 <b><i>base de datos<\/i><\/b> va a aceptar conexiones en entrada desde cualquier <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> que se la solicite.<\/p><p>Si queremos restringir el acceso remoto a una <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> espec\u00edfica, es suficiente escribir dentro de las comillas simples la <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> que vamos a permitir.<\/p><p>Si fuese el caso que hay mas <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcciones IP<\/strong><\/em><\/a> individuales, se las debe escribir separadas por una coma (,).<\/p><p>Una vez realizados los cambios, <em><strong>hay que registrar las modificaciones<\/strong><\/em>, si se han hecho, <em><strong>del archivo<\/strong><\/em>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a1203b elementor-widget elementor-widget-heading\" data-id=\"6a1203b\" 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 Firewall Linux<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-03a0220 elementor-widget elementor-widget-text-editor\" data-id=\"03a0220\" 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>Antes de proceder a abrir el puerto <em><strong>5432<\/strong><\/em> (<em>o el que hallamos especificado en fase de instalaci\u00f3n<\/em>), primero verificamos si en nuestro servidor est\u00e1 encendido el <em><strong>firewall.<\/strong><\/em><\/p><p>Para esto ejecutamos el siguiente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45b0e28 elementor-widget elementor-widget-code-highlight\" data-id=\"45b0e28\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>sudo ufw status verbose<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d20f6bc elementor-widget elementor-widget-text-editor\" data-id=\"d20f6bc\" 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>La ejecuci\u00f3n del comando anterior, puede darnos uno de los siguientes resultados:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-d502389 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d502389\" 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-inner-column elementor-element elementor-element-ab49446\" data-id=\"ab49446\" 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-968ec43 elementor-widget elementor-widget-image\" data-id=\"968ec43\" 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_1177.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1177\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM3MTYsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTc3LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"223\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1177.jpg\" class=\"attachment-large size-large wp-image-13716\" alt=\"configurar acceso remoto Postgresql\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1177.jpg 468w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1177-300x143.jpg 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/>\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-3020bd5 elementor-widget elementor-widget-text-editor\" data-id=\"3020bd5\" 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 el <em><strong>firewall<\/strong><\/em> est\u00e1 inactivo, podemos dirigirnos directamente al <strong><a href=\"#linux-reiniciar-servicio\"><em>reinicio del servicio.<\/em><\/a><\/strong><\/p><p>Si queremos en cambio que el firewall se active, ejecutamos el comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba50da3 elementor-widget elementor-widget-code-highlight\" data-id=\"ba50da3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>sudo ufw enable<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-82ac173 elementor-alert-danger elementor-widget elementor-widget-alert\" data-id=\"82ac173\" 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\">Advertencia!<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"elementor-alert-description\">Tenga en cuenta que al habilitar su firewall puede desconectarse si est\u00e1 usando SSH para conectarse de forma remota a su servidor Ubuntu.<\/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\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-ac0acc0\" data-id=\"ac0acc0\" 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-e9c767c elementor-widget elementor-widget-image\" data-id=\"e9c767c\" 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_1178.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1178\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM3MTcsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTc4LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"482\" height=\"238\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1178.jpg\" class=\"attachment-large size-large wp-image-13717\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1178.jpg 482w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1178-300x148.jpg 300w\" sizes=\"(max-width: 482px) 100vw, 482px\" \/>\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-482affd elementor-widget elementor-widget-text-editor\" data-id=\"482affd\" 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 el <em><strong>firewall de Linux<\/strong><\/em> est\u00e1 activo y no se muestra en el elenco de puertos el <em><strong>5432,<\/strong><\/em> entonces procedemos a incluirlo ejecutando el siguiente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c8c2c1b elementor-widget elementor-widget-code-highlight\" data-id=\"c8c2c1b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript \">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>sudo ufw allow 5432\/tcp<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\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-inner-section elementor-element elementor-element-1afd7c1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1afd7c1\" 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-inner-column elementor-element elementor-element-1dffd43\" data-id=\"1dffd43\" 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-88f4b95 elementor-widget elementor-widget-image\" data-id=\"88f4b95\" 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_1179.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1179\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM3MTgsInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTc5LmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"480\" height=\"237\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1179.jpg\" class=\"attachment-large size-large wp-image-13718\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1179.jpg 480w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1179-300x148.jpg 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/>\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-0609135 elementor-widget elementor-widget-text-editor\" data-id=\"0609135\" 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>Obtendremos un mensaje que confirma el haber agregado el <em>puerto<\/em>\u00a0<\/p><p>y ahora podemos realizar de nuevo la consultaci\u00f3n de la situaci\u00f3n del <em><strong>firewall.<\/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-inner-column elementor-element elementor-element-5dd5986\" data-id=\"5dd5986\" 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-aee4b74 elementor-widget elementor-widget-image\" data-id=\"aee4b74\" 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_1180.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"blog_1180\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTM3MTksInVybCI6Imh0dHBzOlwvXC9xdWlrZS5pdFwvZXNcL3dwLWNvbnRlbnRcL3VwbG9hZHNcL3NpdGVzXC8zXC8yMDIyXC8wN1wvYmxvZ18xMTgwLmpwZyJ9\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"497\" height=\"240\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1180.jpg\" class=\"attachment-large size-large wp-image-13719\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1180.jpg 497w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/blog_1180-300x145.jpg 300w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/>\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-98ab228 elementor-widget elementor-widget-text-editor\" data-id=\"98ab228\" 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>Como vemos en la <a href=\"https:\/\/quike.it\/es\/como-hacer-la-captura-de-pantalla-en-windows\/\" target=\"_blank\" rel=\"noopener\"><strong>captura de pantalla<\/strong><\/a>, el <em><strong>servidor de datos<\/strong><\/em> est\u00e1 aceptando conexiones a trav\u00e9s del puerto <em><strong>5432<\/strong><\/em> desde cualquier parte del mundo.<\/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 class=\"elementor-element elementor-element-c234fb5 elementor-widget elementor-widget-heading\" data-id=\"c234fb5\" 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\">Reiniciar el Servicio PostgreSQL - LINUX<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a2a44a elementor-widget elementor-widget-text-editor\" data-id=\"9a2a44a\" 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 ultimo, debemos reiniciar el servicio de <em><strong>PostgreSQL<\/strong><\/em> para que los cambios que hemos aportado al <em><strong>servidor de datos<\/strong><\/em> inicien a funcionar.<\/p><p>Ejecutamos entonces el comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-496c975 elementor-widget elementor-widget-code-highlight\" data-id=\"496c975\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo systemctl restart postgresql.service<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa7f616 elementor-grid-1 elementor-grid-tablet-2 elementor-grid-mobile-1 elementor-widget elementor-widget-loop-grid\" data-id=\"aa7f616\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;template_id&quot;:&quot;30519&quot;,&quot;columns&quot;:1,&quot;_skin&quot;:&quot;post&quot;,&quot;columns_tablet&quot;:&quot;2&quot;,&quot;columns_mobile&quot;:&quot;1&quot;,&quot;edit_handle_selector&quot;:&quot;[data-elementor-type=\\&quot;loop-item\\&quot;]&quot;,&quot;row_gap&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;row_gap_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;row_gap_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"loop-grid.post\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-loop-container elementor-grid\" role=\"list\">\n\t\t\t\t<div data-elementor-type=\"loop-item\" data-elementor-id=\"30519\" class=\"elementor elementor-30519 e-loop-item e-loop-item-20076 post-20076 post type-post status-publish format-standard has-post-thumbnail hentry category-linux category-ubuntu\" data-elementor-post-type=\"elementor_library\" data-custom-edit-handle=\"1\">\n\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-98493d2 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"98493d2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-custom\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-ccee508\" data-id=\"ccee508\" 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-80149f2 elementor-widget elementor-widget-image\" data-id=\"80149f2\" 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\/como-instalar-samba-en-linux-ubuntu-22-04-lts-jammy\/\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1120\" height=\"600\" src=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/04\/ubuntu_post2.png\" class=\"attachment-full size-full wp-image-38916\" alt=\"\" srcset=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/04\/ubuntu_post2.png 1120w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/04\/ubuntu_post2-300x161.png 300w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/04\/ubuntu_post2-1024x549.png 1024w, https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2023\/04\/ubuntu_post2-768x411.png 768w\" sizes=\"(max-width: 1120px) 100vw, 1120px\" \/>\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-2109b1e\" data-id=\"2109b1e\" 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-26a68f7 elementor-align-left elementor-widget__width-inherit elementor-widget elementor-widget-post-info\" data-id=\"26a68f7\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"categorias-post\" data-widget_type=\"post-info.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-dfd774d elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-custom\">\n\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/category\/informatica\/sistemas-operativos\/linux\/\" rel=\"tag\">Linux<\/a> <a href=\"https:\/\/quike.it\/es\/category\/informatica\/sistemas-operativos\/linux\/ubuntu\/\" rel=\"tag\">Ubuntu<\/a>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ed9e84 elementor-widget elementor-widget-heading\" data-id=\"1ed9e84\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"top-post\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<div class=\"elementor-heading-title elementor-size-default\"><a href=\"https:\/\/quike.it\/es\/como-instalar-samba-en-linux-ubuntu-22-04-lts-jammy\/\" target=\"_blank\">C\u00f3mo instalar SAMBA en Linux Ubuntu 22.04 LTS Jammy<\/a><\/div>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-714486b elementor-icon-list--layout-inline elementor-align-start elementor-hidden-tablet elementor-hidden-mobile elementor-widget__width-inherit elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"714486b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/como-instalar-samba-en-linux-ubuntu-22-04-lts-jammy\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-book-reader\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M352 96c0-53.02-42.98-96-96-96s-96 42.98-96 96 42.98 96 96 96 96-42.98 96-96zM233.59 241.1c-59.33-36.32-155.43-46.3-203.79-49.05C13.55 191.13 0 203.51 0 219.14v222.8c0 14.33 11.59 26.28 26.49 27.05 43.66 2.29 131.99 10.68 193.04 41.43 9.37 4.72 20.48-1.71 20.48-11.87V252.56c-.01-4.67-2.32-8.95-6.42-11.46zm248.61-49.05c-48.35 2.74-144.46 12.73-203.78 49.05-4.1 2.51-6.41 6.96-6.41 11.63v245.79c0 10.19 11.14 16.63 20.54 11.9 61.04-30.72 149.32-39.11 192.97-41.4 14.9-.78 26.49-12.73 26.49-27.06V219.14c-.01-15.63-13.56-28.01-29.81-27.09z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">9.703 lecturas<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-comments\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 192c0-88.4-93.1-160-208-160S0 103.6 0 192c0 34.3 14.1 65.9 38 92-13.4 30.2-35.5 54.2-35.8 54.5-2.2 2.3-2.8 5.7-1.5 8.7S4.8 352 8 352c36.6 0 66.9-12.3 88.7-25 32.2 15.7 70.3 25 111.3 25 114.9 0 208-71.6 208-160zm122 220c23.9-26 38-57.7 38-92 0-66.9-53.5-124.2-129.3-148.1.9 6.6 1.3 13.3 1.3 20.1 0 105.9-107.7 192-240 192-10.8 0-21.3-.8-31.7-1.9C207.8 439.6 281.8 480 368 480c41 0 79.1-9.2 111.3-25 21.8 12.7 52.1 25 88.7 25 3.2 0 6.1-1.9 7.3-4.8 1.3-2.9.7-6.3-1.5-8.7-.3-.3-22.4-24.2-35.8-54.5z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/quike.it\/es\/como-instalar-samba-en-linux-ubuntu-22-04-lts-jammy\/#comments\">11 comentarios<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a32de7 elementor-icon-list--layout-inline elementor-align-start elementor-widget__width-inherit elementor-hidden-desktop elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"0a32de7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/quike.it\/es\/como-instalar-samba-en-linux-ubuntu-22-04-lts-jammy\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-book-reader\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M352 96c0-53.02-42.98-96-96-96s-96 42.98-96 96 42.98 96 96 96 96-42.98 96-96zM233.59 241.1c-59.33-36.32-155.43-46.3-203.79-49.05C13.55 191.13 0 203.51 0 219.14v222.8c0 14.33 11.59 26.28 26.49 27.05 43.66 2.29 131.99 10.68 193.04 41.43 9.37 4.72 20.48-1.71 20.48-11.87V252.56c-.01-4.67-2.32-8.95-6.42-11.46zm248.61-49.05c-48.35 2.74-144.46 12.73-203.78 49.05-4.1 2.51-6.41 6.96-6.41 11.63v245.79c0 10.19 11.14 16.63 20.54 11.9 61.04-30.72 149.32-39.11 192.97-41.4 14.9-.78 26.49-12.73 26.49-27.06V219.14c-.01-15.63-13.56-28.01-29.81-27.09z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">9.703 lecturas<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-comments\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M416 192c0-88.4-93.1-160-208-160S0 103.6 0 192c0 34.3 14.1 65.9 38 92-13.4 30.2-35.5 54.2-35.8 54.5-2.2 2.3-2.8 5.7-1.5 8.7S4.8 352 8 352c36.6 0 66.9-12.3 88.7-25 32.2 15.7 70.3 25 111.3 25 114.9 0 208-71.6 208-160zm122 220c23.9-26 38-57.7 38-92 0-66.9-53.5-124.2-129.3-148.1.9 6.6 1.3 13.3 1.3 20.1 0 105.9-107.7 192-240 192-10.8 0-21.3-.8-31.7-1.9C207.8 439.6 281.8 480 368 480c41 0 79.1-9.2 111.3-25 21.8 12.7 52.1 25 88.7 25 3.2 0 6.1-1.9 7.3-4.8 1.3-2.9.7-6.3-1.5-8.7-.3-.3-22.4-24.2-35.8-54.5z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/quike.it\/es\/como-instalar-samba-en-linux-ubuntu-22-04-lts-jammy\/#comments\">11 <\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\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<\/div>\n\t\t\t\t<\/div>\n\t\t\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dad5d75 elementor-widget elementor-widget-heading\" data-id=\"dad5d75\" 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\">Probar el Acceso Remoto<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-daa254a elementor-widget elementor-widget-text-editor\" data-id=\"daa254a\" 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 <strong>Configurar el Acceso Remoto PostgreSQL<\/strong>, 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:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" target=\"_blank\" rel=\"noopener\"><em><strong>direcci\u00f3n IP<\/strong><\/em><\/a> del computador donde se ha instalado la <strong>base de datos<\/strong>. Si fuere el caso debemos tener a la mano la <a href=\"https:\/\/quike.it\/es\/que-es-un-ip-estatico-y-a-que-sirve\/\" target=\"_blank\" rel=\"noopener\"><strong>direcci\u00f3n IP p\u00fablica<\/strong><\/a>.<\/p><p>En el caso de nuestro ejemplo la <a href=\"https:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" 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-e727b45 elementor-widget elementor-widget-heading\" data-id=\"e727b45\" 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-46eb5ea elementor-widget elementor-widget-text-editor\" data-id=\"46eb5ea\" 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<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-52500e7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"52500e7\" 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-inner-column elementor-element elementor-element-3abe3df\" data-id=\"3abe3df\" 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-9d3d030 elementor-widget elementor-widget-image\" data-id=\"9d3d030\" 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-inner-column elementor-element elementor-element-5d09d5d\" data-id=\"5d09d5d\" 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-4cdf030 elementor-widget elementor-widget-text-editor\" data-id=\"4cdf030\" 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>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aa80f24 elementor-widget elementor-widget-code-highlight\" data-id=\"aa80f24\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>ping 192.168.113.129<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8baa081 elementor-widget elementor-widget-text-editor\" data-id=\"8baa081\" 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:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" 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-inner-section elementor-element elementor-element-006c494 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"006c494\" 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-inner-column elementor-element elementor-element-cce5a7e\" data-id=\"cce5a7e\" 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-84220a0 elementor-widget elementor-widget-text-editor\" data-id=\"84220a0\" 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:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" 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. Aseg\u00farate si no se trata de un servidor con <a href=\"https:\/\/es.wikipedia.org\/wiki\/Sistema_operativo_de_red\" target=\"_blank\" rel=\"noopener\"><strong>sistema operativo de servidor<\/strong><\/a>, de que se ha activado la <strong><em>detecci\u00f3n de redes<\/em><\/strong> (<em>en ambos dispositivos<\/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-inner-column elementor-element elementor-element-9bc11d0\" data-id=\"9bc11d0\" 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-3fe7cda elementor-widget elementor-widget-image\" data-id=\"3fe7cda\" 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<div class=\"elementor-element elementor-element-34f0197 elementor-widget elementor-widget-heading\" data-id=\"34f0197\" 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-c71b24b elementor-widget elementor-widget-text-editor\" data-id=\"c71b24b\" 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<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-fea1995 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fea1995\" 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-inner-column elementor-element elementor-element-91c39a4\" data-id=\"91c39a4\" 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-709f215 elementor-widget elementor-widget-image\" data-id=\"709f215\" 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-0cefb4b elementor-widget elementor-widget-text-editor\" data-id=\"0cefb4b\" 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-inner-column elementor-element elementor-element-09f8f47\" data-id=\"09f8f47\" 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-e57e4be elementor-widget elementor-widget-image\" data-id=\"e57e4be\" 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-bffb052 elementor-widget elementor-widget-text-editor\" data-id=\"bffb052\" 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-inner-section elementor-element elementor-element-ec2a420 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ec2a420\" 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-inner-column elementor-element elementor-element-a12a909\" data-id=\"a12a909\" 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-9eacfa2 elementor-widget elementor-widget-image\" data-id=\"9eacfa2\" 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-b5f0305 elementor-widget elementor-widget-text-editor\" data-id=\"b5f0305\" 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:\/\/quike.it\/es\/como-se-asigna-la-ip-publica-cuando-nos-conectamos-a-internet\/\" 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-inner-column elementor-element elementor-element-31552ba\" data-id=\"31552ba\" 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-6a1a123 elementor-widget elementor-widget-image\" data-id=\"6a1a123\" 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<div class=\"elementor-element elementor-element-c942411 elementor-widget elementor-widget-text-editor\" data-id=\"c942411\" 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 <em><strong>Configurar Acceso Remoto PostgreSQL<\/strong><\/em> 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>Una vez que hemos instalado PostgreSQL, sea en ambiente Linux o en ambiente Windows (Windows 10 o Windows 11), es posible que surja la necesidad de permitir el acceso remoto a la base de datos. En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":39007,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[11,26,12,28],"tags":[],"class_list":["post-13563","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos","category-linux","category-postgresql","category-windows"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>C\u00f3mo Configurar Acceso Remoto PostgreSQL - Enrique V\u00e1squez -<\/title>\n<meta name=\"description\" content=\"En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los que....\" \/>\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-configurar-acceso-remoto-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo Configurar Acceso Remoto PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los que nos podr\u00edamos encontrar.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/\" \/>\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-19T05:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-24T13:21:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgres_post.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1120\" \/>\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 Configurar Acceso Remoto PostgreSQL\" \/>\n<meta name=\"twitter:description\" content=\"En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los que nos podr\u00edamos encontrar.\" \/>\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=\"23 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/\"},\"author\":{\"name\":\"Enrique V\u00e1squez B.\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#\\\/schema\\\/person\\\/e53c62e8ab2e3f878e77d3a617483cc8\"},\"headline\":\"C\u00f3mo Configurar Acceso Remoto PostgreSQL\",\"datePublished\":\"2022-07-19T05:37:00+00:00\",\"dateModified\":\"2024-07-24T13:21:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/\"},\"wordCount\":2848,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#\\\/schema\\\/person\\\/e53c62e8ab2e3f878e77d3a617483cc8\"},\"image\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgres_post.png\",\"articleSection\":[\"Bases de Datos\",\"Linux\",\"PostgreSQL\",\"Windows\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/#respond\"]}]},{\"@type\":[\"WebPage\",\"ItemPage\"],\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/\",\"url\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/\",\"name\":\"C\u00f3mo Configurar Acceso Remoto PostgreSQL - Enrique V\u00e1squez -\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgres_post.png\",\"datePublished\":\"2022-07-19T05:37:00+00:00\",\"dateModified\":\"2024-07-24T13:21:41+00:00\",\"description\":\"En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los que....\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgres_post.png\",\"contentUrl\":\"https:\\\/\\\/quike.it\\\/es\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2022\\\/07\\\/Postgres_post.png\",\"width\":1120,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quike.it\\\/es\\\/como-configurar-acceso-remoto-postgresql\\\/#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 Configurar Acceso Remoto PostgreSQL\"}]},{\"@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 Configurar Acceso Remoto PostgreSQL - Enrique V\u00e1squez -","description":"En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los que....","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-configurar-acceso-remoto-postgresql\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00f3mo Configurar Acceso Remoto PostgreSQL","og_description":"En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los que nos podr\u00edamos encontrar.","og_url":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/","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-19T05:37:00+00:00","article_modified_time":"2024-07-24T13:21:41+00:00","og_image":[{"width":1120,"height":600,"url":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgres_post.png","type":"image\/png"}],"author":"Enrique V\u00e1squez B.","twitter_card":"summary_large_image","twitter_title":"C\u00f3mo Configurar Acceso Remoto PostgreSQL","twitter_description":"En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los que nos podr\u00edamos encontrar.","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":"23 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/#article","isPartOf":{"@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/"},"author":{"name":"Enrique V\u00e1squez B.","@id":"https:\/\/quike.it\/es\/#\/schema\/person\/e53c62e8ab2e3f878e77d3a617483cc8"},"headline":"C\u00f3mo Configurar Acceso Remoto PostgreSQL","datePublished":"2022-07-19T05:37:00+00:00","dateModified":"2024-07-24T13:21:41+00:00","mainEntityOfPage":{"@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/"},"wordCount":2848,"commentCount":0,"publisher":{"@id":"https:\/\/quike.it\/es\/#\/schema\/person\/e53c62e8ab2e3f878e77d3a617483cc8"},"image":{"@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgres_post.png","articleSection":["Bases de Datos","Linux","PostgreSQL","Windows"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/#respond"]}]},{"@type":["WebPage","ItemPage"],"@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/","url":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/","name":"C\u00f3mo Configurar Acceso Remoto PostgreSQL - Enrique V\u00e1squez -","isPartOf":{"@id":"https:\/\/quike.it\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgres_post.png","datePublished":"2022-07-19T05:37:00+00:00","dateModified":"2024-07-24T13:21:41+00:00","description":"En este art\u00edculo explicaremos paso por paso c\u00f3mo configurar el Acceso Remoto PostgreSQL en los diferentes posibles escenarios en los que....","breadcrumb":{"@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/#primaryimage","url":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgres_post.png","contentUrl":"https:\/\/quike.it\/es\/wp-content\/uploads\/sites\/3\/2022\/07\/Postgres_post.png","width":1120,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/quike.it\/es\/como-configurar-acceso-remoto-postgresql\/#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 Configurar Acceso Remoto PostgreSQL"}]},{"@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\/13563","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=13563"}],"version-history":[{"count":213,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/posts\/13563\/revisions"}],"predecessor-version":[{"id":39016,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/posts\/13563\/revisions\/39016"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/media\/39007"}],"wp:attachment":[{"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/media?parent=13563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/categories?post=13563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quike.it\/es\/wp-json\/wp\/v2\/tags?post=13563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}