DEV Community

Jawad Ali Abbasi
Jawad Ali Abbasi

Posted on

Apache AGE & PostgreSQL | Database Configurations Part II

Sup!

So let's get back to where we dropped off. We know how to open files to edit in terminal. Now we are going to edit some configurations in that file.

First of all, we will change the port number on which our database will run. Let's change it from 5432 to 5430 but this is up to you, you can make it whatever you want or leave it as it is.

To change this, scroll down the file a little until you see the port field. Just simple go ahead and change the number to whatever you want.

Next we have to add AGE extension to preloaded extensions so we don't have to load it every time we run this db.

Locate the field "shared_preloaded_libraries" and add 'age' on the right side.

You can also search in the bottom to look for your desired field. Just press '/' followed by the word you are looking for and press ENTER.

Finally we have to add 'ag_catalog' to the search_path. Similar steps, we can use '/' to search and then edit the field to include 'ag_catalog' as well.

Hope this helps in configuring files using vim.

Stay Tuned For More!

https://age.apache.org/
https://github.com/apache/age

Good Bye!

Top comments (0)