Cisco Server Provisioner 6.6 User's Guide ("Chuck Berry")

Database Backup and Restore

Hide Navigation Pane

Database Backup and Restore

Previous topic Next topic No expanding text in this topic  

Database Backup and Restore

Previous topic Next topic JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

The database contains:

MAC-Specific Provisioning Roles

MAC-Specific Provisioning Role Templates

MAC-Independent Provisioning Roles

MAC-Specific Imaging Roles

 

The database does not contain files necessary to provision or image individual systems. See After Restoring the Database.

 

A database backup is made automatically on a daily basis and the the backups are located in:

/usr/local/linmin/pgDBbkup/

 

The daily backup is then compared to the prior backup, and if no changes to the database have been made, the newer backup will be overwritten during a subsequent backup when the database contents change.

 

 

Backup the Database

 

# cd /usr/local/linmin/

# ./lbmpPostgresBackup.sh

...checking for difference since last backup

...diff returned:1

Changes have been made since last backup check, backup taken:

... pg_dump_bkp.20100915-122433

#

 

 

Restore the Database

 

Before restoring a database:

End all GUI sessions

Ensure that no provisioning or imaging events are underway

 

# cd /usr/local/linmin/pgDBbkup/

# ./linmin-bmp-PostgresRestore.sh

Postgres Restore

 

Selecting the 'restore' option will stop LinMin services,

... services will be restarted after the DB restore is completed.

Key 'restore' then Enter to continue or Enter to exit: restore

 

...existing backups:

-rw-r--r-- 1 0 0  2608 Sep  4 05:47 pg_dump_bkp.20100904-054717

-rw-r--r-- 1 0 0 19042 Sep  8 07:54 pg_dump_bkp.20100908-075443

-rw-r--r-- 1 0 0 85913 Sep 10  2010 pg_dump_bkp.20100910-128414

-rw-r--r-- 1 0 0 86104 Sep 15  2010 pg_dump_bkp.20100915-122433

 

Enter backup to restore: pg_dump_bkp.20100915-122433

 

Restore from: pg_dump_bkp.20100915-122433

... create current backup if needed...

...checking for difference since last backup

Changes have been made since last backup check, backup taken:

... pg_dump_bkp.20100908-083010

Backup taken

Restore of pg_dump_bkp.20100915-122433 successful

Provisioning service is running OK

#

 

 

After Restoring the Database

 

After the successful restore of the database, you must use the GUI or API to:

Toggle the MAC-Specific Provisioning Roles (for example, from Ignore to Next Boot)

Toggle the MAC-Specific Imaging Roles (for example, from Reset to Backup)

 

This is required to generate the files required to enable provisioning and imaging functions on specific systems.