A commonly seen pg_restore error type:

pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension some_extension

The above type of error is often seen happening due to unessential queries failing due to lack of superuser-level privileges.

The typical example of these is a failing "COMMENT ON EXTENSION" query that tries to replace the documentational comment string for an extension.

This type of errors are harmless and can be ignored, or for a better option, you can use the "--no-comments" switch to skip these queries altogether. There are other similar "--no-XXX" options that can be used to disable other often unnecessary restore queries from being executed.

Did this answer your question?