PostgreSQL WARNING: Errors Ignored On Restore (1)

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

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 2 weeks, 1 day ago.

  • 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.

You must be logged in to reply to this topic.