{"id":2064,"date":"2024-04-22T05:58:57","date_gmt":"2024-01-30T19:37:26","guid":{"rendered":""},"modified":"2025-02-02T00:46:18","modified_gmt":"2025-02-01T23:46:18","slug":"how-to-install-pghero-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-pghero-on-ubuntu-22-04\/","title":{"rendered":"Linux VPS & VPS Windows Setup Guide | NetCloud24 PgHero on Ubuntu 22.04"},"content":{"rendered":"

\u00a0<\/p>\n<\/p>\n

\n

\u00a0<\/h1>\n<\/header>\n
\n

PgHero<\/strong> is a powerful tool for monitoring PostgreSQL databases, providing insights into slow queries, index usage, cache hit rates, and more. In this guide, we will show you how to install PgHero on Ubuntu 22.04<\/strong> to monitor your PostgreSQL databases efficiently. Hosting your database on a ensures optimal performance and scalability, thanks to the dedicated resources of a VPS server<\/strong>.<\/p>\n

Step 1: Update Your VPS Server<\/h2>\n

Before installing PgHero, make sure your VPS server<\/a> is up to date. Run the following commands to update the system:<\/p>\n

sudo apt update && sudo apt upgrade -y<\/code><\/pre>\n
By hosting your PostgreSQL and PgHero setup on a Windows VPS<\/strong>, you gain better performance, allowing you to monitor and optimize your database with greater efficiency.<\/p>\n
Step 2: Install PostgreSQL<\/h2>\n
If you haven’t already installed PostgreSQL on your server, you can do so with the following command:<\/p>\n
sudo apt install postgresql postgresql-contrib -y<\/code><\/pre>\n
Once installed, PostgreSQL will start automatically. You can verify that it\u2019s running using:<\/p>\n
sudo systemctl status postgresql<\/code><\/pre>\n
Step 3: Install PgHero<\/h2>\n
Next, we will install PgHero. First, you need to install Ruby and other dependencies. Run the following commands:<\/p>\n
sudo apt install ruby-full -y<\/code><\/pre>\n
Now, install the PgHero gem:<\/p>\n
sudo gem install pghero<\/code><\/pre>\n
Step 4: Set Up PgHero with PostgreSQL<\/h2>\n
After installing PgHero, you need to configure it with your PostgreSQL database. First, switch to the PostgreSQL user:<\/p>\n
sudo -i -u postgres<\/code><\/pre>\n
Then, access the PostgreSQL shell:<\/p>\n
psql<\/code><\/pre>\n
In the shell, create the pghero<\/code> extension on your database:<\/p>\n
\r\nCREATE EXTENSION pghero;\r\n\\q\r\n<\/code><\/pre>\n
This will install the PgHero extension on your PostgreSQL database.<\/p>\n
Step 5: Set Up PgHero Web Interface<\/h2>\n
To access PgHero via a web interface, you need to configure it to run as a web application. First, install a web server like Puma<\/strong> to run the PgHero web interface. Install Puma by running:<\/p>\n
sudo gem install puma<\/code><\/pre>\n
Create a new directory for PgHero and navigate into it:<\/p>\n
\r\nmkdir ~\/pghero_app && cd ~\/pghero_app\r\n<\/code><\/pre>\n
Create a basic configuration file for PgHero:<\/p>\n
nano config.ru<\/code><\/pre>\n
Add the following content to the file:<\/p>\n
\r\nrequire \"pghero\"\r\nrun PgHero::App\r\n<\/code><\/pre>\n
Start the PgHero web interface using Puma:<\/p>\n
puma -p 8080<\/code><\/pre>\n
You can now access the PgHero interface by visiting http:\/\/your-server-ip:8080<\/code> in your browser.<\/p>\n
Step 6: Set Up Systemd Service for PgHero<\/h2>\n
To keep PgHero running as a background service, it\u2019s best to create a Systemd service. Create a service file by running:<\/p>\n
sudo nano \/etc\/systemd\/system\/pghero.service<\/code><\/pre>\n
Add the following content to the file:<\/p>\n
\r\n[Unit]\r\nDescription=PgHero Monitoring Tool\r\nAfter=network.target\r\n\r\n[Service]\r\nUser=your-username\r\nWorkingDirectory=\/home\/your-username\/pghero_app\r\nExecStart=\/usr\/local\/bin\/puma -p 8080\r\nRestart=always\r\n\r\n[Install]\r\nWantedBy=multi-user.target\r\n<\/code><\/pre>\n
Save the file, then reload Systemd and start the PgHero service:<\/p>\n
\r\nsudo systemctl daemon-reload\r\nsudo systemctl start pghero\r\nsudo systemctl enable pghero\r\n<\/code><\/pre>\n
Step 7: Access PgHero<\/h2>\n
After setting up the service, PgHero will run continuously, and you can access it by visiting http:\/\/your-server-ip:8080<\/code>. From the web interface, you can monitor slow queries, index usage, cache hit rates, and more.<\/p>\n
Step 8: Optimize Your VPS Server for PgHero<\/h2>\n
To ensure the best performance for monitoring and optimizing your PostgreSQL database, hosting PgHero on a  is highly recommended. A VPS server<\/strong> provides dedicated resources such as CPU, memory, and storage, which are essential for handling large databases and ensuring that PgHero delivers real-time insights into your database performance.<\/p>\n
Conclusion<\/h2>\n
Installing PgHero on Ubuntu 22.04 allows you to monitor and optimize your PostgreSQL database with ease. By hosting your PostgreSQL and PgHero setup on a , you can take full advantage of dedicated resources, ensuring that your database performs optimally even under heavy workloads.<\/p>\n
For more information about VPS hosting and optimizing your PostgreSQL database with PgHero, visit  today.<\/p>\n<\/article>\n