If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Other > EnterpriseDB archiving

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-09-08, 17:28
fishhead fishhead is offline
Registered User
 
Join Date: Jun 2008
Posts: 1
EnterpriseDB archiving

I've read through the documentation but I still am not sure on how it works or what to do. I read everything about it under the "Backup and Restore" section of Enterprisedb documentation. I have this 64mb files that fill my my directory. Can I just remove the old ones that are more than 3 days old or will this cause the archiving to be corrupt?
Reply With Quote
  #2 (permalink)  
Old 06-10-08, 16:33
loquin loquin is offline
Super Moderator
 
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,797
EnterpriseDB is layered atop Postgresql. As I understand it, EnterpriseDB uses Slony in at least one of their replication approaches. These files sound like they may be the Slony write history files, which are used to store a complete history of all changes to the database. Depending upon replication subscriber update frequency and history write rate, three days might be fine, but then again, it may not. All replication subscribers must be 'done' with a write history file before you can archive it.

Normally, whenever a complete backup is made, you would start with a fresh set of write history files.
__________________
Lou
使大吃一惊
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Last edited by loquin; 06-10-08 at 16:37.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On