On Tue, 14 May 2019, Brad Nicholson wrote:
Might I suggest you setup proper backups with continuous archiving instead? If you had those, you would be able to restore this database back to the point right before you issued the bad update statement.I'd highly recommend pgBackRest for the task.
Brad, I'll certainly take a look at pgBackRest. Thanks, Rich
