Jaume Sabater <jsabater@xxxxxxxxxxxxx> writes: >> But I got these errors: >> >> pg_restore: [archiver (db)] Error while PROCESSING TOC: >> pg_restore: [archiver (db)] Error from TOC entry 3751; 0 0 COMMENT >> SCHEMA public postgres >> pg_restore: [archiver (db)] could not execute query: ERROR: must be >> owner of schema public >> Command was: >> COMMENT ON SCHEMA public IS 'Standard public schema'; >> pg_restore: WARNING: no privileges could be revoked >> pg_restore: WARNING: no privileges could be revoked >> pg_restore: WARNING: no privileges were granted >> pg_restore: WARNING: no privileges were granted >> WARNING: errors ignored on restore: 1 You can ignore these. --no-owner plus do the restore as the new owner is the correct procedure. regards, tom lane
