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 export Exporting PostgreSQL database to a file by using the pg_dump command line program pg_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