We are building a Postgres database, which we hosted in Aiven. To interact with it, we have decided to go for the GUI platform, DBeaver, which will enable us to visually interact with the database.
1.Download DBeaver
If you are using Windows, you can find DBeaver on the Microsoft Store. For Mac and Linux users, you can download it from the website. It is an open-source platform, so you can get it freely.
2.Create a connection to Postgres
Select the create connection Icon and then select PostgreSQL as the database to connect to
3.Copy connection information from Aiven
You will get this page in DBeaver.
You need to navigate to Aiven and copy the connection information. Click on your Aiven service, and it should bring you to a page where you see connection information.
From Aiven, copy the host, port, database name, user name, and password and paste them into the respective fields on DBeaver. Remember to keep connected by as 'host' in DBeaver.
4.Test the connection in DBeaver
After you have connected everything, first test the connection before clicking finish with the button on the left. A successful test should give you this:
If the test was not successful, check the details you copied again and ensure each is correct. Click on finish,
You should be able to see your database on the left panel of the platform. If not, you can click on the window tab and select Database Navigator.
You can now interact with your database in DBeaver.
Next, we will look at how to create tables, schemas, etc and dive a little into SQL.
Top comments (0)