Project

General

Profile

Actions

Bug #2481

closed

Fix Backup Strategy: where backups go

Added by Michael Lee almost 18 years ago. Updated over 17 years ago.

Status:
Resolved
Priority:
Immediate
Assignee:
Category:
misc
Target version:
Start date:
06/28/2006
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2481

Description

++ This bug was initially created as a clone of Bug #2395 ++

We need to make sure that this backup is not just to VegBank- a copy needs to be distributed, either by email or network to an alternate machine.

Colby needs to do this, or at least help.
/usr/vegbank/backup is where the backups are stored on VegBank, and the latest copy of the database should be backed up to "elsewhere" from time to time. Not sure what that "time to time" really is.


Related issues

Blocks VegBank - Bug #2395: Fix Backup Strategy -- delete extra backups from time to timeResolvedChad Berkley04/05/2006

Actions
Actions #1

Updated by Michael Lee almost 18 years ago

colby emailed 6/28/06 about this.

Actions #2

Updated by Michael Lee almost 18 years ago

colby has responded and backups will be easily done. We should definitely shift our strategy to putting the latest copy into its own directory. Then we can move it out before adding a new one, so that we only get the latest one or two backed up on the main NCEAS server when that happens.

I have updated /vegbank/bin/vbdump in CVS to do this:
--- dir explanation ---
/usr/vegbank/backup -- initial location of backups
/usr/vegbank/oldarchive -- any archives that are not the latest wind up here
/usr/vegbank/latest -- this dir contains the latest backup(s)
/usr/vegbank/latest/to_move -- this dir contains old backups for which a replacement exists, but hasn't been copied into /usr/vegbank/latest yet.

--- what happens ---
The backup initially goes into /usr/vegbank/backup.
Then it moves everything out of latest and into latest/to_move
Then it moves the db into /latest
Then it moves everything out of latest/to_move and into oldarchive

Problems still remaining:
PMark set this up to scp. I can't get it to do this unless I supply a password (in which case it works, but that's not automation)
Postgresql doesn't allow access without a password, either. So Chad, is there a way around that for this script? If it was run as the vegbank user, perhaps we could trust that user for accessing the database if the user is really logged in?

Actions #3

Updated by Michael Lee over 17 years ago

colby has confirmed that this is working. //vegbank/usr/vegbank/backup/latest is being backed up to tape with NCEAS stuff.

Actions #4

Updated by Redmine Admin about 11 years ago

Original Bugzilla ID was 2481

Actions

Also available in: Atom PDF