Connect to your Aiven for PostgreSQL® service

Connect to Aiven for PostgreSQL® with a tool or programming language of your choice. 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.

Connect with Go

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

Connect with Java

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

Connect with NodeJS

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

Connect with PHP

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

Connect with Python

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

Connect with psql

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

Connect with pgAdmin

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

Connect with Rivery

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

Connect with Skyvia

Skyvia is an universal cloud data platform. This

Connect with Zapier

Zapier is an automation platform that connects

Connect with DataGrip

Use DataGrip to connect to your Aiven for

Connect with DBeaver

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