{"id":1718,"date":"2012-03-26T12:09:22","date_gmt":"2012-03-26T17:09:22","guid":{"rendered":"http:\/\/blog.vortexbird.com\/?p=1111"},"modified":"2012-03-26T12:09:22","modified_gmt":"2012-03-26T17:09:22","slug":"habilitar-conexiones-remotas-en-postgresql","status":"publish","type":"post","link":"https:\/\/vortexbird.com\/en\/habilitar-conexiones-remotas-en-postgresql\/","title":{"rendered":"Habilitar conexiones remotas en PostgreSQL"},"content":{"rendered":"<p style=\"text-align: justify;\">Cuando se instala <em>postgres<\/em> por defecto no permite conexiones remotas. Esto quiere decir que si deseas conectarte desde otra m\u00e1quina diferente no es posible. Si se est\u00e1 desarrollando una\u00a0aplicaci\u00f3n,\u00a0por lo general, es necesario el uso de conexiones remotas.<\/p>\n<p style=\"text-align: justify;\">A\u00a0continuaci\u00f3n,\u00a0se explican los simples pasos que se deben ejecutar para cumplir con este requerimiento:<\/p>\n<p style=\"text-align: justify;\"><strong>Paso 1:<\/strong>\u00a0Editar el archivo postgresql.conf, este archivo se encuentra en diferentes sitios dependiendo del sistema operativo y la distribuci\u00f3n de Linux que se est\u00e9 usando.<\/p>\n<p style=\"text-align: justify;\">Estas son algunas posibles rutas: Windows (C:\\PostgreSQL\\9.1\\data), CentOS (\/var\/lib\/pgsql\/data\/), Ubuntu (<em>\u00a0\/etc\/postgresql\/8.2\/main\/<\/em>). Una vez que se abre el archivo:<\/p>\n<p style=\"text-align: justify;\"><strong><em>Paso 1.1:<\/em><\/strong>\u00a0Se debe ubicar la siguiente l\u00ednea:<\/p>\n<pre lang=\"xml\" escaped=\"true\">#listen_addresses = 'localhost'\n<\/pre>\n<p>Cambiar por la siguiente l\u00ednea:<\/p>\n<pre lang=\"xml\" escaped=\"true\">listen_addresses = '*'\n<\/pre>\n<p><strong><em>Paso 1.2:<\/em><\/strong>\u00a0Se debe ubicar la siguiente l\u00ednea y le quitamos el comentario:<\/p>\n<pre lang=\"xml\" escaped=\"true\">#password_encryption = on\n<\/pre>\n<p>Para quitar el comentario, le quitamos el # al principio de la l\u00ednea:<\/p>\n<pre lang=\"xml\" escaped=\"true\">password_encryption = on\n<\/pre>\n<p><strong><em>Paso 1.3:<\/em><\/strong>\u00a0Guardar y cerrar el archivo.<\/p>\n<p><strong><em>Paso 1.4:<\/em><\/strong>\u00a0Reiniciar el <em>postgres<\/em>, esto dependiendo de sus sistemas operativo se puede realizar de varias formas. Linux (Ubuntu)<\/p>\n<pre lang=\"xml\" escaped=\"true\">sudo \/etc\/init.d\/postgresql-8.2 restart\n<\/pre>\n<p>Linux (CentOS)<\/p>\n<pre lang=\"xml\" escaped=\"true\">service postgresql restart\n<\/pre>\n<p>Windows Por la consola de servicios se reinicia.<br \/>\n&nbsp;<br \/>\n<strong>Paso 2:<\/strong>\u00a0Se debe modificar lista de acceso, la cual permite establecer relaciones de confianza para ciertos equipos\u00a0y\u00a0redes.<\/p>\n<p><strong><em>Paso 2.1:<\/em><\/strong>\u00a0Editar el fichero pg_hba.conf.\u00a0este archivo se encuentra en diferentes sitios dependiendo del sistema operativo y la distribuci\u00f3n de Linux que se est\u00e9 usando, estas son algunas posibles rutas Windows (C:\\PostgreSQL\\9.1\\data), CentOS (\/var\/lib\/pgsql\/data\/), Ubuntu (<em>\u00a0\/etc\/postgresql\/8.2\/main\/<\/em>):\u00a0<em>Una vez que se abre el archivo:<\/em>\u00a0Al final del archivo debemos agregar la siguiente l\u00ednea:<\/p>\n<pre lang=\"xml\" escaped=\"true\">host all all 0.0.0.0 0.0.0.0 md5\n<\/pre>\n<p><strong><em>Paso 2.2:<\/em><\/strong>\u00a0Guardar y cerrar el archivo.\u00a0<strong><em>Paso 2.3<\/em><\/strong>\u00a0Reiniciar el <em>postgres <\/em>esto dependiendo de sus sistemas operativo se puede realizar de varias formas. Linux (Ubuntu)<\/p>\n<pre lang=\"xml\" escaped=\"true\">sudo \/etc\/init.d\/postgresql-8.2 restart\n<\/pre>\n<p>Linux (CentOS)<\/p>\n<pre lang=\"xml\" escaped=\"true\">service postgresql restart\n<\/pre>\n<p style=\"text-align: justify;\">Windows Por la consola de servicios se reinicia. Es todo ya su servidor de bases de datos <em>postgres<\/em> debe aceptar conexiones remotas.<\/p>\n<p style=\"text-align: justify;\"><strong>Nota:<\/strong> Es un error com\u00fan que en el paso 2.1 pongan la direcci\u00f3n,\u00a0as\u00ed:\u00a00.0.0.0.0.0.0.0 esto est\u00e1 mal, es sin el punto del medio, debe ser\u00a0as\u00ed:\u00a00.0.0.0 0.0.0.0<\/p>","protected":false},"excerpt":{"rendered":"<p>Cuando se instala postgres por defecto no permite conexiones remotas. Esto quiere decir que si deseas conectarte desde otra m\u00e1quina &#8230; <a class=\"cz_readmore cz_readmore_no_icon\" href=\"https:\/\/vortexbird.com\/en\/habilitar-conexiones-remotas-en-postgresql\/\"><span>Read more<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":1758,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[66],"tags":[64,65,67,68],"class_list":["post-1718","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","tag-conexion-listen_addresses","tag-password_encryption","tag-postgresql","tag-service"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Habilitar conexiones remotas en PostgreSQL - Vortexbird<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vortexbird.com\/en\/habilitar-conexiones-remotas-en-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Habilitar conexiones remotas en PostgreSQL - Vortexbird\" \/>\n<meta property=\"og:description\" content=\"Cuando se instala postgres por defecto no permite conexiones remotas. Esto quiere decir que si deseas conectarte desde otra m\u00e1quina ... Leer m\u00e1s\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vortexbird.com\/en\/habilitar-conexiones-remotas-en-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Vortexbird\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-26T17:09:22+00:00\" \/>\n<meta name=\"author\" content=\"Vortex.bird\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vortex.bird\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/\"},\"author\":{\"name\":\"Vortex.bird\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#\\\/schema\\\/person\\\/e69cef57e13dc876e812bed5602ce051\"},\"headline\":\"Habilitar conexiones remotas en PostgreSQL\",\"datePublished\":\"2012-03-26T17:09:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/\"},\"wordCount\":348,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/#primaryimage\"},\"thumbnailUrl\":\"\",\"keywords\":[\"Conexion listen_addresses\",\"password_encryption\",\"PostgreSQL\",\"service\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/\",\"url\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/\",\"name\":\"Habilitar conexiones remotas en PostgreSQL - Vortexbird\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2012-03-26T17:09:22+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#\\\/schema\\\/person\\\/e69cef57e13dc876e812bed5602ce051\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/habilitar-conexiones-remotas-en-postgresql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/vortexbird.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Habilitar conexiones remotas en PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#website\",\"url\":\"https:\\\/\\\/vortexbird.com\\\/\",\"name\":\"Vortexbird\",\"description\":\"Desarrollo &aacute;gil de software\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/vortexbird.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#\\\/schema\\\/person\\\/e69cef57e13dc876e812bed5602ce051\",\"name\":\"Vortex.bird\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2df6992145042f545b1961db71214364407f18374dd916ec8351acb05d2a8380?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2df6992145042f545b1961db71214364407f18374dd916ec8351acb05d2a8380?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2df6992145042f545b1961db71214364407f18374dd916ec8351acb05d2a8380?s=96&d=mm&r=g\",\"caption\":\"Vortex.bird\"},\"sameAs\":[\"https:\\\/\\\/vortexbird.com\"],\"url\":\"https:\\\/\\\/vortexbird.com\\\/en\\\/author\\\/vortexbird\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Habilitar conexiones remotas en PostgreSQL - Vortexbird","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:\/\/vortexbird.com\/en\/habilitar-conexiones-remotas-en-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"Habilitar conexiones remotas en PostgreSQL - Vortexbird","og_description":"Cuando se instala postgres por defecto no permite conexiones remotas. Esto quiere decir que si deseas conectarte desde otra m\u00e1quina ... Leer m\u00e1s","og_url":"https:\/\/vortexbird.com\/en\/habilitar-conexiones-remotas-en-postgresql\/","og_site_name":"Vortexbird","article_published_time":"2012-03-26T17:09:22+00:00","author":"Vortex.bird","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vortex.bird","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/#article","isPartOf":{"@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/"},"author":{"name":"Vortex.bird","@id":"https:\/\/vortexbird.com\/#\/schema\/person\/e69cef57e13dc876e812bed5602ce051"},"headline":"Habilitar conexiones remotas en PostgreSQL","datePublished":"2012-03-26T17:09:22+00:00","mainEntityOfPage":{"@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/"},"wordCount":348,"commentCount":0,"image":{"@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/#primaryimage"},"thumbnailUrl":"","keywords":["Conexion listen_addresses","password_encryption","PostgreSQL","service"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/","url":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/","name":"Habilitar conexiones remotas en PostgreSQL - Vortexbird","isPartOf":{"@id":"https:\/\/vortexbird.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/#primaryimage"},"thumbnailUrl":"","datePublished":"2012-03-26T17:09:22+00:00","author":{"@id":"https:\/\/vortexbird.com\/#\/schema\/person\/e69cef57e13dc876e812bed5602ce051"},"breadcrumb":{"@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/vortexbird.com\/habilitar-conexiones-remotas-en-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/vortexbird.com\/"},{"@type":"ListItem","position":2,"name":"Habilitar conexiones remotas en PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/vortexbird.com\/#website","url":"https:\/\/vortexbird.com\/","name":"Vortexbird","description":"Desarrollo &aacute;gil de software","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vortexbird.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/vortexbird.com\/#\/schema\/person\/e69cef57e13dc876e812bed5602ce051","name":"Vortex.bird","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/2df6992145042f545b1961db71214364407f18374dd916ec8351acb05d2a8380?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2df6992145042f545b1961db71214364407f18374dd916ec8351acb05d2a8380?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2df6992145042f545b1961db71214364407f18374dd916ec8351acb05d2a8380?s=96&d=mm&r=g","caption":"Vortex.bird"},"sameAs":["https:\/\/vortexbird.com"],"url":"https:\/\/vortexbird.com\/en\/author\/vortexbird\/"}]}},"_links":{"self":[{"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/posts\/1718","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/comments?post=1718"}],"version-history":[{"count":0,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/posts\/1718\/revisions"}],"wp:attachment":[{"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/media?parent=1718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/categories?post=1718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/tags?post=1718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}