check on heroku db backups_U

[BrianClement]

[Issue originally created 2017-Mar-21 07:14:57 UTC by hammockman]

Ra, email to JH, 21/03/2017:

Just did a check of the backup. On restore I get 85 errors of the likes of this:

pg_restore: [archiver (db)] Error from TOC entry 8; 2615 2696896 SCHEMA acl yzpvsgtbnqiilk pg_restore: [archiver (db)] could not execute query: ERROR: schema "acl" does not exist Command was: DROP SCHEMA "acl";

The resulting database seems to work fine, but such errors are presumably not grand.

There is a backup at the following link if you have inclination to make more sense of it. I used

createdb db pg_restore --clean --no-acl --no-owner -d db filename

to get my 85 errors.

Link:

https://xfrtu.s3.amazonaws.com/14406d8d-1197-4309-9087-a3d8fa9493ef/2017-03-20T12%3A02%3A40Z/1ea600ff-59df-4194-bf77-739824e65caf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAJCSJJKP7D4MYHIDQ%2F20170321%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20170321T015120Z&X-Amz-Expires=3600&X-Amz-SignedHeaders=host&X-Amz-Signature=1b649623e8f5aaadb31025c56e7638ef396e515ae843d990637f79ef6bc4a469

[BrianClement]

[Comment originally created 2017-Mar-22 03:23:35 UTC by racleave]

Works OK now, just don't use --clean flag. Docs have been updated.