Re: Will Altering and Modifying tables during backup result in a corrupted server after the restore?

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: Yashwanth Govinda Setty <ygovindasetty(at)commvault(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Will Altering and Modifying tables during backup result in a corrupted server after the restore?
Date: 2018-05-21 16:49:19
Message-ID: 20180521164919.GA97744@elch.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Yashwanth Govinda Setty (ygovindasetty(at)commvault(dot)com):

> 2. Restore the server with transaction logs

This is missing a lot of details. If you do it right - see your email
thread from one week ago - you will be able to recover the database
server to a state as of the _end_ of the backup process (as marked by
the return of the pg_stop_backup() command).
If you do not follow the backup/restore documentation to the letter,
the database will be corrupted and will not start (sometimes people
report with haphazard backup schemes, but that's just more luck than
they deserve, and nobody should rely on that).

Regards,
Christoph

--
Spare Space

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-05-21 16:54:56 Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
Previous Message Alexey Dokuchaev 2018-05-21 16:28:31 Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics