2

Short description: AWS RDS connecting server to pgAdmin 4, PostgreSQL 11

Done: I have done similar to this guy or to this AWS guide, but at the end when I click Save, it does not accept it for me. Instead it gives the following:

Error:

Error saving properties
Unable to connect to server:
timeout expired

What I have tried to solve the problem:

  • The instance is active, and it is two hours after creation

  • I have also allowed to access the database with the outside of an AWS database client "YES"

  • This Stack Overflow answer does not deliver results: AWS RDS PostgreSQL pgAdmin - Server doesn't listen. Actually, after refreshing my security group like the guide says, my whole database disappeared

  • I have home Wi-Fi, so there aren't any corporate firewalls or any of those issues: Unable to connect to AWS RDS instance

  • while reading the previous Server Fault post, I looked up my

  • RDS/Databases: what was empty

  • RDS/Security groups: empty and I have this message:

    Your account does not support the EC2-Classic Platform in this region. DB Security Groups are only needed when the EC2-Classic Platform is supported. Instead, use VPC Security Groups to control access to your DB Instances.

  • I have tried which this question: Unable to connect to public PostgreSQL RDS instance that had two good answers, but they gave the same error even after doing both of the changes

  • Edward Q. Bridges's answer

  • Abhash Kumar's answer

Peter Mortensen
  • 2,327
sogu
  • 223

2 Answers2

2

By default, Public accessibility is set to false while creating a database in AWS.

There are two options. Either to select it to true while creating the database or in case if you forgot to select it, you can modify the database and set it true.

  1. While creating the database, Additional connectivity configuration section is collapsed and so it is difficult to notice this setting.

Enter image description here

Enter image description here

Expand the section Additional connectivity configuration, and you will find the setting to set "Publicly accessible" to Yes.

  1. In case you already created the database, then you can modify the database and set the "Public accessibility" to "Yes".
Peter Mortensen
  • 2,327
Manoj
  • 131
1

Edit inbound rules

"Type" (left-most column) has to be turned to: all traffic and my IP address. Then it works.

Enter image description here

Peter Mortensen
  • 2,327
sogu
  • 223