Mon Feb 11 05:43:36 PST 2008
- Previous message: [Slony1-general] recovery approaches using slony
- Next message: [Slony1-general] stop/restarting postmaster on replication machine
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I've noted that our restore procedure is flawed now that we've started replicating our data. Apparently our backup procedure picks up a schema in our primary node that was created by slony. Thus, when I attempted to restore into a database that had a schema created prior to our slony implementation, I received an error because the backup data contained the slony created schema and the empty database I was attempting to load did not. Question is, what is the best solution here? Should I permit the restore to include the slony schema? What do other folks do in this situation? My next question is, did the restore exit when it encountered this error, or did it complete? I'm not sure if it might be the case that the slony schema would be restored after the rest of the database. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
- Previous message: [Slony1-general] recovery approaches using slony
- Next message: [Slony1-general] stop/restarting postmaster on replication machine
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list