Hi Everyone,
I'm having some problems trying to restore a database server from a backup.
Sequoia 2.10.2
Postgres backends - "db_primary", "db_backup" and "recovery"
After reading the User's Guide and the Management Guide for 2.10 I used the
following procedure for restoring a database server from a previous backup
at the console:
1. Go to admin mode for the virtual database
> admin <virtual-db>
> expert on
2. Backup the backend "db_backup",
> backup db_backup dbbackupfile PostgreSQL <path to backup file>
(PostgreSQL is the name of my Postgres backuper as declared in my
virtual db configuration file - I'm using the PostgreSQL Binary Dump
backuper).
3. After a while (with a number of transactions having passed through the
controller), I then try to restore my backup
> disable *
> show dumps
(I copy the Checkpoint name <checkpt-name> corresponding to the backup
I did from the results of show dumps and use it in the next step)
> force checkpoint db_primary <checkpt-name>
> force checkpoint db_backup <checkpt-name>
(I do this to set the last know checkpoint to that when I did the
backup)
> restore backend db_primary dbbackupfile
> restore backend db_backup dbbackupfile
> enable *
(to enable from the last know checkpoint, ie my backup)
I've set log4j logging at DEBUG for everything and can see in the
full_cluster.log log file that all commands entered have been successful (as
reported in full_cluster.log), including the recovery of both backends (I
can see the "recovering write request" and "commit transaction n" occurring
for both backends).
The problem is that I can't see the updates that have occurred during
recovery (ie between my backup and to the point just before the restore) in
the backends themselves (db_primary and db_backup). Is my procedure correct?
Have I missed something?
Many thanks in advance,
Ken
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
