From: | apoc9009 <apoc9009(at)yahoo(dot)de> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC) |
Date: | 2007-09-07 10:20:38 |
Message-ID: | 46E125F6.6020602@yahoo.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Trevor Talbot schrieb:
>> Backup 12/24/2008 Version 2
>> /pg/backup/12_24_2008/base/rcvry.rcv <--- Basebackup
>> /pg/backup/12_24_2008/changes/0001.chg <--- Changed Data
>> /changes/0002.chg <--- Changed Data
>> /changes/0003.chg <--- Changed Data
>> ....
>> /changes/0010.chg <--- Changed Data
>> /changes/0001.rsf <--- Recovery
>>
>> Stripeset File (10 MByte) addon of Basebackup
>> delete *.chg
>>
>> if a Stripeset of 10 *.chg Files exist, they should be converted or merged
>> to one bigger *.rsf Stripesetfile (to prevent for having Millions *.chg)
>>
>>
>> Why? What does this actually do?
This is the Structure on FTP-Site of the Backupserver! Not locally where
the Postmaster runs on!
Locally the Postmaster can create a basebackup (rcvry.rcv) then the
FTP-Deamon logs on to the
Remote FTP-Backupserver and Uploads this File to keep it save:
/pg/backup/12_24_2008/
/pg/backup/12_24_2008/base/rcvry.rcv <--- Basebackup
At the Next:
If a New Record at the Database was written, then the Postmaster locally
creates
A change File named: "0001.chg"
After thits the locally FTP-Deamon transfers this File to
/pg/backup/12_24_2008/changes/0001.chg <--- Changed Data
Then
/pg/backup/12_24_2008/changes/0002.chg <--- Changed Data
/pg/backup/12_24_2008/changes/0003.chg <--- Changed Data
....
/pg/backup/12_24_2008/changes/0010.chg <--- Changed Data
Then the FTP-Backupdeamon merged the last 10.x *.chg Files to one greater
*.RSF File "Online while logged into the FTP-Backupserver" and Delete Online
the Last 10 *.chg Files (after this the Last 10.x *.chg Files, created
by the Postmaster
can be deleted localy where the Postmaster runs).
The Benefit:
If the Machine where the Database run on having a Mailfunction, then the
Last Record
of the Databasecatalouge is backed up to an *.chg or *. RSF File.
Thadt my Idea of this
Apoc
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2007-09-07 10:24:55 | Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC) |
Previous Message | Simon Riggs | 2007-09-07 10:03:43 | Re: Just-in-time Background Writer Patch+Test Results |