On Thu, May 11, 2017 at 11:53 AM, Pierre Couderc <pierre(at)couderc(dot)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(dot)hunley(at)openscg(dot)com <doug(dot)hunley(at)gmail(dot)com>",
"mobile" : "+1 614 316 5079"
}