Skip to main content

Get started with Aiven for PostgreSQL®

Start using Aiven for PostgreSQL® by creating a service, connecting to it, and loading sample data.


Create a service

Create an Aiven for PostgreSQL® service in the Aiven Console.

Connect to the new service


Check different tools you can use to connect to Aiven for PostgreSQL in Connect to Aiven for PostgreSQL.

Connect to your new service with, for example, psql CLI tool.

Load a test dataset

If you're checking out PostgreSQL, loading a test dataset will give you something to look at. This example uses dellstore2, a standard store dataset with products, orders, inventory and customer information.

  1. Download the dellstore2-normal-1.0.tar.gz file from the PostgreSQL website and unzip it.

  2. Navigate to the dellstore2-normal-1.0 folder on your terminal.

  3. Connect to your PostgreSQL instance with psql as shown above.

  4. Create a dellstore database and connect to it with the following command from psql:

    CREATE DATABASE dellstore;
    \c dellstore

    Your psql terminal prefix will change to dellstore==> when you are connected to the correct database.

  5. Populate the database by executing the following command from psql:

    \i dellstore2-normal-1.0.sql
  6. Verify which objects have been created from psql:


The output should look like this:

List of relations
Schema | Name | Type | Owner
public | categories | table | avnadmin
public | categories_category_seq | sequence | avnadmin
public | cust_hist | table | avnadmin
public | customers | table | avnadmin
public | customers_customerid_seq | sequence | avnadmin
public | inventory | table | avnadmin
public | orderlines | table | avnadmin
public | orders | table | avnadmin
public | orders_orderid_seq | sequence | avnadmin
public | products | table | avnadmin
public | products_prod_id_seq | sequence | avnadmin
public | reorder | table | avnadmin
(12 rows)