| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Benedikt Grundmann <bgrundmann(at)janestreet(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problems with pg_upgrade after change of unix user running db. |
| Date: | 2016-10-03 13:12:44 |
| Message-ID: | 14900.1475500364@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Benedikt Grundmann <bgrundmann(at)janestreet(dot)com> writes:
> I just tried this again. This time from 9.2.17 to 9.5.4 and pg_upgrade
> chokes with this:
>
> [root(at)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dudedoe01 | 2016-10-03 13:39:09 | Re: isnull() function in pgAdmin3 |
| Previous Message | Devrim Gündüz | 2016-10-03 13:12:00 | Re: Installing pgAdmin 4 in Oracle Enterprise Linux 7 |