A Novel Recovery Process in Timelagged Server using Point in Time Recovery (PITR)

Abstract

Management of data backup and restore in case of emergency is a crucial process in every organization. This paper discusses an effective database recovery technique called Point In Time Recovery (PITR) in postgreSQL database management system. Despite emerging big data technology, relational database management system (RDBMS) is still performing the key role for storing and processing of data in most of the organizations. Almost all kinds of financial organizations like banks and mobile financial service (MFS) organizations use RDBMS as their database tool for storing their users information and all kinds of transactional information related to that organization. Nowadays those type of organizations focus on customer acquisition strategy and thus data is growing rapidly. In spite of proper system management system crash is not very uncommon while processing large volumes of data. It results loss of data and a huge financial loss for the organization. To tackle such tragedy for the business a proper data recovery system is required for every organization. Generally organizations use backup using pg_dump command and restore using pg_restore but this traditional recovery system cannot restore the data which is created or altered after the backup taken. Also this process is time inefficient because this process reconstruct the database to the state of the last dump file. Thus our research paper implements a potent process of data recovery technique in postgreSQL that can recover all data which is created or altered after the backup taken. Again this process is time efficient because it works restoring using Write Ahead log (WAL) file from the base backup.