Otdfbt

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?

centos postgresql

share|improve this question

asked May 23 at 0:27

faoloresfaolores

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
  
  

  
  
  
  

 | 
show 1 more comment

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?

centos postgresql

share|improve this question

asked May 23 at 0:27

faoloresfaolores

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
  
  

  
  
  
  

 | 
show 1 more comment

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

asked May 23 at 0:27

faoloresfaolores

1

share|improve this question

asked May 23 at 0:27

faoloresfaolores

1

share|improve this question

asked May 23 at 0:27

faoloresfaolores

1

asked May 23 at 0:27

faoloresfaolores

1

asked May 23 at 0:27

faoloresfaolores

1