• Home » kb
  • Install MariaDB in Linux Server

    Posted at December 13, 2016 at 11:31 am by Jithin

    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. They are listed below.1)PostgreSQL: An open source database developed by the PostgreSQL Global Development Group, consisting of Postgres users (both individual and companies) a   [...]

    Read More

    Steps to Install and Configure PostgreSQL in cPanel

    Posted at September 22, 2016 at 6:03 pm by Jithin

    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 designed to run on UNIX-like platforms  and later it was designed to be portable. Due to it's stability it requires only minimum efforts to manage. The cost of developing web applications using PostgreS   [...]

    Read More

    How to Export and Import Postgresql Database

    Posted at September 22, 2016 at 5:51 pm by Jithin

    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 exportExporting PostgreSQL database to a file by using the pg_dump command line programpg_dump is an effective tool to backup postgres database. pg_dump is used to back up a loca   [...]

    Read More

    Installing PgBouncer and it’s Features

    Posted at September 22, 2016 at 5:28 pm by Jithin

    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 module which increases the number of user connections that can be handled in a high performance environment. If any target application   [...]

    Read More