I experienced some challenges installing and connecting to Postgres SQL on my local Ubuntu 19.04 server, so I thought I would just detail the process just in case my future self, comes searching for the solution again!
Install PostgreSQL
The first step is to use terminal to install PostgreSQL , which is simple to do using the default package repositories.
Configure PostgreSQL
Once installed and if you want to be able to connect to your PostgreSQL database from our local network, which is what I needed to do.
You will need to remember to edit your configuration files, located in /etc/postgresql/10/main/
The first file to edit is the postgresql.conf
to configure which address you want PostgreSql to listen on. In my case it was on 192.168.0.24
. You can make use of the wild card '*'
Simply open the file using whichever text editor of choice in my case I used nano.

Once that is complete we now need to edit the pg_hba.conf
file to make sure it using our network ip address range.

Once complete we can simply restart our Postgres Service to ensure it picks ups the changes we made
Create your Postgres User
We can create the user account and Database we want to use. Using the terminal log into you Postgres server
Create the user and the database you need. In my case for the development environment I wanted to use a UserName/Password combination so I wanted to prompted to create a password. Your requirements may be different.
The wizard will guide you through the process of creating the user. Once complete you can create the database for the associated user. In my case the username is sourcelink and the database will be sourcelink
Connect to your database.
In my case, I want to connect to my database using DataGrip - The Cross-Platform IDE for databases so I simply configured Datagrip to connect

Summary
This was a relatively simple process that took me over an hour to figure out! Hopefully it saves somebody else that pain!
- How to add RSS feed to nuxt 3 - September 25, 2023
- What is Middleware in Dotnet - September 19, 2023
- How to create a WebSocket server in dotnet - September 11, 2023