On Jan 3, 2008 2:27 AM, Martin Langhoff <[EMAIL PROTECTED]> wrote: > Is it possible to segregate the PITR data by database at any stage? We are
i don't think so. My guess is that at snapshot time, I could use oid2name to focus on the > database I'm interested in plus core Pg data structures, can you eleborate on this , how do you plan to use oid2name exactly? Background: The goal here is to have a "web application rewind" > facility, based on PITR, that allows a webapp administrator to say > "please rewind my Moodle/Drupal/Whatever" to arbitrary point in time X, > where X is in the last Y days, via a web UI. It is normally configured > to rewind not the master, but a secondary install of your web app -- > although there's some interest in rewinding the master too for training > and software testing purposes. not sure if the postgres PITR is designed for this kind of facility like that, i would think you will have to incorporate such facility into your application/ database design -- Usama Munir Dar http://www.linkedin.com/in/usamadar Consultant Architect Cell:+92 321 5020666 Skype: usamadar
