Peter Childs wrote: >> We use a tape backup software that does "incremental backups" [...] >> 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)? > > This will not work at all.
Can you give me a good reason why? > Try re-reading the instructions on backup in the manual. I know them well. That is why I ask if this questionable procedure could lead to damage. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings