Skip to content

Restoring db dump is failing #13

Description

@svedbg

When trying to restore the db_scripts/create_empty_db.sql in postgres it's failing with following error:

[utmadmin@castrac7vm db_scripts]$ /usr/pgsql-11/bin/pg_restore -U utmadmin -d utm_dev -1 /home/utmadmin/project/dronfiesuss/db_scripts/create_empty_db.sql 
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 10; 2615 17824 SCHEMA topology postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  must be member of role "postgres"
    Command was: ALTER SCHEMA topology OWNER TO postgres;

Why topology needs postgres?

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions