Step 2 – Update PostgreSQL Configuration Filesįirst, we will ssh into the server via the command line and edit the nf file with the following command. Once the inbound rules have been updated let’s proceed to update the PostgreSQL configuration files on the server. If you changed the default port then use your custom port instead of the default one)

Port Range: 5432 (This is the PostgreSQL port by default.

Next, you will edit the Security Group Inbound Rules.Īdd an inbound rule with the following parameters: Log into your AWS account and select the AWS instance running the PostgreSQL server you would like to connect to on the EC2 dashboard.

Step 2 – Update PostgreSQL Configuration Files.Step 1 – Configure Security Group on EC2.This article will assume that you already have a running EC2 Ubuntu 16.04 LTS instance with a PostgreSQL server running. Navicat is a vendor that offers a series of database management tools for PostgreSQL, Oracle, MariaDB, Microsoft SQL Server, MySQL and more. The purpose of this article is to show you how to connect you Navicat Database Admin Software tool to PostgreSQL server hosted on AWS EC2.

Navicat pgsql