Ch 3: Creating a Postgres Database with Aiven

Source: Dev.to

Recap

• Postgres – the DBMS we are using to create our database.
• Aiven – where we are hosting our Postgres database.
• DBeaver – the GUI we are using to interact with the database.

Create an Aiven account

We will be creating our Postgres database with Aiven, so the initial step is to get an Aiven account.

Create an Aiven service

Next, you need to create a service, which is essentially a database.

Select the PostgreSQL service type because we are creating a Postgres database.

Aiven offers subscription tiers, but you can start with the free tier for your first project, which allows you to create one service – “database”.

Once created, you should be able to see it under Services.

In the next post, we will explore how to connect Aiven to DBeaver, enabling you to interact with the database visually.