Postgres WARNING: Errors are ignored during recovery: 59

I use the pg: transfer utility recommended by Heroku for loading and unloading databases. For instance:

heroku pg:transfer -f postgres://username:password@localhost/database-name -t postgres://user-name:password@host-name/database-name --confirm app-name

I was able to do this successfully, but every time he claims that the error was ignored at the end of the transfer:

WARNING: errors ignored on restore: 59

Do I need to worry about this?

EDIT:

I went through my conclusion and seemed to be wrong on every table. It seems that he discarded the sequence and then threw an error, stating that it does not exist.

pg_restore: dropping SEQUENCE OWNED BY roles_id_seq 
pg_restore: dropping SEQUENCE roles_id_seq 
pg_restore: [archiver (db)] Error from TOC entry 170; 1259 35485 SEQUENCE roles_id_seq postgres 
pg_restore: [archiver (db)] could not execute query: ERROR: sequence "roles_id_seq" does not exist Command was: DROP SEQUENCE public.roles_id_seq;
+5
source share
1 answer

I assume that what happens is that it launches a clean recovery, which means that it simply deletes the previous objects and then recreates them.

, . , toolchain , IF EXISTS drop.

+2

All Articles