Postgresql cannot be reachedunable to connect to PostgreSQL 8.4 on Ubuntu 10.04 serverCannot connect to PostgreSQL DB Via pgAdminCannot change PostgreSQL portsecurity group not allowing connection to postgres ec2 awsCentOS 6 and PostgreSQL - Can't Connect to PortDovecot - auth error permission deniedCannot connect to PostgreSQL unix domain socketpostgresql port closed for remote accessUnable to remotely connect to Postgresql 9.5 instancePostgresql - Stops listening after mounting volume to data directory

Multi tool use
Multi tool use

I have a problem assistant manager, but I can't fire him

SQL counting distinct over partition

How to use memset in c++?

Implement Own Vector Class in C++

You have (3^2 + 2^3 + 2^2) Guesses Left. Figure out the Last one

Soft question: Examples where lack of mathematical rigour cause security breaches?

Can Rydberg constant be in joules?

How to safely destroy (a large quantity of) valid checks?

English word for "product of tinkering"

Why we don’t make use of the t-distribution for constructing a confidence interval for a proportion?

Why are trash cans referred to as "zafacón" in Puerto Rico?

How does an ordinary object become radioactive?

What setting controls moving the cursor on the command line?

What is the purpose of the goat for Azazel, as opposed to conventional offerings?

How to handle self harm scars on the arm in work environment?

Longest bridge/tunnel that can be cycled over/through?

A IP can traceroute to it, but can not ping

Why doesn't Adrian Toomes give up Spider-Man's identity?

How is water heavier than petrol, even though its molecular weight is less than petrol?

Is it possible to have a wealthy country without a middle class?

What can I, as a user, do about offensive reviews in App Store?

1980s live-action movie where individually-coloured nations on clouds fight

Has there been a multiethnic Star Trek character?

Pre-1972 sci-fi short story or novel: alien(?) tunnel where people try new moves and get destroyed if they're not the correct ones



Postgresql cannot be reached


unable to connect to PostgreSQL 8.4 on Ubuntu 10.04 serverCannot connect to PostgreSQL DB Via pgAdminCannot change PostgreSQL portsecurity group not allowing connection to postgres ec2 awsCentOS 6 and PostgreSQL - Can't Connect to PortDovecot - auth error permission deniedCannot connect to PostgreSQL unix domain socketpostgresql port closed for remote accessUnable to remotely connect to Postgresql 9.5 instancePostgresql - Stops listening after mounting volume to data directory






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








0















We are trying to access (server1)postgresql port 5432 on a different server(server 2) but we are not able to reach it.



Checking done:



  • port 5432 running/listening postgresql.conf

  • listening address okay:listen_addresses = '*'

  • pg_hba.conf also good: host all all 0.0.0.0/0 md5


  • firewall is also okay since packet trace results shows that server1 has been reached but denied by the
    server/application/db


  • Firewalld is off and allowed tcp on port 5432 in iptables.

Any other suggestions or possible cause why can't we establish the connection?










share|improve this question






















  • What is the error that you received?

    – Michael Hampton
    May 23 at 0:35











  • The telnet only shows us that it's only trying to connect. But we had a tcpdump running on server1(postgresql server) and there was a hit but the connection is not establishing.

    – faolores
    May 23 at 0:51






  • 1





    If the connection isn't establishing there's something wrong at the network or firewall level. Also try to telnet localhost 5432 from server1 to make sure postgresql is working without the network in the middle.

    – chicks
    May 23 at 1:31






  • 1





    Yup, I did that earlier, connection to itself is working properly. I've been thinking of the network too but its able to reach my server when traced via tcpdump.

    – faolores
    May 23 at 1:38







  • 1





    @chicks comment is on target, but also try telnet (server1 IP) 5432 from server1 to ensure it is listening on the public IP. If that is good, then turn the firewalld/iptables/whatever off temporarily, or set it to pass everything. Then test again. If it works, then the problem is your firewalld/iptables/whatever.

    – Jim L.
    May 23 at 23:25


















0















We are trying to access (server1)postgresql port 5432 on a different server(server 2) but we are not able to reach it.



Checking done:



  • port 5432 running/listening postgresql.conf

  • listening address okay:listen_addresses = '*'

  • pg_hba.conf also good: host all all 0.0.0.0/0 md5


  • firewall is also okay since packet trace results shows that server1 has been reached but denied by the
    server/application/db


  • Firewalld is off and allowed tcp on port 5432 in iptables.

Any other suggestions or possible cause why can't we establish the connection?










share|improve this question






















  • What is the error that you received?

    – Michael Hampton
    May 23 at 0:35











  • The telnet only shows us that it's only trying to connect. But we had a tcpdump running on server1(postgresql server) and there was a hit but the connection is not establishing.

    – faolores
    May 23 at 0:51






  • 1





    If the connection isn't establishing there's something wrong at the network or firewall level. Also try to telnet localhost 5432 from server1 to make sure postgresql is working without the network in the middle.

    – chicks
    May 23 at 1:31






  • 1





    Yup, I did that earlier, connection to itself is working properly. I've been thinking of the network too but its able to reach my server when traced via tcpdump.

    – faolores
    May 23 at 1:38







  • 1





    @chicks comment is on target, but also try telnet (server1 IP) 5432 from server1 to ensure it is listening on the public IP. If that is good, then turn the firewalld/iptables/whatever off temporarily, or set it to pass everything. Then test again. If it works, then the problem is your firewalld/iptables/whatever.

    – Jim L.
    May 23 at 23:25














0












0








0








We are trying to access (server1)postgresql port 5432 on a different server(server 2) but we are not able to reach it.



Checking done:



  • port 5432 running/listening postgresql.conf

  • listening address okay:listen_addresses = '*'

  • pg_hba.conf also good: host all all 0.0.0.0/0 md5


  • firewall is also okay since packet trace results shows that server1 has been reached but denied by the
    server/application/db


  • Firewalld is off and allowed tcp on port 5432 in iptables.

Any other suggestions or possible cause why can't we establish the connection?










share|improve this question














We are trying to access (server1)postgresql port 5432 on a different server(server 2) but we are not able to reach it.



Checking done:



  • port 5432 running/listening postgresql.conf

  • listening address okay:listen_addresses = '*'

  • pg_hba.conf also good: host all all 0.0.0.0/0 md5


  • firewall is also okay since packet trace results shows that server1 has been reached but denied by the
    server/application/db


  • Firewalld is off and allowed tcp on port 5432 in iptables.

Any other suggestions or possible cause why can't we establish the connection?







centos postgresql






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked May 23 at 0:27









faoloresfaolores

1




1












  • What is the error that you received?

    – Michael Hampton
    May 23 at 0:35











  • The telnet only shows us that it's only trying to connect. But we had a tcpdump running on server1(postgresql server) and there was a hit but the connection is not establishing.

    – faolores
    May 23 at 0:51






  • 1





    If the connection isn't establishing there's something wrong at the network or firewall level. Also try to telnet localhost 5432 from server1 to make sure postgresql is working without the network in the middle.

    – chicks
    May 23 at 1:31






  • 1





    Yup, I did that earlier, connection to itself is working properly. I've been thinking of the network too but its able to reach my server when traced via tcpdump.

    – faolores
    May 23 at 1:38







  • 1





    @chicks comment is on target, but also try telnet (server1 IP) 5432 from server1 to ensure it is listening on the public IP. If that is good, then turn the firewalld/iptables/whatever off temporarily, or set it to pass everything. Then test again. If it works, then the problem is your firewalld/iptables/whatever.

    – Jim L.
    May 23 at 23:25


















  • What is the error that you received?

    – Michael Hampton
    May 23 at 0:35











  • The telnet only shows us that it's only trying to connect. But we had a tcpdump running on server1(postgresql server) and there was a hit but the connection is not establishing.

    – faolores
    May 23 at 0:51






  • 1





    If the connection isn't establishing there's something wrong at the network or firewall level. Also try to telnet localhost 5432 from server1 to make sure postgresql is working without the network in the middle.

    – chicks
    May 23 at 1:31






  • 1





    Yup, I did that earlier, connection to itself is working properly. I've been thinking of the network too but its able to reach my server when traced via tcpdump.

    – faolores
    May 23 at 1:38







  • 1





    @chicks comment is on target, but also try telnet (server1 IP) 5432 from server1 to ensure it is listening on the public IP. If that is good, then turn the firewalld/iptables/whatever off temporarily, or set it to pass everything. Then test again. If it works, then the problem is your firewalld/iptables/whatever.

    – Jim L.
    May 23 at 23:25

















What is the error that you received?

– Michael Hampton
May 23 at 0:35





What is the error that you received?

– Michael Hampton
May 23 at 0:35













The telnet only shows us that it's only trying to connect. But we had a tcpdump running on server1(postgresql server) and there was a hit but the connection is not establishing.

– faolores
May 23 at 0:51





The telnet only shows us that it's only trying to connect. But we had a tcpdump running on server1(postgresql server) and there was a hit but the connection is not establishing.

– faolores
May 23 at 0:51




1




1





If the connection isn't establishing there's something wrong at the network or firewall level. Also try to telnet localhost 5432 from server1 to make sure postgresql is working without the network in the middle.

– chicks
May 23 at 1:31





If the connection isn't establishing there's something wrong at the network or firewall level. Also try to telnet localhost 5432 from server1 to make sure postgresql is working without the network in the middle.

– chicks
May 23 at 1:31




1




1





Yup, I did that earlier, connection to itself is working properly. I've been thinking of the network too but its able to reach my server when traced via tcpdump.

– faolores
May 23 at 1:38






Yup, I did that earlier, connection to itself is working properly. I've been thinking of the network too but its able to reach my server when traced via tcpdump.

– faolores
May 23 at 1:38





1




1





@chicks comment is on target, but also try telnet (server1 IP) 5432 from server1 to ensure it is listening on the public IP. If that is good, then turn the firewalld/iptables/whatever off temporarily, or set it to pass everything. Then test again. If it works, then the problem is your firewalld/iptables/whatever.

– Jim L.
May 23 at 23:25






@chicks comment is on target, but also try telnet (server1 IP) 5432 from server1 to ensure it is listening on the public IP. If that is good, then turn the firewalld/iptables/whatever off temporarily, or set it to pass everything. Then test again. If it works, then the problem is your firewalld/iptables/whatever.

– Jim L.
May 23 at 23:25











0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f968501%2fpostgresql-cannot-be-reached%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Server Fault!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f968501%2fpostgresql-cannot-be-reached%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







LvbdnZy xJ5Uio,DSQg6eYcUJHKDRUldOY kZa9sdI,j3hVh tHjnj4l,JbZ
NhDfiGQ27RMGdf

Popular posts from this blog

Club Baloncesto Breogán Índice Historia | Pavillón | Nome | O Breogán na cultura popular | Xogadores | Adestradores | Presidentes | Palmarés | Historial | Líderes | Notas | Véxase tamén | Menú de navegacióncbbreogan.galCadroGuía oficial da ACB 2009-10, páxina 201Guía oficial ACB 1992, páxina 183. Editorial DB.É de 6.500 espectadores sentados axeitándose á última normativa"Estudiantes Junior, entre as mellores canteiras"o orixinalHemeroteca El Mundo Deportivo, 16 setembro de 1970, páxina 12Historia do BreogánAlfredo Pérez, o último canoneiroHistoria C.B. BreogánHemeroteca de El Mundo DeportivoJimmy Wright, norteamericano do Breogán deixará Lugo por ameazas de morteResultados de Breogán en 1986-87Resultados de Breogán en 1990-91Ficha de Velimir Perasović en acb.comResultados de Breogán en 1994-95Breogán arrasa al Barça. "El Mundo Deportivo", 27 de setembro de 1999, páxina 58CB Breogán - FC BarcelonaA FEB invita a participar nunha nova Liga EuropeaCharlie Bell na prensa estatalMáximos anotadores 2005Tempada 2005-06 : Tódolos Xogadores da Xornada""Non quero pensar nunha man negra, mais pregúntome que está a pasar""o orixinalRaúl López, orgulloso dos xogadores, presume da boa saúde económica do BreogánJulio González confirma que cesa como presidente del BreogánHomenaxe a Lisardo GómezA tempada do rexurdimento celesteEntrevista a Lisardo GómezEl COB dinamita el Pazo para forzar el quinto (69-73)Cafés Candelas, patrocinador del CB Breogán"Suso Lázare, novo presidente do Breogán"o orixinalCafés Candelas Breogán firma el mayor triunfo de la historiaEl Breogán realizará 17 homenajes por su cincuenta aniversario"O Breogán honra ao seu fundador e primeiro presidente"o orixinalMiguel Giao recibiu a homenaxe do PazoHomenaxe aos primeiros gladiadores celestesO home que nos amosa como ver o Breo co corazónTita Franco será homenaxeada polos #50anosdeBreoJulio Vila recibirá unha homenaxe in memoriam polos #50anosdeBreo"O Breogán homenaxeará aos seus aboados máis veteráns"Pechada ovación a «Capi» Sanmartín e Ricardo «Corazón de González»Homenaxe por décadas de informaciónPaco García volve ao Pazo con motivo do 50 aniversario"Resultados y clasificaciones""O Cafés Candelas Breogán, campión da Copa Princesa""O Cafés Candelas Breogán, equipo ACB"C.B. Breogán"Proxecto social"o orixinal"Centros asociados"o orixinalFicha en imdb.comMario Camus trata la recuperación del amor en 'La vieja música', su última película"Páxina web oficial""Club Baloncesto Breogán""C. B. Breogán S.A.D."eehttp://www.fegaba.com

Vilaño, A Laracha Índice Patrimonio | Lugares e parroquias | Véxase tamén | Menú de navegación43°14′52″N 8°36′03″O / 43.24775, -8.60070

Cegueira Índice Epidemioloxía | Deficiencia visual | Tipos de cegueira | Principais causas de cegueira | Tratamento | Técnicas de adaptación e axudas | Vida dos cegos | Primeiros auxilios | Crenzas respecto das persoas cegas | Crenzas das persoas cegas | O neno deficiente visual | Aspectos psicolóxicos da cegueira | Notas | Véxase tamén | Menú de navegación54.054.154.436928256blindnessDicionario da Real Academia GalegaPortal das Palabras"International Standards: Visual Standards — Aspects and Ranges of Vision Loss with Emphasis on Population Surveys.""Visual impairment and blindness""Presentan un plan para previr a cegueira"o orixinalACCDV Associació Catalana de Cecs i Disminuïts Visuals - PMFTrachoma"Effect of gene therapy on visual function in Leber's congenital amaurosis"1844137110.1056/NEJMoa0802268Cans guía - os mellores amigos dos cegosArquivadoEscola de cans guía para cegos en Mortágua, PortugalArquivado"Tecnología para ciegos y deficientes visuales. Recopilación de recursos gratuitos en la Red""Colorino""‘COL.diesis’, escuchar los sonidos del color""COL.diesis: Transforming Colour into Melody and Implementing the Result in a Colour Sensor Device"o orixinal"Sistema de desarrollo de sinestesia color-sonido para invidentes utilizando un protocolo de audio""Enseñanza táctil - geometría y color. Juegos didácticos para niños ciegos y videntes""Sistema Constanz"L'ocupació laboral dels cecs a l'Estat espanyol està pràcticament equiparada a la de les persones amb visió, entrevista amb Pedro ZuritaONCE (Organización Nacional de Cegos de España)Prevención da cegueiraDescrición de deficiencias visuais (Disc@pnet)Braillín, un boneco atractivo para calquera neno, con ou sen discapacidade, que permite familiarizarse co sistema de escritura e lectura brailleAxudas Técnicas36838ID00897494007150-90057129528256DOID:1432HP:0000618D001766C10.597.751.941.162C97109C0155020