Databases

There are a number of front-end tools available for connecting to, and working with, the PostgreSQL database. Among the most popular are psql, a command-line tool for querying the database,…

PgAdmin 4 is a rewrite of the popular pgAdmin3 management tool for the PostgreSQL database. PgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL. In…

PgAdmin 4 is a rewrite of the popular pgAdmin3 management tool for the PostgreSQL database. PgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL. In…

After we have installed Zabbix Server on Ubuntu 16.04 LTS. In this article will demonstrate how to use zabbix agent to monitor MySql / Mariadb database Server by collecting data…

PgAdmin 4 is a rewrite of the popular pgAdmin3 management tool for the PostgreSQL database. PgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL. In…

By default, PostgreSQL Server allow access to clients localy using Unix sockets. Here, we’ll show you how to enable the network remote access to PostgreSQL Database Server. If you did…

Let’s suppose that  the  database grows frequently and need more space, the best solution is to relocate the PostgreSQL data directory to a new location. In this article, we will…

PostgreSQL is a powerful object-relational database management system, provided under a flexible BSD-style license. PostgreSQL contains many advanced features, is very fast and standards compliant. PostgreSQL has bindings for many…

Step 1: Add the PostgreSQL 9.6 Repository # sudo yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm -y Step 2: Install PostgreSQL 9.6 – To install PostgreSQL 9.6 just run the below command: # sudo…

Choosing a high-availability solution for MySQL to prevent downtime and data losing, is really one of the important subjects for an IT System Admin to handle. Today, we are going…