Connect to Aiven for PostgreSQL®

Connect to the Aiven for PostgreSQL® service using various programming languages or tools. All connections to PostgreSQL are encrypted and protected with TLS.

For a connection to be established, sslmode can be set as follows:

• By default, sslmode needs to be set to require. This ensures that TLS is used and data is encrypted while in-transit. This doesn't require or verify a certificate.
• For more security, sslmode can be set either to verify-ca or to verify-full. Each of these modes requires supplying a certificate (ca.pem) and verifies it.

Read more about TLS/SSL certificates.

Go

This example connects to PostgreSQL® service from Go, making use of the

Java

This example connects to PostgreSQL® service from Java, making use of JDBC Driver.

NodeJS

This example connects to PostgreSQL® service from NodeJS, making use of the pg package.

PHP

This example connects to PostgreSQL® service from PHP, making use of the

Python

This example connects to a PostgreSQL® service from Python, making use

psql

psql is a command line tool for PostgreSQL®, useful to manage and

pgAdmin

pgAdmin is one of the most popular PostgreSQL® clients. Use it to manage and query your database.

Rivery

Configure PostgreSQL® as a connection in Rivery, a fully managed solution for data ingestion, transformation, orchestration, reverse ETL and more.

Skyvia

Skyvia is an universal cloud data platform. This

Zapier

Zapier is an automation platform that connects

DataGrip

Use DataGrip to connect to your Aiven for

DBeaver

Use DBeaver to connect to your Aiven for PostgreSQL® service.