Using a PostgreSQL client to connect to your DB cluster

You can use a PostgreSQL client to connect to Babelfish on the PostgreSQL port.

Using psql to connect to the DB cluster

You can download the PostgreSQL client from the PostgreSQL website. Follow the instructions specific to your operating system version to install psql.

You can query an Aurora PostgreSQL DB cluster that supports Babelfish with the psql command line client. When connecting, use the PostgreSQL port (by default, port 5432). Typically, you don't need to specify the port number unless you changed it from the default. Use the following command to connect to Babelfish from the psql client:

psql -h bfish-db.cluster-123456789012.aws-region.rds.amazonaws.com
-p 5432 -U postgres -d babelfish_db

The parameters are as follows:

When you run a SQL command on the psql client, you end the command with a semicolon. For example, the following SQL command queries the pg_tables system view to return information about each table in the database.

SELECT * FROM pg_tables;

The psql client also has a set of built-in metacommands. A metacommand is a shortcut that adjusts formatting or provides a shortcut that returns meta-data in an easy-to-use format. For example, the following metacommand returns similar information to the previous SQL command:

\d

Metacommands don't need to be terminated with a semicolon (;).

To exit the psql client, enter \q.

For more information about using the psql client to query an Aurora PostgreSQL cluster, see the PostgreSQL documentation.

Using pgAdmin to connect to the DB cluster

You can use the pgAdmin client to access your data in native PostgreSQL dialect.

After connecting, you can use pgAdmin functionality to monitor and manage your Aurora PostgreSQL cluster on the PostgreSQL port.

To learn more, see the pgAdmin web page.