Search Postgresql Archives

Re: Are file system level differential/incremental backups possible?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bob Hatfield wrote:
> Is it possible to do a full file system level backup of the data
> directory, say once a week, and differentials or incrementals daily?
> 
> I'm wondering if there are files that would normally be removed that a
> restore: Full then diff/inc would not remove and perhaps
> corrupt/confuse things.

If you drop or truncate a table between the full and the incremental
backup, will that file be "resurrected"?

Such resurrected files will not disturb PostgreSQL, but if you keep
them around, you might end up with a lot of dead files if you have to
restore a couple of times.

Yours,
Laurenz Albe

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux