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!
The first step is to use terminal to install PostgreSQL , which is simple to do using the default package repositories.
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
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. You requirements may be different.
createuser --interactive --pwprompt
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
This was a relatively simple process that took me over an hour to figure out! Hopefully it saves somebody else that pain!