Re: Problems with pg_upgrade after change of unix user running db.

Benedikt Grundmann <bgrundmann@janestreet.com> 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