Connect to Amazon Aurora using a PostgreSQL connection

Anitha Abraham

Updated June 04, 2024 05:35

You can connect to your Amazon Aurora PostgreSQL database (DB) cluster using the Celigo PostgreSQL DB connection. First, connect to the cluster endpoint, then read (export) or write (import) data as required.

Connect to a Aurora DB cluster by setting up the Celigo PostgreSQL DB connection

Before you set up the PostgreSQL DB connection, keep values for these specific Amazon Aurora PostgreSQL DB cluster settings ready.

Setting	Description
Host	The connection string/URL to connect to the server that hosts the database. For example, `yourcluster.cluster-xxxxxxxxxx.us-east-1.rds.amazonaws.com` How to find the host details (connection string) Sign in to the AWS management console. Type "rds" in the Search box and open the Amazon Relational Database Service (RDS). In the upper-right corner of the Amazon RDS console, select your AWS Region for the DB cluster. In the left navigation pane, click Databases. In the database list, click a specific DB identifier and view the details. For example, "auroradatabase". In the Connectivity & security tab, click the copy icon next to the Endpoint name.
Database name	The identifier or name of the database.
Username	The user name to sign in to the database, provided during the Aurora PostgreSQL DB cluster setup.
Password	The password to sign in to the database, provided during the Aurora PostgreSQL DB cluster setup.
Port	The TCP port for the database engine. The default value is 5432 for the Aurora PostgreSQL DB cluster. However, check and use the value provided under Port in your specific cluster endpoint if it's anything different.(See steps provided for Host setting to view your port).

Now, use these details and set up a PostgreSQL DB connection to your Amazon Aurora PostgreSQL DB cluster.

After you connect to your Amazon Aurora PostgreSQL DB cluster, run any SQL command that is compatible with PostgreSQL in your exports or imports.