When i try to restore a database from a dump file using the following command:
from within my sql shell, it runs the first few lines of the dump file and then I get the following error:
ERROR: permission denied to create "pg_catalog.databasename"
DETAIL: System catalog modifications are currently disallowed.
This shows the beginning of the dump file. I think the
CREATE TABLE command triggers the error.
I'm using postgreSQL Version 11.1. Any ideas how to solve this?