Search Postgresql Archives

Re: pg_upgrade 9.4 -> 9.5 with pg_trgm fails for me

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Jan 08, 2016 at 12:45:29PM +0100, Karsten Hilbert wrote:

> 	pg_restore: erstelle EXTENSION „pg_trgm“
> 	pg_restore: erstelle COMMENT „EXTENSION "pg_trgm"“
> 	pg_restore: erstelle FUNCTION „pg_catalog.gtrgm_in("cstring")“
> 	pg_restore: [Archivierer (DB)] Fehler in Phase PROCESSING TOC:
> 	pg_restore: [Archivierer (DB)] Fehler in Inhaltsverzeichniseintrag 893; 1255 511230 FUNCTION gtrgm_in("cstring") postgres
> 	pg_restore: [Archivierer (DB)] could not execute query: ERROR:  pg_type OID value not set when in binary upgrade mode
> 	    Die Anweisung war: CREATE FUNCTION "gtrgm_in"("cstring") RETURNS "gtrgm"
> 	    LANGUAGE "c" IMMUTABLE STRICT
> 	    AS '$libdir/pg_trgm', 'gtrgm_in'...

It does sound similar to

	http://postgresql.nabble.com/BUG-5942-pg-trgm-sql-has-cyclic-dependency-on-type-gtrgm-creation-td4259677.html

which, however, wouldn't help me in solving the problem.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux