Re: PITR Backups

Toru SHIMOGAKI wrote:
> Tom Lane wrote:

> - When we take a PITR base backup with hardware level snapshot operation
>   (not filesystem level) which a lot of storage vender provide, the backup data
>   can be corrupted as Dan said. During recovery we can't even read it,
>   especially if meta-data was corrupted.
>
> - If we don't use hardware level snapshot operation, it takes long time to take
>   a large backup data, and a lot of full-page-written WAL files are made.

Does it? I have done it with fairly large databases without issue.

Joshua D. Drake


>
> So, I think users need a new feature not to write out heap pages during taking a
> backup.
>
> Any comments?
>
> Best regards,
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/