Call Us! 1-800-383-5193
Call Us! 1-800-383-5193

Need Help?

Our experts will login to your server within 30 minutes to fix urgent issues.

We will keep your servers stable, secure and fast at all times for one fixed price.

Quick ways to connect to AWS RDS Postgres

Looking for a way to connect to AWS RDS Postgres instance? We can help you.

Amazon Relational Database Service allows users to quickly create databases in the AWS cloud.

But users often experience problems while connecting to these databases.

At Bobcares, we resolve database connection errors as part of our AWS Support Services.

Today, we’ll see the different methods to connect to AWS Postgres instances.

 

Few facts on AWS RDS Postgres instance

To begin with, let’s check more details on Amazon RDS.

Amazon RDS is a managed database service. In this way, users do not have to maintain a database server. It comes with automated backups, options to scale up as per need, etc. Amazon RDS supports all popular databases like MySQL, Postgres, etc. Thus it allows hosting the databases of your application.

 

Why connect to AWS RDS Postgres

Till now, we saw the details of AWS RDS Postgres instances. But, why would we need access to Postgres instance?

We require access to the Postgres database to make direct modifications in the database. The database tables may require changes according to the requirements of the applications. Likewise, we may need to do select queries to get the desired results as well.

 

Top methods to connect to AWS RDS Postgres

By default, AWS RDS does not provide shell access to database instances.

Then how can we connect to the Postgres database running on AWS RDS?

Let’s check the top ways to connect.

 

1. Using pgAdmin

One of the quick ways to connect to the Postgres database is by using pgAdmin. The pgAdmin is an open-source tool that allows connection to the database running in AWS.

For connecting to PostgreSQL DB using PGAdmin tool,

  1. We launch the pgAdmin application on your client computer.
  2. On the Dashboard tab, choose Add New Server.
  3. In the Create – Server dialog box, type a name on the General tab to identify the server in pgAdmin.
  4. On the Connection tab, type the details of the DB instance:
    – Enter the Host as the endpoint name: “pg-prod.xxxxx-1.rds.amazonaws.com” (Can retrieve information from AWS console)
    – For Port, type the assigned port: 5432
    – Type the user name that you entered when you created the DB instance.
    – For Password, type the password that you entered when you created the DB instance.

2. Connect via psql

Likewise, we can connect to the Postgres databases using psql as well.

Psql is a command-line utility to connect to a PostgreSQL DB instance.

For this, we install the psql client on the home computer. Here, to connect to the PostgreSQL DB instance using psql, we need to provide host information and access credentials.

To connect to the PostgreSQL database mydb located in RDS server pg-prod.chnxxxxx.rds.amazonaws.com as user myuser, we use the command as

psql -h pg-prod.chnxxxxx.rds.amazonaws.com --port=5432 -U myuser --dbname=mydb

 

 

Common errors in AWS RDS Postgres connection

Although the steps for connection looks fairly simple, users often experience trouble while connecting to the PostgreSQL database.

Let’s check how our Support Engineers resolve them.

 

Public accessibility privileges

For an RDS DB instance to be publicly accessible, it should have the necessary privileges.

Recently, a customer reported problems with his RDS Postgres connection.

On further checking, we could see that the public accessibility of databases was set to NO. To fix the problem, we changed it to YES.

Final settings appear as:

connect to aws RDS Postgres

 

Security group restrictions

Further, security group restrictions also can trigger connectivity errors with RDS instances.

To make the connection, the security group assigned to the DB instance must allow access to port 5432. This also should allow outbound connections from the computer’s firewall.

Moreover, if the DB instance was created in a VPC, our Support Engineers ensures that it has a VPC security group that authorizes connections.

Last, and not the least, we confirm that the security group’s access rules are assigned to the DB instance correctly.

 

[Trouble connecting to your PostgreSQL database in AWS RDS? Let’s help you.]

 

Conclusion

In this write-up, we saw the ways to connect to AWS RDS Postgres database. We also saw how our Support Engineers troubleshoot connection errors and make it work.


Get 24x7 monitoring for your AWS servers

There are proven ways to get even more out of your AWS Infrastructure! Let us help you.

Spend your time in growing business and we will take care of AWS Infrastructure for you.

GET STARTED

Submit a Comment

Your email address will not be published. Required fields are marked *

AWS Support

Use your time to build great apps. Leave your servers to us.

Managing a server is time consuming. Whether you are an expert or a newbie, that is time you could use to focus on your product or service. Leave your server management to us, and use that time to focus on the growth and success of your business.

TALK TO USOr click here to learn more.

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF