CN104503865B - PostgreSQL快速恢复到任意时间点的方法 - Google Patents
PostgreSQL快速恢复到任意时间点的方法 Download PDFInfo
- Publication number
- CN104503865B CN104503865B CN201410754052.8A CN201410754052A CN104503865B CN 104503865 B CN104503865 B CN 104503865B CN 201410754052 A CN201410754052 A CN 201410754052A CN 104503865 B CN104503865 B CN 104503865B
- Authority
- CN
- China
- Prior art keywords
- monitoring
- xlog
- backup
- database
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (4)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410754052.8A CN104503865B (zh) | 2014-12-10 | 2014-12-10 | PostgreSQL快速恢复到任意时间点的方法 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201410754052.8A CN104503865B (zh) | 2014-12-10 | 2014-12-10 | PostgreSQL快速恢复到任意时间点的方法 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104503865A CN104503865A (zh) | 2015-04-08 |
CN104503865B true CN104503865B (zh) | 2017-09-29 |
Family
ID=52945265
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201410754052.8A Active CN104503865B (zh) | 2014-12-10 | 2014-12-10 | PostgreSQL快速恢复到任意时间点的方法 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104503865B (zh) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105138417B (zh) * | 2015-07-10 | 2018-07-20 | 上海爱数信息技术股份有限公司 | 一种基于zfs send的异步复制方法 |
CN107908755A (zh) * | 2017-11-21 | 2018-04-13 | 郑州云海信息技术有限公司 | 一种快照文件处理方法及装置 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7412460B2 (en) * | 2003-06-19 | 2008-08-12 | International Business Machines Corporation | DBMS backup without suspending updates and corresponding recovery using separately stored log and data files |
CN102096613A (zh) * | 2010-12-30 | 2011-06-15 | 上海爱数软件有限公司 | 一种生成快照的方法及装置 |
CN102591982A (zh) * | 2011-01-07 | 2012-07-18 | 赛门铁克公司 | 执行增量sql服务器数据库备份的方法和系统 |
CN102708158A (zh) * | 2012-04-23 | 2012-10-03 | 杭州梵艺科技有限公司 | 一种PostgreSQL云存储归档调度系统 |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8433682B2 (en) * | 2009-12-31 | 2013-04-30 | Commvault Systems, Inc. | Systems and methods for analyzing snapshots |
-
2014
- 2014-12-10 CN CN201410754052.8A patent/CN104503865B/zh active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7412460B2 (en) * | 2003-06-19 | 2008-08-12 | International Business Machines Corporation | DBMS backup without suspending updates and corresponding recovery using separately stored log and data files |
CN102096613A (zh) * | 2010-12-30 | 2011-06-15 | 上海爱数软件有限公司 | 一种生成快照的方法及装置 |
CN102591982A (zh) * | 2011-01-07 | 2012-07-18 | 赛门铁克公司 | 执行增量sql服务器数据库备份的方法和系统 |
CN102708158A (zh) * | 2012-04-23 | 2012-10-03 | 杭州梵艺科技有限公司 | 一种PostgreSQL云存储归档调度系统 |
Also Published As
Publication number | Publication date |
---|---|
CN104503865A (zh) | 2015-04-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10503616B2 (en) | Periodic data replication | |
CN108376109B (zh) | 将来源阵列的卷复制到目标阵列的设备和方法、存储介质 | |
US20200293551A1 (en) | Data Replication Method and Storage System | |
US7809691B1 (en) | System and method of applying incremental changes prior to initialization of a point-in-time copy | |
US9658928B2 (en) | File-based cluster-to-cluster replication recovery | |
US11138156B2 (en) | Continuous data management system and operating method thereof | |
WO2018098972A1 (zh) | 一种日志恢复方法、存储装置和存储节点 | |
CN105302667B (zh) | 基于集群架构的高可靠性数据备份与恢复方法 | |
US20100198791A1 (en) | System, method, and computer program product for allowing access to backup data | |
CN105955836A (zh) | 一种冷热备份自动演练多功能系统 | |
TW201403452A (zh) | 遠端非同步資料卷複製的方法及其裝置 | |
CN105069160A (zh) | 一种基于自主可控数据库的高可用性方法及构架 | |
CN102368267A (zh) | 一种维护分布式系统中副本一致性的方法 | |
US11397749B2 (en) | Asynchronous replication of in-scope table data | |
US9619322B2 (en) | Erasure-coding extents in an append-only storage system | |
CN107046811A (zh) | 一种源存储设备发送源文件和源文件的克隆文件至备份存储设备的方法、源存储设备以及备份存储设备 | |
CN104503865B (zh) | PostgreSQL快速恢复到任意时间点的方法 | |
KR101254179B1 (ko) | 분산 파일 시스템에서 효율적인 자료 복구 방법 | |
US9286163B2 (en) | Data recovery scheme based on data backup status | |
Schönig | PostgreSQL Replication | |
CN103412802B (zh) | 容灾数据文件访问控制列表备份的方法及装置 | |
JP2017142664A (ja) | データ処理装置、データ処理システム、データ処理方法及びデータ処理プログラム | |
KR102089710B1 (ko) | 연속 데이터 관리 시스템 및 방법 | |
WO2021208401A1 (zh) | 现代应用的持续数据保护系统及方法 | |
US9607000B1 (en) | Backup to tape-out using common backup data storage |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP02 | Change in the address of a patent holder |
Address after: 310000 room 821, building 1, Xinjun building, 330 Internet of things street, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province Patentee after: Hangzhou Sky-mobi Technology Co., Ltd. Address before: 10, 310013, The Union Buildings, No. 2, Bauhinia Road, Hangzhou, Zhejiang, Xihu District Patentee before: Hangzhou Sky-mobi Technology Co., Ltd. |
|
CP02 | Change in the address of a patent holder | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210420 Address after: No. 181, erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee after: Chen Ximei Address before: 310000 room 821, building 1, Xinjun building, 330 Internet of things street, Xixing street, Binjiang District, Hangzhou City, Zhejiang Province Patentee before: HANGZHOU SKY NETWORK TECHNOLOGY Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210706 Address after: 21f-a, Shenmao business center, 59 Xinwen Road, Meiling community, Lianhua street, Futian District, Shenzhen, Guangdong 518000 Patentee after: Shenzhen Hanfei Network Technology Co.,Ltd. Address before: 355200 no.181 erbatou, taimuyang village, Qinyu Town, Fuding City, Ningde City, Fujian Province Patentee before: Chen Ximei |
|
TR01 | Transfer of patent right |