| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | "Resurrected" data files - problem? |
| Date: | 2007-11-08 11:04:13 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C287FCE8@exadv11.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
We use a tape backup software that does "incremental backups"
as follows:
- In a full backup, all files are backed up.
- In an incremental backup, only the files with modification
date after the last backup are backed up.
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,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Moroz | 2007-11-08 11:50:49 | Strange variable behaviour when using it in limit clause in plpgsql stored procedure |
| Previous Message | Jorge Godoy | 2007-11-08 09:46:36 | Re: any way for ORDER BY x to imply NULLS FIRST in 8.3? |