How To Install Pghero on Ubuntu 16.04 LTS

Install Pghero on Ubuntu 16.04

In this tutorial, we will show you how to install Pghero on Ubuntu 16.04 LTS. For those of you who didn’t know, PgHero is a performance dashboard for Postgres – health checks suggested indexes, and more. PgHero 2.0 provides, even more, insight into your database performance with two additional features: query details and space stats. PgHero makes it easy to see the most time-consuming queries during a given time period.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you through the step-by-step installation of Pghero on an Ubuntu 16.04 Xenial Xerus server.


  • A server running one of the following operating systems: Ubuntu 16.04, and any other Debian-based distribution like Linux Mint or elementary OS.
  • It’s recommended that you use a fresh OS install to prevent any potential issues
  • An active internet connection. You’ll need an internet connection to download the necessary packages and dependencies.
  • A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install Pghero on Ubuntu 16.04 LTS

Step 1. First, make sure that all your system packages are up-to-date by running the following apt-get commands in the terminal.

sudo apt-get update
sudo apt-get upgrade

Step 2. Installing Pghero.

First, create pghero repo file and add pghero repo url:

wget -qO- | sudo apt-key add -
sudo wget -O /etc/apt/sources.list.d/pghero.list \

Install Pghero from the terminal using the following command:

sudo apt-get update
sudo apt-get -y install pghero

Step 3. Configure Pghero.

We adding my local Postgres database in pghero. You need to replace the user, password, port, hostname, and database name with yours:

pghero config:set DATABASE_URL=postgres://user:password@hostname:5432/dbname
### pghero config:set DATABASE_URL=postgres://chedelics:idroot@localhost:5432/postgres ###

Start the pghero server:

sudo pghero config:set PORT=3001
sudo pghero config:set RAILS_LOG_TO_STDOUT=disabled
sudo pghero scale web=1

Use the following commands to manage the pghero:

sudo systemctl status pghero
sudo systemctl start pghero
sudo systemctl stop pghero
sudo systemctl restart pghero

Step 4. Accessing Pghero Web UI.

Now we have started the pghero server let’s check the dashboard. Go to IP address of your server and port 3001.

curl -v http://localhost:3001/

Install Pghero on Ubuntu 16.04 LTS

Congratulations! You have successfully installed Pghero. Thanks for using this tutorial for installing Pghero on your Ubuntu 16.04 system. For additional help or useful information, we recommend you check the official Pghero website.

VPS Manage Service Offer
If you don’t have time to do all of this stuff, or if this is not your area of expertise, we offer a service to do “VPS Manage Service Offer”, starting from $10 (Paypal payment). Please contact us to get the best deal!



r00t is a seasoned Linux system administrator with a wealth of experience in the field. Known for his contributions to, r00t has authored numerous tutorials and guides, helping users navigate the complexities of Linux systems. His expertise spans across various Linux distributions, including Ubuntu, CentOS, and Debian. r00t's work is characterized by his ability to simplify complex concepts, making Linux more accessible to users of all skill levels. His dedication to the Linux community and his commitment to sharing knowledge makes him a respected figure in the field.
Back to top button