Re: I need testers for incremental backups (similar Oracle)

From: Yury Zhuravlev <u(dot)zhuravlev(at)postgrespro(dot)ru>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: I need testers for incremental backups (similar Oracle)
Date: 2016-04-22 16:42:07
Message-ID: 2cdb465d-b6d7-429a-a67a-c57adc4cbbbc@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pierre Chevalier Géologue 2016-04-22 16:44:01 Re: Enhancement request for pg_dump
Previous Message Rob Brucks 2016-04-22 16:30:03 pg_stat_archiver Enhancement Request