Re: I need testers for incremental backups (similar Oracle) - Mailing list pgsql-general

From Yury Zhuravlev
Subject Re: I need testers for incremental backups (similar Oracle)
Date
Msg-id 2cdb465d-b6d7-429a-a67a-c57adc4cbbbc@postgrespro.ru
Whole thread Raw
In response to Re: I need testers for incremental backups (similar Oracle)  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
John R Pierce wrote:
> doesn't a wal archive give you pretty much the same thing?

No, because WAL quickly enough may become larger than the database.
In the WAL can be any number of records that change only one page of
memory.
In addition recover from the WAL too long, because it should be "play" by
Postgres.
In my case pg_arman + ptrack it's almost as simple copy files.

Thanks.

--
Yury Zhuravlev
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


pgsql-general by date:

Previous
From: Pierre Chevalier Géologue
Date:
Subject: Re: Enhancement request for pg_dump
Next
From: "Shulgin, Oleksandr"
Date:
Subject: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created