Re: Point in time Recovery in Postgres?
Hi Pavan,
PITR is the ability to restore a database cluster up to the present or to a specified point of time in the past with the help of WAL’s. PITR uses full database cluster backup and the write-ahead logs(i.e WAL’s). For that we should have cluster level (file system level) backup like pg_basebackup.
In PostgreSQL it is possible to have PITR but it requires file system level backup (like pg_basebackup).
So, It is not possible to do PITR with pg_dump backup.
On Tue, Oct 23, 2018 at 10:14 AM pavan95 <pavan.postgresdba@gmail.com> wrote:
Hi all,
Is it possible to do PITR in postgres for a database provided that database
pg_dump backup is available and archive logs are also configured....
Could you please confirm? Thanks in Advance!!
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
В списке pgsql-admin по дате отправления: