Pg_restore runs ALTER TABLE .. OWNER TO ignoring pg_dump –no-owner option
I’m using an mac mini m1 and postgresl14 on it for a database migration.
For the migration a change of the owner is necessary.
schema only dump & restore missing schemas
I am trying to do a schema only dump and restore, but the retore fails with every object because it’s not creating the expected schemas these are the commands I am running: