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.

Prerequisites

Create a service

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

Connect to the new service

tip

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
    tip

    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:

    \d

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)