PostgreSQL WARNING: Errors Ignored On Restore (1) Posted on by Webmaster IT Support Forum › Forums › Databases › PostgreSQL › Troubleshooting › PostgreSQL WARNING: Errors Ignored On Restore (1) Tagged: restore, WARNING: Errors Ignored On Restore This topic contains 0 replies, has 1 voice, and was last updated by Webmaster 1 year, 9 months ago. Author Posts October 3, 2017 at 8:23 am #2254 WebmasterKeymaster 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. Author Posts You must be logged in to reply to this topic.