Connecting to Postgres RDS from outside using DataGripsecurity group not allowing connection to postgres ec2 awsOn AWS why does internal DNS lookup for RDS fail in PHP page?Can I access an AWS RDS read replica directly from Internet?Connect to RDS from EC2 instance — both inside VPCHow to connect to a publicly available RDS instance using Sequel ProUnable to connect to RDS instance from outside VPC (ERROR 2003 (HY000) Can't connect to MySQL Server)Cant connect to rds from ec2 , but can connect from my own computerDoes an AWS RDS Endpoint FQDN change when making an instance Private?AWS EB and RDS: Invalid storage size for engine name mysql and storage type gp2Connected to AWS RDS using Flask-SQLAlchemy
One verb to replace 'be a member of' a club
Placement of More Information/Help Icon button for Radio Buttons
Can I hook these wires up to find the connection to a dead outlet?
How seriously should I take size and weight limits of hand luggage?
How to remove border from elements in the last row?
Avoiding the "not like other girls" trope?
What is a Samsaran Word™?
How to travel to Japan while expressing milk?
Why were 5.25" floppy drives cheaper than 8"?
Venezuelan girlfriend wants to travel the USA to be with me. What is the process?
files created then deleted at every second in tmp directory
How badly should I try to prevent a user from XSSing themselves?
Knowledge-based authentication using Domain-driven Design in C#
Using "tail" to follow a file without displaying the most recent lines
How can saying a song's name be a copyright violation?
What reasons are there for a Capitalist to oppose a 100% inheritance tax?
Why was the shrink from 8″ made only to 5.25″ and not smaller (4″ or less)
How many wives did king shaul have
How to Prove P(a) → ∀x(P(x) ∨ ¬(x = a)) using Natural Deduction
What do you call someone who asks many questions?
Car headlights in a world without electricity
How exploitable/balanced is this homebrew spell: Spell Permanency?
Why do I get negative height?
How to prevent "they're falling in love" trope
Connecting to Postgres RDS from outside using DataGrip
security group not allowing connection to postgres ec2 awsOn AWS why does internal DNS lookup for RDS fail in PHP page?Can I access an AWS RDS read replica directly from Internet?Connect to RDS from EC2 instance — both inside VPCHow to connect to a publicly available RDS instance using Sequel ProUnable to connect to RDS instance from outside VPC (ERROR 2003 (HY000) Can't connect to MySQL Server)Cant connect to rds from ec2 , but can connect from my own computerDoes an AWS RDS Endpoint FQDN change when making an instance Private?AWS EB and RDS: Invalid storage size for engine name mysql and storage type gp2Connected to AWS RDS using Flask-SQLAlchemy
I have setup Postgres RDS instance on AWS. Made it publicly accessible and security group allows all traffic inside and outside.
However I still can't connect from outside network (using DataGrip).
Connection to jdbc:postgresql://name.abcd.eu-west-1.rds.amazonaws.com
:5432/mydb failed. Host name.abcd.eu-west-1.rds.amazonaws.com is
unknown. [08001] The connection attempt failed.
I copied the endpoint from AWS console and I'm using the username and password I entered when creating the instance.
What am I doing wrong?
amazon-web-services postgresql rds
asked Nov 1 '17 at 13:35
simPodsimPod
1013
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have setup Postgres RDS instance on AWS. Made it publicly accessible and security group allows all traffic inside and outside.
However I still can't connect from outside network (using DataGrip).
Connection to jdbc:postgresql://name.abcd.eu-west-1.rds.amazonaws.com
:5432/mydb failed. Host name.abcd.eu-west-1.rds.amazonaws.com is
unknown. [08001] The connection attempt failed.
I copied the endpoint from AWS console and I'm using the username and password I entered when creating the instance.
What am I doing wrong?
amazon-web-services postgresql rds
asked Nov 1 '17 at 13:35
simPodsimPod
1013
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
How long ago did this happen? THe DNS can take a while to propagate. What happens when you try "host name.abcd.eu-west-1.rds.amazonaws.com" from your PC (or nslookup/dig)?
– TheFiddlerWins
Nov 1 '17 at 17:36
1
"Host name is unknown" is likely the problem. Do an nslookup to start. If that works check your connect string format.
– Tim
Nov 1 '17 at 18:32
add a comment |
I have setup Postgres RDS instance on AWS. Made it publicly accessible and security group allows all traffic inside and outside.
However I still can't connect from outside network (using DataGrip).
Connection to jdbc:postgresql://name.abcd.eu-west-1.rds.amazonaws.com
:5432/mydb failed. Host name.abcd.eu-west-1.rds.amazonaws.com is
unknown. [08001] The connection attempt failed.
I copied the endpoint from AWS console and I'm using the username and password I entered when creating the instance.
What am I doing wrong?
amazon-web-services postgresql rds
asked Nov 1 '17 at 13:35
simPodsimPod
1013
I have setup Postgres RDS instance on AWS. Made it publicly accessible and security group allows all traffic inside and outside.
However I still can't connect from outside network (using DataGrip).
Connection to jdbc:postgresql://name.abcd.eu-west-1.rds.amazonaws.com
:5432/mydb failed. Host name.abcd.eu-west-1.rds.amazonaws.com is
unknown. [08001] The connection attempt failed.
I copied the endpoint from AWS console and I'm using the username and password I entered when creating the instance.
What am I doing wrong?
amazon-web-services postgresql rds
amazon-web-services postgresql rds
asked Nov 1 '17 at 13:35
simPodsimPod
1013
asked Nov 1 '17 at 13:35
simPodsimPod
1013
edited Nov 1 '17 at 20:32
simPod
asked Nov 1 '17 at 13:35
simPodsimPod
1013
asked Nov 1 '17 at 13:35
simPodsimPod
1013
asked Nov 1 '17 at 13:35
simPodsimPod
1013
1013
bumped to the homepage by Community♦ yesterday
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♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
How long ago did this happen? THe DNS can take a while to propagate. What happens when you try "host name.abcd.eu-west-1.rds.amazonaws.com" from your PC (or nslookup/dig)?
– TheFiddlerWins
Nov 1 '17 at 17:36
1
"Host name is unknown" is likely the problem. Do an nslookup to start. If that works check your connect string format.
– Tim
Nov 1 '17 at 18:32
add a comment |
1
How long ago did this happen? THe DNS can take a while to propagate. What happens when you try "host name.abcd.eu-west-1.rds.amazonaws.com" from your PC (or nslookup/dig)?
– TheFiddlerWins
Nov 1 '17 at 17:36
1
"Host name is unknown" is likely the problem. Do an nslookup to start. If that works check your connect string format.
– Tim
Nov 1 '17 at 18:32
1
1
How long ago did this happen? THe DNS can take a while to propagate. What happens when you try "host name.abcd.eu-west-1.rds.amazonaws.com" from your PC (or nslookup/dig)?
– TheFiddlerWins
Nov 1 '17 at 17:36
How long ago did this happen? THe DNS can take a while to propagate. What happens when you try "host name.abcd.eu-west-1.rds.amazonaws.com" from your PC (or nslookup/dig)?
– TheFiddlerWins
Nov 1 '17 at 17:36
1
1
"Host name is unknown" is likely the problem. Do an nslookup to start. If that works check your connect string format.
– Tim
Nov 1 '17 at 18:32
"Host name is unknown" is likely the problem. Do an nslookup to start. If that works check your connect string format.
– Tim
Nov 1 '17 at 18:32
add a comment |
1 Answer
1
active
oldest
votes
The problem was in DataGrip itself. It put a space between port and host
...amazonaws.com :5432...
To get it working you have to:
- make instance publicly accessible when creating
- setup inbound traffic properly for instance's security group
When this is done, just try this command psql -h endpoint -U username -d databasename in you command line so you know you can connect. If it succeeds, you should be able to connect via DataGrip and any other client too.
answered Nov 1 '17 at 20:35
simPodsimPod
1013
add a comment |
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%2f881361%2fconnecting-to-postgres-rds-from-outside-using-datagrip%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
The problem was in DataGrip itself. It put a space between port and host
...amazonaws.com :5432...
To get it working you have to:
- make instance publicly accessible when creating
- setup inbound traffic properly for instance's security group
When this is done, just try this command psql -h endpoint -U username -d databasename in you command line so you know you can connect. If it succeeds, you should be able to connect via DataGrip and any other client too.
answered Nov 1 '17 at 20:35
simPodsimPod
1013
add a comment |
The problem was in DataGrip itself. It put a space between port and host
...amazonaws.com :5432...
To get it working you have to:
- make instance publicly accessible when creating
- setup inbound traffic properly for instance's security group
When this is done, just try this command psql -h endpoint -U username -d databasename in you command line so you know you can connect. If it succeeds, you should be able to connect via DataGrip and any other client too.
answered Nov 1 '17 at 20:35
simPodsimPod
1013
add a comment |
The problem was in DataGrip itself. It put a space between port and host
...amazonaws.com :5432...
To get it working you have to:
- make instance publicly accessible when creating
- setup inbound traffic properly for instance's security group
When this is done, just try this command psql -h endpoint -U username -d databasename in you command line so you know you can connect. If it succeeds, you should be able to connect via DataGrip and any other client too.
answered Nov 1 '17 at 20:35
simPodsimPod
1013
The problem was in DataGrip itself. It put a space between port and host
...amazonaws.com :5432...
To get it working you have to:
- make instance publicly accessible when creating
- setup inbound traffic properly for instance's security group
When this is done, just try this command psql -h endpoint -U username -d databasename in you command line so you know you can connect. If it succeeds, you should be able to connect via DataGrip and any other client too.
answered Nov 1 '17 at 20:35
simPodsimPod
1013
answered Nov 1 '17 at 20:35
simPodsimPod
1013
answered Nov 1 '17 at 20:35
simPodsimPod
1013
answered Nov 1 '17 at 20:35
simPodsimPod
1013
1013
add a comment |
add a comment |
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%2f881361%2fconnecting-to-postgres-rds-from-outside-using-datagrip%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
1
How long ago did this happen? THe DNS can take a while to propagate. What happens when you try "host name.abcd.eu-west-1.rds.amazonaws.com" from your PC (or nslookup/dig)?
– TheFiddlerWins
Nov 1 '17 at 17:36
1
"Host name is unknown" is likely the problem. Do an nslookup to start. If that works check your connect string format.
– Tim
Nov 1 '17 at 18:32