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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: drd1(at)list(dot)ru
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)
Date: 2019-09-24 14:17:05
Message-ID: 14701.1569334625@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alfred R. Fuller 2019-09-24 18:37:39 Bug with "CHECK" when part of ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... CHECK ...
Previous Message PG Bug reporting form 2019-09-24 09:29:28 BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12)