PostgreSQL WARNING: Errors Ignored On Restore (1)

IT Support Forum Forums Databases PostgreSQL Troubleshooting PostgreSQL WARNING: Errors Ignored On Restore (1)

Viewing 0 reply threads
  • Author
    Posts
    • #2254
      Webmaster
      Keymaster

      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.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.