Search Postgresql Archives

Re: Re: Table update: restore or replace?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Re: Table update: restore or replace?
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Tue, 14 May 2019 15:13:37 -0700 (PDT)
In-reply-to: <OF0C860A3F.ED96A254-ON852583FA.0075DB28-852583FA.00760F68@notes.na.collabserv.com>
References: <alpine.LNX.2.20.1905141341311.30120@salmo.appl-ecosys.com> <5fb66fe3-0aa0-3d6d-db53-172a6c3f1a30@aklaver.com> <alpine.LNX.2.20.1905141358090.30120@salmo.appl-ecosys.com> <f03ea12f-2d98-33ea-9f98-cc93f06aff97@aklaver.com> <alpine.LNX.2.20.1905141413540.30120@salmo.appl-ecosys.com> <OF0C860A3F.ED96A254-ON852583FA.0075DB28-852583FA.00760F68@notes.na.collabserv.com>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Table update: restore or replace?
  - From: Rich Shepard
- Re: Table update: restore or replace?
  - From: Adrian Klaver
- Re: Table update: restore or replace?
  - From: Rich Shepard
- Re: Table update: restore or replace?
  - From: Adrian Klaver
- Re: Table update: restore or replace?
  - From: Rich Shepard
- Re: Re: Table update: restore or replace?
  - From: Brad Nicholson

Prev by Date: Re: Table update: restore or replace?
Next by Date: Re: Table update: restore or replace?
Previous by thread: Re: Re: Table update: restore or replace?
Next by thread: Re: Table update: restore or replace?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]