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
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;
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
|
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
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 totelnet 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 trytelnet (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
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
centos postgresql
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 totelnet 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 trytelnet (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
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 totelnet 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 trytelnet (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
|
show 1 more comment
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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