Benedikt Grundmann <bgrundmann@xxxxxxxxxxxxxx> writes: > I just tried this again. This time from 9.2.17 to 9.5.4 and pg_upgrade > chokes with this: > > [root@igm-dbc-001 upgrade-logs]# tail pg_upgrade_dump_16416.log > pg_restore: [archiver (db)] could not execute query: ERROR: syntax error > at or near "=>" > LINE 1: CREATE OPERATOR => ( > ^ > Command was: CREATE OPERATOR => ( > PROCEDURE = "tconvert", > LEFTARG = "text", > RIGHTARG = "text" > ); You're going to need to manually drop that operator from the source database, as "=>" isn't a legal operator name anymore. This appears to be left over from a pre-9.0 version of hstore. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
