Re: Re: Table update: restore or replace?

From: "Brad Nicholson" <bradn(at)ca(dot)ibm(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Re: Table update: restore or replace?
Date: 2019-05-14 21:29:31
Message-ID: OF0C860A3F.ED96A254-ON852583FA.0075DB28-852583FA.00760F68@notes.na.collabserv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
> To: pgsql-general(at)lists(dot)postgresql(dot)org
> Date: 05/14/2019 05:19 PM
> Subject: [EXTERNAL] Re: Table update: restore or replace?

> And I think I'll set up a cron job to do a database dump each day with
the
> date appended to the file name in the bash shell script.

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-05-14 21:30:26 Re: Table update: restore or replace?
Previous Message Rich Shepard 2019-05-14 21:21:52 Re: Table update: restore or replace?