The following bug has been logged on the website:
Bug reference: 14311
Logged by: Fabien C
Email address: fabien(dot)combernous(at)adullact(dot)org
PostgreSQL version: 9.1.23
Operating system: Linux
Description:
CREATE DATABASE foo; pg_dump foo |psql fails if you're not a superuser
the problem here is that changing the comment of an extension not owned by
you causes an error, unless you're superuser.
but the user never added the comment; the system did via pg_dump.
This means :
1) writing a dump file first and editing it, or
2) not being able to use -v ON_ERROR_STOP=1