Hello everyone, welcome to my PostgreSQL Tutorial for Beginner. Today, we are going to show you how to install PostgreSQL 10.4 on Ubuntu 18.04. You can also follow this guide to install PostgreSQL 10.4 on other distribution such as Deepin 15.6 as well as Linux Mint 19. PostgreSQL is a robust and powerful Relational Database Management System. We are going to use the installer from EnterpriseDB, which is very easy to setup on Linux.
We are trying to present this article as simple as we can. We hope step by step guide to install PostgreSQL 10.4 on Ubuntu is useful for anyone who wants to learn PostgreSQL. At this time, the PostgreSQL latest stable version is 10.4. It comes with many great features and performance improvements.
Steps to install PostgreSQL 10.4 on Ubuntu 18.04
Step 1. Download the binary
To get started, download the PostgreSQL installer from EnterpriseDB website. Select the appropriate version that matches with your current system.
You will have a file called something like this: postgresql-10.4-1-linux-x64.run.
Step 2. Make the file executable
We need to make the file executable so we can install it. Open Terminal and cd to your download directory. For example, I put the file under /tmp folder.
cd /tmp sudo chmod +x postgresql-10.4-1-linux-x64.run
Now install with this command
Step 3. Follow the installation wizard GUI
After the command, the GUI installer will come up. Simply follow the wizard by providing some essential stuff.
You can also opt to install PgAdmin software to manage the PostgreSQL server.
That’s it, now we have successfully installed PostgreSQL 10.4 on Ubuntu 18.04 including PgAdmin 4. Thanks for reading this article and see you on the next PostgreSQL Tutorials.