Install MariaDB in Linux Server

By | 2018-08-07T14:54:13+00:00 December 13th, 2016|

In this tutorial, we can learn how to install MariaDB in a Linux Server. A relational database is a mechanism that allows the persistence of a data in an organize way. Databases store data items, organize as a set of tables with each table representing an entity. There are two types of relational database packages. [...]

Steps to Install and Configure PostgreSQL in cPanel

By | 2018-08-10T12:23:59+00:00 September 22nd, 2016|

How to Install and Configure PostgreSQL PostgreSQL is a general purpose database management system developed based on POSTGRES 4.2. PostgreSQL was designed to run on various platforms such as Solaris, Windows etc. It is a free and open source software that gives us the ability to modify PostgreSQL in any form. Early on, PostgreSQL was [...]

How to Export and Import Postgresql Database

By | 2018-08-10T08:46:32+00:00 September 22nd, 2016|

PostgreSQL is a powerful, open source object-relational database system and it provides strong reputation for reliability, data integrity, and correctness. PostgreSQL runs operating systems such as Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.   PostgreSQL database export Exporting PostgreSQL database to a file by using the pg_dump command [...]

Installing PgBouncer and it’s Features

By | 2016-09-22T17:28:43+00:00 September 22nd, 2016|

PgBouncer is a lightweight PostgreSQL connection pooler. PgBouncer is used to lower the performance impact of opening new connections to PostgreSQL. It is a lightweight connection pooler for Postgres and it reduces the processing time and resources for maintaining a large number of client connections to one or more databases. PgBouncer is a pre-bundled enterprise [...]