I was able to use my database after following the next steps: restore only the schema with the -s option to pg_restore sample: pg_restore –host …