Postgres Installed in Linux (RHEL) and trying to access / connect using pgadmin (Windows)
0
I've installed and configured postgresql in Linux successfully,
1. postgres user created
2. new db created successfully
3. I'm trying to connect using pgadmin III (Windows)
4. Following details are adding in pgadmin window
Host: DEMO
Host: XXXX
Port: 5432
Maintenance DB: postgres
Username: postgres
password: G0!mf17.
5. Clicked on OK
It's tried to connect and displayed message connecting to database.... Failed.
I'm not sure why it's failed and what needs to configure in linux system.
I'm new to linux, If anyone able to guide me solve this issue it will be greatful.
Please let me know if you need more details.
installation postgresql-9.4 redhat
edited Oct 28 '15 at 13:53
Md Haidar Ali Khan
3,64462342
asked Oct 28 '15 at 12:24
Madhu ManoharMadhu Manohar
1
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
|
show 3 more comments
0
I've installed and configured postgresql in Linux successfully,
1. postgres user created
2. new db created successfully
3. I'm trying to connect using pgadmin III (Windows)
4. Following details are adding in pgadmin window
Host: DEMO
Host: XXXX
Port: 5432
Maintenance DB: postgres
Username: postgres
password: G0!mf17.
5. Clicked on OK
It's tried to connect and displayed message connecting to database.... Failed.
I'm not sure why it's failed and what needs to configure in linux system.
I'm new to linux, If anyone able to guide me solve this issue it will be greatful.
Please let me know if you need more details.
installation postgresql-9.4 redhat
edited Oct 28 '15 at 13:53
Md Haidar Ali Khan
3,64462342
asked Oct 28 '15 at 12:24
Madhu ManoharMadhu Manohar
1
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
I'm pretty sure the error message contains more information than just "Failed". Please edit your question and add the exact error message.
– a_horse_with_no_name
Oct 28 '15 at 12:28
I'm not sure where to check for error message, can you please guide me?
– Madhu Manohar
Oct 28 '15 at 12:35
Did you configure that postgres listens on the right IP address and that it accepts the IP address of you windows computer?
– Marco
Oct 28 '15 at 12:35
I'm really sorry to say this.. I've really dont know what's need to be done
– Madhu Manohar
Oct 28 '15 at 12:36
Perhaps start by reading the manual on how to configure Postgres. This way you either solve the problem yourself or you are able to ask more specific questions.
– Marco
Oct 28 '15 at 12:47
|
show 3 more comments
0
0
0
I've installed and configured postgresql in Linux successfully,
1. postgres user created
2. new db created successfully
3. I'm trying to connect using pgadmin III (Windows)
4. Following details are adding in pgadmin window
Host: DEMO
Host: XXXX
Port: 5432
Maintenance DB: postgres
Username: postgres
password: G0!mf17.
5. Clicked on OK
It's tried to connect and displayed message connecting to database.... Failed.
I'm not sure why it's failed and what needs to configure in linux system.
I'm new to linux, If anyone able to guide me solve this issue it will be greatful.
Please let me know if you need more details.
installation postgresql-9.4 redhat
edited Oct 28 '15 at 13:53
Md Haidar Ali Khan
3,64462342
asked Oct 28 '15 at 12:24
Madhu ManoharMadhu Manohar
1
I've installed and configured postgresql in Linux successfully,
1. postgres user created
2. new db created successfully
3. I'm trying to connect using pgadmin III (Windows)
4. Following details are adding in pgadmin window
Host: DEMO
Host: XXXX
Port: 5432
Maintenance DB: postgres
Username: postgres
password: G0!mf17.
5. Clicked on OK
It's tried to connect and displayed message connecting to database.... Failed.
I'm not sure why it's failed and what needs to configure in linux system.
I'm new to linux, If anyone able to guide me solve this issue it will be greatful.
Please let me know if you need more details.
installation postgresql-9.4 redhat
installation postgresql-9.4 redhat
edited Oct 28 '15 at 13:53
Md Haidar Ali Khan
3,64462342
asked Oct 28 '15 at 12:24
Madhu ManoharMadhu Manohar
1
edited Oct 28 '15 at 13:53
Md Haidar Ali Khan
3,64462342
asked Oct 28 '15 at 12:24
Madhu ManoharMadhu Manohar
1
edited Oct 28 '15 at 13:53
Md Haidar Ali Khan
3,64462342
edited Oct 28 '15 at 13:53
Md Haidar Ali Khan
3,64462342
edited Oct 28 '15 at 13:53
Md Haidar Ali Khan
3,64462342
3,64462342
asked Oct 28 '15 at 12:24
Madhu ManoharMadhu Manohar
1
asked Oct 28 '15 at 12:24
Madhu ManoharMadhu Manohar
1
asked Oct 28 '15 at 12:24
Madhu ManoharMadhu Manohar
1
1
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 min ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
I'm pretty sure the error message contains more information than just "Failed". Please edit your question and add the exact error message.
– a_horse_with_no_name
Oct 28 '15 at 12:28
I'm not sure where to check for error message, can you please guide me?
– Madhu Manohar
Oct 28 '15 at 12:35
Did you configure that postgres listens on the right IP address and that it accepts the IP address of you windows computer?
– Marco
Oct 28 '15 at 12:35
I'm really sorry to say this.. I've really dont know what's need to be done
– Madhu Manohar
Oct 28 '15 at 12:36
Perhaps start by reading the manual on how to configure Postgres. This way you either solve the problem yourself or you are able to ask more specific questions.
– Marco
Oct 28 '15 at 12:47
|
show 3 more comments
I'm pretty sure the error message contains more information than just "Failed". Please edit your question and add the exact error message.
– a_horse_with_no_name
Oct 28 '15 at 12:28
I'm not sure where to check for error message, can you please guide me?
– Madhu Manohar
Oct 28 '15 at 12:35
Did you configure that postgres listens on the right IP address and that it accepts the IP address of you windows computer?
– Marco
Oct 28 '15 at 12:35
I'm really sorry to say this.. I've really dont know what's need to be done
– Madhu Manohar
Oct 28 '15 at 12:36
Perhaps start by reading the manual on how to configure Postgres. This way you either solve the problem yourself or you are able to ask more specific questions.
– Marco
Oct 28 '15 at 12:47
I'm pretty sure the error message contains more information than just "Failed". Please edit your question and add the exact error message.
– a_horse_with_no_name
Oct 28 '15 at 12:28
I'm pretty sure the error message contains more information than just "Failed". Please edit your question and add the exact error message.
– a_horse_with_no_name
Oct 28 '15 at 12:28
I'm not sure where to check for error message, can you please guide me?
– Madhu Manohar
Oct 28 '15 at 12:35
I'm not sure where to check for error message, can you please guide me?
– Madhu Manohar
Oct 28 '15 at 12:35
Did you configure that postgres listens on the right IP address and that it accepts the IP address of you windows computer?
– Marco
Oct 28 '15 at 12:35
Did you configure that postgres listens on the right IP address and that it accepts the IP address of you windows computer?
– Marco
Oct 28 '15 at 12:35
I'm really sorry to say this.. I've really dont know what's need to be done
– Madhu Manohar
Oct 28 '15 at 12:36
I'm really sorry to say this.. I've really dont know what's need to be done
– Madhu Manohar
Oct 28 '15 at 12:36
Perhaps start by reading the manual on how to configure Postgres. This way you either solve the problem yourself or you are able to ask more specific questions.
– Marco
Oct 28 '15 at 12:47
Perhaps start by reading the manual on how to configure Postgres. This way you either solve the problem yourself or you are able to ask more specific questions.
– Marco
Oct 28 '15 at 12:47
|
show 3 more comments
1 Answer
1
active
oldest
votes
0
First try to be more specific:
- Which version of RHEL are you using?
- Which version of Windows are you using?
- How are these computers connected?
- Are they in the same network segment?
- Are there any firewalls in between
Next, try the following:
- Check firewall configurations
- Windows firewall configuration (or any Antivirus/Firewall software that may be blocking the pgAdmin)
- SELinux configuration and/or any antivirus/firewall that may be preventing connections to the linux host
- If the host is a 'hostname' then check that the network services is translating the name correctly. Try a ping to the IP and then ping to the hostname. Or issue a dnslookup.
- In the linux system try netstat -a | grep LISTEN |grep "5432" to verify that there is a process actively LISTENING on port 5432
Hope this helps you to start solving your problem.
answered Oct 28 '15 at 12:59
SilvarionSilvarion
24415
RHEL Version: Red Hat Enterprise Linux Server release 5.11 (Tikanga) Windows: Windows 7 Ultimate Connecting using VPN Firewall -- OFF Firewall set to off on both Linux & Windows I've tried both with IP & hostname of the VM.
– Madhu Manohar
Oct 28 '15 at 13:41
OK. Is the VPN firewall allowing the app going through? Is the port open (5432)?
– Silvarion
Oct 28 '15 at 13:43
Firewall is disabled.
– Madhu Manohar
Oct 28 '15 at 16:23
Are the systems in the same local network? Use the last command posted in the answer, please and check for a LISTENING process in the Postgres port
– Silvarion
Oct 28 '15 at 21:24
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
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%2fdba.stackexchange.com%2fquestions%2f119421%2fpostgres-installed-in-linux-rhel-and-trying-to-access-connect-using-pgadmin%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
First try to be more specific:
- Which version of RHEL are you using?
- Which version of Windows are you using?
- How are these computers connected?
- Are they in the same network segment?
- Are there any firewalls in between
Next, try the following:
- Check firewall configurations
- Windows firewall configuration (or any Antivirus/Firewall software that may be blocking the pgAdmin)
- SELinux configuration and/or any antivirus/firewall that may be preventing connections to the linux host
- If the host is a 'hostname' then check that the network services is translating the name correctly. Try a ping to the IP and then ping to the hostname. Or issue a dnslookup.
- In the linux system try netstat -a | grep LISTEN |grep "5432" to verify that there is a process actively LISTENING on port 5432
Hope this helps you to start solving your problem.
answered Oct 28 '15 at 12:59
SilvarionSilvarion
24415
RHEL Version: Red Hat Enterprise Linux Server release 5.11 (Tikanga) Windows: Windows 7 Ultimate Connecting using VPN Firewall -- OFF Firewall set to off on both Linux & Windows I've tried both with IP & hostname of the VM.
– Madhu Manohar
Oct 28 '15 at 13:41
OK. Is the VPN firewall allowing the app going through? Is the port open (5432)?
– Silvarion
Oct 28 '15 at 13:43
Firewall is disabled.
– Madhu Manohar
Oct 28 '15 at 16:23
Are the systems in the same local network? Use the last command posted in the answer, please and check for a LISTENING process in the Postgres port
– Silvarion
Oct 28 '15 at 21:24
add a comment |
0
First try to be more specific:
- Which version of RHEL are you using?
- Which version of Windows are you using?
- How are these computers connected?
- Are they in the same network segment?
- Are there any firewalls in between
Next, try the following:
- Check firewall configurations
- Windows firewall configuration (or any Antivirus/Firewall software that may be blocking the pgAdmin)
- SELinux configuration and/or any antivirus/firewall that may be preventing connections to the linux host
- If the host is a 'hostname' then check that the network services is translating the name correctly. Try a ping to the IP and then ping to the hostname. Or issue a dnslookup.
- In the linux system try netstat -a | grep LISTEN |grep "5432" to verify that there is a process actively LISTENING on port 5432
Hope this helps you to start solving your problem.
answered Oct 28 '15 at 12:59
SilvarionSilvarion
24415
RHEL Version: Red Hat Enterprise Linux Server release 5.11 (Tikanga) Windows: Windows 7 Ultimate Connecting using VPN Firewall -- OFF Firewall set to off on both Linux & Windows I've tried both with IP & hostname of the VM.
– Madhu Manohar
Oct 28 '15 at 13:41
OK. Is the VPN firewall allowing the app going through? Is the port open (5432)?
– Silvarion
Oct 28 '15 at 13:43
Firewall is disabled.
– Madhu Manohar
Oct 28 '15 at 16:23
Are the systems in the same local network? Use the last command posted in the answer, please and check for a LISTENING process in the Postgres port
– Silvarion
Oct 28 '15 at 21:24
add a comment |
0
0
0
First try to be more specific:
- Which version of RHEL are you using?
- Which version of Windows are you using?
- How are these computers connected?
- Are they in the same network segment?
- Are there any firewalls in between
Next, try the following:
- Check firewall configurations
- Windows firewall configuration (or any Antivirus/Firewall software that may be blocking the pgAdmin)
- SELinux configuration and/or any antivirus/firewall that may be preventing connections to the linux host
- If the host is a 'hostname' then check that the network services is translating the name correctly. Try a ping to the IP and then ping to the hostname. Or issue a dnslookup.
- In the linux system try netstat -a | grep LISTEN |grep "5432" to verify that there is a process actively LISTENING on port 5432
Hope this helps you to start solving your problem.
answered Oct 28 '15 at 12:59
SilvarionSilvarion
24415
First try to be more specific:
- Which version of RHEL are you using?
- Which version of Windows are you using?
- How are these computers connected?
- Are they in the same network segment?
- Are there any firewalls in between
Next, try the following:
- Check firewall configurations
- Windows firewall configuration (or any Antivirus/Firewall software that may be blocking the pgAdmin)
- SELinux configuration and/or any antivirus/firewall that may be preventing connections to the linux host
- If the host is a 'hostname' then check that the network services is translating the name correctly. Try a ping to the IP and then ping to the hostname. Or issue a dnslookup.
- In the linux system try netstat -a | grep LISTEN |grep "5432" to verify that there is a process actively LISTENING on port 5432
Hope this helps you to start solving your problem.
answered Oct 28 '15 at 12:59
SilvarionSilvarion
24415
edited Oct 28 '15 at 21:26
answered Oct 28 '15 at 12:59
SilvarionSilvarion
24415
answered Oct 28 '15 at 12:59
SilvarionSilvarion
24415
answered Oct 28 '15 at 12:59
SilvarionSilvarion
24415
24415
RHEL Version: Red Hat Enterprise Linux Server release 5.11 (Tikanga) Windows: Windows 7 Ultimate Connecting using VPN Firewall -- OFF Firewall set to off on both Linux & Windows I've tried both with IP & hostname of the VM.
– Madhu Manohar
Oct 28 '15 at 13:41
OK. Is the VPN firewall allowing the app going through? Is the port open (5432)?
– Silvarion
Oct 28 '15 at 13:43
Firewall is disabled.
– Madhu Manohar
Oct 28 '15 at 16:23
Are the systems in the same local network? Use the last command posted in the answer, please and check for a LISTENING process in the Postgres port
– Silvarion
Oct 28 '15 at 21:24
add a comment |
RHEL Version: Red Hat Enterprise Linux Server release 5.11 (Tikanga) Windows: Windows 7 Ultimate Connecting using VPN Firewall -- OFF Firewall set to off on both Linux & Windows I've tried both with IP & hostname of the VM.
– Madhu Manohar
Oct 28 '15 at 13:41
OK. Is the VPN firewall allowing the app going through? Is the port open (5432)?
– Silvarion
Oct 28 '15 at 13:43
Firewall is disabled.
– Madhu Manohar
Oct 28 '15 at 16:23
Are the systems in the same local network? Use the last command posted in the answer, please and check for a LISTENING process in the Postgres port
– Silvarion
Oct 28 '15 at 21:24
RHEL Version: Red Hat Enterprise Linux Server release 5.11 (Tikanga) Windows: Windows 7 Ultimate Connecting using VPN Firewall -- OFF Firewall set to off on both Linux & Windows I've tried both with IP & hostname of the VM.
– Madhu Manohar
Oct 28 '15 at 13:41
RHEL Version: Red Hat Enterprise Linux Server release 5.11 (Tikanga) Windows: Windows 7 Ultimate Connecting using VPN Firewall -- OFF Firewall set to off on both Linux & Windows I've tried both with IP & hostname of the VM.
– Madhu Manohar
Oct 28 '15 at 13:41
OK. Is the VPN firewall allowing the app going through? Is the port open (5432)?
– Silvarion
Oct 28 '15 at 13:43
OK. Is the VPN firewall allowing the app going through? Is the port open (5432)?
– Silvarion
Oct 28 '15 at 13:43
Firewall is disabled.
– Madhu Manohar
Oct 28 '15 at 16:23
Firewall is disabled.
– Madhu Manohar
Oct 28 '15 at 16:23
Are the systems in the same local network? Use the last command posted in the answer, please and check for a LISTENING process in the Postgres port
– Silvarion
Oct 28 '15 at 21:24
Are the systems in the same local network? Use the last command posted in the answer, please and check for a LISTENING process in the Postgres port
– Silvarion
Oct 28 '15 at 21:24
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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
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%2fdba.stackexchange.com%2fquestions%2f119421%2fpostgres-installed-in-linux-rhel-and-trying-to-access-connect-using-pgadmin%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
I'm pretty sure the error message contains more information than just "Failed". Please edit your question and add the exact error message.
– a_horse_with_no_name
Oct 28 '15 at 12:28
I'm not sure where to check for error message, can you please guide me?
– Madhu Manohar
Oct 28 '15 at 12:35
Did you configure that postgres listens on the right IP address and that it accepts the IP address of you windows computer?
– Marco
Oct 28 '15 at 12:35
I'm really sorry to say this.. I've really dont know what's need to be done
– Madhu Manohar
Oct 28 '15 at 12:36
Perhaps start by reading the manual on how to configure Postgres. This way you either solve the problem yourself or you are able to ask more specific questions.
– Marco
Oct 28 '15 at 12:47