|
|||||||||||
|
[GENERAL] "Resurrected" data files - problem?
From: Albe Laurenz <laurenz.albe(at)wien.gv.at>
Date: Thu Nov 08 2007 - 06:04:13 EST
Now when such a backup is restored, you first have to restore the full backup, and then the incremental backup. The problem is that files which were deleted between the full and the incremental backup will get "resurrected" after such a restore. So if we perform our database backups with incremental backups as described above, we could end up with additional files after the restore, because PostgreSQL files can get deleted (e.g. during DROP TABLE or TRUNCATE TABLE). My question is: Could such "resurrected" files (data files, files in pg_xlog, pg_clog or elsewhere) cause a problem for the database (other than the obvious one that there may be unnecessary files about that consume disk space)?
Yours,
---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend Received on Thu Nov 8 06:06:24 2007 This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 19:33:39 EDT |
||||||||||
|
|||||||||||