Unlock instant, AI-driven research and patent intelligence for your innovation.

How to quickly restore postgresql to any point in time

A technology for quick recovery at any point in time. It is applied to the generation of response errors, the error detection of redundant data in operations, and the application of special data processing. It can solve problems such as the inability to achieve fast recovery of PostgreSQL to any point in time. To achieve the effect of reducing space occupation and saving space

Active Publication Date: 2017-09-29
深圳翰飞网络科技有限公司
View PDF1 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a method for PostgreSQL to quickly recover to any point in time in order to solve the problem that the current technical solution cannot realize the fast recovery of PostgreSQL to any point in time

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • How to quickly restore postgresql to any point in time
  • How to quickly restore postgresql to any point in time

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0041] A method for PostgreSQL to quickly recover to any point in time (see attached figure 1 And attached figure 2 ), including XLOG archive file storage steps, production database implementation steps, data file backup storage steps, database STANDBY steps and monitoring steps,

[0042] The XLOG archive file storage steps include:

[0043] XLOG archive file storage Step 1: configure the network, firewall, hardware server, allow the production database and data file backup host to connect to the NFS interface,

[0044] XLOG archive file storage step 2: configure the zfs storage pool, add several hard disks to the zfs storage pool, configure the redundancy mechanism, and ensure that the part of the block device can continue to work.

[0045] XLOG archive file storage Step 3: Create a zfs volume according to the above steps, and configure the corresponding compression properties,

[0046] XLOG archive file storage step 4: configure NFS, allow the production database and dat...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a method for quickly restoring PostgreSQL to any point in time. The problem that the prior art cannot be backed up quickly in real time is solved, and the technical scheme includes the steps of storing XLOG archive files, implementing steps of production database, steps of backing up and storing data files, steps of database STANDBY and monitoring. 1. Use stream replication for backup to solve the problem of a large number of reads generated when data files are backed up. Therefore, the data file backup does not need to read the database file, but only needs to read the xlog or xlog archive file. 2. Utilize incremental backup at the file block level to solve the problem of data file backup capacity requirements brought about by repeated backup of data files. Snapshots will not generate duplicate data, so it is very space-saving. 3. Use the file system cloning technology to clone the backup set, which only generates incremental data, so it solves the extra capacity requirement for data restoration, and the original backup set can continue to be used.

Description

technical field [0001] The invention relates to a data storage method, in particular to a method for fast recovery of PostgreSQL to any point in time. Background technique [0002] There are two methods for existing PostgreSQL database backup, logical backup and data file backup plus archive file backup. Defects of logical backup: 1. Incremental backup cannot be done. For example, after a table is backed up once, if part of the data is changed, the next logical backup needs to be fully backed up. 2 Backup needs to open a repeatable read isolation level transaction. During the backup period, if the existing data is updated or deleted by other sessions, the garbage data generated cannot be recycled. Therefore, the longer the backup time, the more the database will expand. 3 When data is restored, it can only be restored to the point in time of the backup, not to the point in time when the failure occurred. So some data generated after backup will be lost. 4 The restore time...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F11/14G06F17/30
Inventor 周正中
Owner 深圳翰飞网络科技有限公司