Re: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12) - Mailing list pgsql-bugs

PG Bug reporting form <noreply@postgresql.org> writes:
> Then Make backup database from Pgadmin version 4.12(OS Windows 8.1)
> ,PostgreSQL 9.6.2 (OS Centos 7) . pg_restore(OS Windows 8.1 with PGAdmin)
> with error CREATE OPERATOR
> make backup database from pg_dump(centos 7) and pg_restore(centos 7) is
> OK.
> This is ERROR pg_dump(Windows 8.1-Pgadmin 4.12) pg_restore(Windows
> 8.1-Pgadmin 4.12)
> 190923072510779341,pg_restore: creating OPERATOR "public.>"

This:

> 190923072510780341,    Command was: CREATE OPERATOR "public".> (
> 190923072510780341,    FUNCTION = "public"."mchar_icase_gt",

indicates that you're using v11 or later pg_dump (prior versions
would print "PROCEDURE" not "FUNCTION" here).  Don't do that
for this application.  In general, the version of pg_dump you use
must be >= the version of the source server, but <= the version
of the server you intend to restore to.

            regards, tom lane