I am unable to upgrade my postgresql server from 9.4 to 9.5 due to the following error message:
pg_restore: creating OPERATOR "public.->"
pg_restore: creating OPERATOR "public.<@"
pg_restore: creating OPERATOR "public.=>"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1617; 2617 17937 OPERATOR => william
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"
);
I have not been able to find anything relevant by googling. The most relevant thing I can find is someone who encountered this issue with a much older version of hstore, and the fix is not clear.
I am using homebrew on a Mac. I would work around the issue with pg_dumpall, but I can no longer run that because the 9.4 binaries are loading the libs for 9.5 following the upgrade. Is there a way around this?
The other solutions either were not options, or they didn't work.
The solution that worked for me was:
ALTER EXTENSION hstore UPDATE TO '1.1';
Source: https://www.postgresql.org/message-id/22170.1457479307%40sss.pgh.pa.us
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments