Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] How to recover my postgres database ? - Mailing list pgsql-general

From Hunley, Douglas
Subject Re: [GENERAL] How to recover my postgres database ?
Date
Msg-id CAAD=pwE1ax=B5Mw_8_6Q1+g3JHLDNG6Vqw93K5chnr3EFKQ-Nw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] How to recover my postgres database ?  (Pierre Couderc <pierre@couderc.eu>)
Responses Re: [GENERAL] How to recover my postgres database ?  (Pierre Couderc <pierre@couderc.eu>)
List pgsql-general
Tree view

On Thu, May 11, 2017 at 11:53 AM, Pierre Couderc <pierre@couderc.eu> wrote:
How can I safely repair, knowing that I have the pg_dumpall of last  night, but many dbs have changed today... ?

If pg_dumpall is your only backup mechanism then you've lost all changes after the dump was taken. You'll need to restore from that backup and then get pgbackrest (or another equivalent tool) up and running to protect yourself going forward


--
{
  "name" : "douglas j hunley",
  "title" : "database engineer",
  "email" : "douglas.hunley@openscg.com",
  "mobile" : "+1 614 316 5079"
}

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: [GENERAL] Top posting....
Next
From: John R Pierce
Date:
Subject: Re: [GENERAL] How to recover my postgres database ?