Non-fatal error while restoring postgres database in Satellite 5.6

Solution Verified - Updated -

Issue

  • During the Satellite Database restore procedure:

    rhn-satellite stop --exclude=postgresql ; db-control restore /var/satellite/BACKUP-POSTGRES/postgres-online-today.dump ;
    rhn-satellite start --exclude=postgresql
    

    The following ERROR was shown:

    [...]
    ** Restoring from file /var/satellite/BACKUP-POSTGRES/postgres-online-today.dump.
    pg_restore: [archiver (db)] Error while PROCESSING TOC:
    pg_restore: [archiver (db)] Error from TOC entry 3395; 2612 16389 PROCEDURAL LANGUAGE pltclu postgres
    pg_restore: [archiver (db)] could not execute query: ERROR:  language "pltclu" already exists
        Command was: CREATE PROCEDURAL LANGUAGE pltclu;
    WARNING: errors ignored on restore: 1
    Restoration complete.
    

Environment

  • Red Hat Satellite 5.6

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.