On Thu, 2024-03-07 at 18:48 -0700, Sam Darwin wrote:
> pg_restore: error: could not execute query: ERROR: must be owner of schema public
> Command was: COMMENT ON SCHEMA public IS '';
>
> Well, maybe, consider if terse error messages could be more verbose.
As long as you know that restoring a dump executes SQL statements, what
is missing? You get the statement that was executed and the error
message. Right, you have to know what the owner of an object is, but
you cannot expect the error message to discourse on that.
Restoring a dump when you are not a superuser is always difficult.
Yours,
Laurenz Albe
