PostgreSQL WARNING: Errors Ignored On Restore (1)

When restoring a PostgreSQL database, you can get this warning:

WARNING: errors ignored on restore (1)

The easiest way to find out what the error was, is to copy all the text above the warning message and paste it into notepad and search for the word error.

The most common error is this:

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;

This is because you restored using the clean restore option, which tries to create the database, but you already created a database to restore to. In this case, it’s safe to ignore the warning.