Welcome to Manjaro Tutorial. Today we are going to show you how to install PostgreSQL Server on Manjaro 18.0. This is why I love Manjaro. Installing software or package in Manjaro Linux is super easy. I have been using PostgreSQL for sometimes together with MySQL. I mostly use the PostgreSQL to store my spatial database with the help of PostGIS extension. PostgreSQL supports many operating systems including Linux. And specifically, it can be installed on Manjaro in a few simple steps.
Homebrew Install Pgadmin
By the time I write this article, the latest version of PostgreSQL 10.5 is available in the Manjaro repository. So, let’s jump into the installation step.
Open Terminal and type this command
Pgadmin Homebrew Guide
After the installation finishes, continue with the following command
Now start the server
PgAdmin 4; Postico; pgAdmin 4 is a feature rich open source PostgreSQL client. It has support for almost every feature in PostgreSQL. The only downside is that the cross-plattform UI really doesn’t live up to the expectations of a native Mac app. Postico on the other hand, is a very modern Mac app. It’s made by the same people that maintain. MacOS with Homebrew. We recommend Homebrew as a package manager for macOS. With Homebrew in place you'll be able to install numerous applications, usually with the programs available in /usr/local/bin. Homebrew's package for the PostgreSQL client tools is the libpq package. Brew makes it easy to install: brew install libpq. Jun 15, 2018 For me, using Homebrew to manage my activity in postgres was the way to go, but I also wanted to be able to go into the pgAdmin GUI and get a comprehensive overview of my database activity. Hope this helps, and happy pgAdmining! Related Resources: How to uninstall postgreSQL on OSX and reinstall with Homebrew. The Unauthorized message indicates a successful HTTP connection as it is read from the HTTP server. It appears when you don’t have the right authorization cookie. When pgAdmin 4 is run in desktop mode, you have to right-click on its tray icon and select New pgAdmin 4 window. For me, using Homebrew to manage my activity in postgres was the way to go, but I also wanted to be able to go into the pgAdmin GUI and get a comprehensive overview of my database activity. Hope this helps, and happy pgAdmining! Related Resources: How to uninstall postgreSQL on OSX and reinstall with Homebrew.
That’s it. Now the PostgreSQL Server is up and running on our Manjaro system.
PgAdmin is a web-based PostgreSQL management console. It is not mandatory to install PgAdmin but if you need a GUI tool to manage your server, then PgAdmin is a good one.
Next, open PgAdmin from the Manjaro application launcher. We need to connect our PostgreSQL Server with this PgAdmin
Pgadmin Homebrew App
Thanks for reading this post and do not forget to share it with the world.