Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore? - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore?
Date
Msg-id 20180521164919.GA97744@elch.exwg.net
Whole thread Raw
In response to Will Altering and Modifying tables during backup result in acorrupted server after the restore?  (Yashwanth Govinda Setty <ygovindasetty@commvault.com>)
Responses Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
## Yashwanth Govinda Setty (ygovindasetty@commvault.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


pgsql-general by date:

Previous
From: Alexey Dokuchaev
Date:
Subject: Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
Next
From: Tom Lane
Date:
Subject: Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics