The perfect choice of one-stop service for diversification of architecture.
I remember one called USBFlashCopy that would launch on connecting the drive. I am on a phone so I can not link, but it is a good piece of software
1. How to identify all WALs created during start_backup and stop_backup?
The file names are 24 hex digits long, broken into 3 fields of 8 digits each. The first is the timeline, which you probably do not need to worry about here. The other two are called the "segment" and the "file". They are really a single counter, the "file" rolls over by incrementing the "segment" by one and going back to zero.Oddly, only the last two digits of the "file" chunk are ever non-zero. (This is apparently so that the offset into a logical 'segment' fits in a 32 bit uint, which was important at some point in the distant past)In 9. 1 and 9. 2, the "file" skips FF. So from FE, it rolls back over to 00 while incrementing the segment number. In 9.3, it switches so that FF is used. So the sequence for your version would go:Getting the files from pg_xlog is tricky, because those files get recycled (i.e. renamed to have the name of some future file-name, then overwritten once it gets around to needing that file). This means that the timestamps on the files are all screwy. A recycled log file will have the name of some future file, but the contents and timestamp of some past file.If a file was recycled before you had a chance to copy it, then your backup has failed and you need to try again with a higher wal_keep_segments. And of course if you copy the "current" file before it was finalized, it will be missing the changes that occurred after the point you copied it.It is much easier to get them from the wal archive, because that does not have the recycling problem and because they do not show up at all until they are finalized
2. How to make a backup of an Oracle database that does not mess up the regular backup cycle?
I would use RMAN to DUPLICATE DATABASE TO OTHERDB. Feel free to use one of the related methods that fits your environment/requirements.References:
3. crontab for mysql database cleanup and backup
You can use expire_logs_days=5 in your my.cnf to perform the same function as your second cron job. It is probably more reliable
4. How to do a monthly system backup
To set up the cronjob for yr present non-root user, do in terminal:The above will open yr (non-root) user's crontab with his/her default editor.Alternatively, to do so for the root crontab, but with yr present (presumably non-root) user environment parameters (default editor, etc.):In yr opened crontab, enter a new line:(I did not check the validity of yr tar cmd. )Note that:crontab uses a 24-hour clock, military style: 15 means 3pm, 03 means 3am, etc. the above cron entry runs at 01:00 o'clock the first day of every month. In terminal , do: man crontab for more info on crontab formats. in crontab, it's a good habit to prefix cmds with their full path. To find the full path of any non-built-in cmd, do in terminal $ which
5. Recovering a single fille from Nandroid backup?
Nandroid Manager does exactly what you want for free, but it also has a pro version with additional features
6. Would a large number of people simultaneously turning on a load of 3 kW be sufficient to bring down the electricity grid across 500 sq km?
500 square km is a small city... or at least, my city is smaller than that. So, I searched news archives for instances of blackout because of overload of the local power station...I found one such incident: it happened during a test because of which the power plant was running at a fourth of its capacity. While the test was running, a connection to another power station failed, leaving the local power station with all the demand. The system did shut down automatically. Power was restored 20 minutes afterwards.So, the normal demand was too much for a fourth of the capacity of this single power station when there was no connection to other power stations for backup. The conditions for this failure are very unlikely... it is expected that the power plant will have enough capacity to supply any foreseeable peak of demand, and second even if it can not handle the capacity it should be able to pull power from the rest of the national network.So, even if you manage to multiply the demand of the houses and buildings on the city (which would then make the local circuit breakers fail instead of the whole urban area), so that you can cause a peak power demand beyond its capacity. .. the power plant should be able to rely on the rest of the national network (which you did not sabotage)