Managing PostgreSQL databases through a graphical interface rather than the command line can significantly streamline database operations. phpPgAdmin, much like its MySQL counterpart phpMyAdmin, offers a web-based management tool for PostgreSQL databases. This guide will walk you through the process of installing phpPgAdmin on an Ubuntu system, providing you with a user-friendly interface for managing your PostgreSQL databases. Prerequisites A server running Ubuntu (the steps should be applicable for most recent versions of Ubuntu). You should have PostgreSQL installed on your system. If not, you’ll need to install it before proceeding. sudo privileges to execute administrative commands. Step 1: Update…
Author: Rahul
Vim is a popular text editor that is widely used by programmers, developers, and system administrators. It is a highly customizable and powerful editor that has a steep learning curve, but once mastered, it can significantly improve your productivity. In this article, we’ll discuss some essential Vim save and quit shortcuts that every Vim user should know to help speed up their workflow. Quick Details Here are some quick details on saving and quitting in Vim. Remember to press Esc to ensure that you are in normal mode before entering any commands. With these basic commands, you’ll be able to…
Security of data always have in top of priorities for systems administrator’s. Systems admin’s always tries to keep all the ports close for public used which is not required. But some times we are in require to allow some of our external users or clients to server via remote login. In that case we need to open firewall ports. Generally we use IP addresses to allow/deny a client via iptables, but it’s not necessary that each client has static ip on their side. In that case its hard to open port time to time for their ips. In this situation…
WordPress is the most popular content management system. Its created with PHP programming language and uses MySQL as the backend database. This article will help you to install latest WordPress on LAMP environment on CentOS, RHEL & Fedora systems. For this tutorial, we assume that you already have LAMP setup on your system. If you do not have LAMP setup use below article to install it. Setup LAMP Stack on CentOS, RHEL and Fedora Step 1 – Download Latest WordPress These latest version of WordPress are always available here (.tar.gz) and here (.zip). You can download any files to your…
When you access a website, your browser sends a request to the webserver to load the page. The web server responds by sending back the requested content, and then the connection between the browser and the server is closed. However, if your browser needs to load additional resources (such as images, stylesheets, or JavaScript files), it has to open a new connection to the server for each resource. This can cause delays in loading the page and increase the load on the server. To avoid this problem, Apache provides a feature called KeepAlive, which allows the browser to keep the…
If you manage a network with more than a few devices, you need monitoring software to keep tabs on all of them. Nagios is a leading open-source monitoring solution that alerts you when something goes wrong and gives detailed information when something needs your attention. This article covers how to monitor remote Linux hosts with Nagios. If you don’t have much experience with network monitoring or systems administration, you may find some of the jargon in this article difficult to understand. But don’t worry—we’ll explain everything that you need to know about monitoring software, remote hosts, and Linux servers. By…
MariaDB Galera Cluster 10.0.12 Stable has been released and available for production use. MariaDB is a relational database management system (RDBMS). Generally we use single node of database server for small application but think about application which have thousands of users keep online at a time, In that situation we need a structure which will capable to handle this load and provides high availability. So we need to add multiple database servers interconnected with each other and keep synchronized, so in case any server goes down other servers can take place of them and provide services to users. This article…
While we are learning about RAID devices, Generally we used smaller disks to build a RAID array. In that time when any raid disk failed and we replaced it with a new disk. Then raid rebuilding takes a few minutes or seconds only. But think about if you are running a high storage capacity server or any backup drives which are having raid configured in size of multiple terabytes and you need to rebuild RAID or rebuilding started due to some issues. It takes a lot of time and we run keep running `cat /proc/mdstat` time to time for checking…
Firstly, make sure you have installed Nagios core service. Else use our previous articles for installation steps of Nagios core service on Redhat based systems or Debian based system. Now read this article to install NagiosQL3 web interface for Administration of Nagios server using web interface. If you have installed Nagios core service with some other type. Please be careful with directories and files path and configuration files. We have successfully configured and integrated NagiosQL with Nagios using below steps. But we can not sure that it will 100% work for you. You may get few errors during setup. Feel…
Warning – Ruby 1.9 is reached to end of life and no more maintained. Kindly use below tutorials to install latest version of ruby Current stable – Install Ruby Latest Stable Release Previous stable – Install Ruby Previous Stable Release Ruby programming language is becoming is more popular these days. Ruby language was created by Yukihiro “Matz” Matsumoto and first published in 1995. This article will help you to install Ruby language in CentOS, RedHat system using RVM. For this article I am using CentOS 6.5. RVM provides easy set of commands to install single or multiple versions of Ruby…