Upgrade error

Highlighted
Level 2 Adventurer

Upgrade error

Hi All,

I am getting error while trying to upgrade postgres from 9.5 to 9.6 using pg_upgrdae utility.

 

pg_restore: creating OPERATOR CLASS "pg_catalog.citext_ops"

pg_restore: [archiver (db)] Error while PROCESSING TOC:

pg_restore: [archiver (db)] Error from TOC entry 1864; 2616 16631 OPERATOR CLASS citext_ops postgres

pg_restore: [archiver (db)] could not execute query: ERROR: operator family "pg_catalog.citext_ops" does not exist for access method "btree"

Command was: CREATE OPERATOR CLASS "pg_catalog"."citext_ops" DEFAULT FOR TYPE "citext" USING "btree" FAMILY "pg_catalog"."citext_ops"..

 

 

Please could any one help me on this.

Thanks

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

5 REPLIES 5
Highlighted
Level 3 Adventurer

Re: Upgrade error

Hi ram,

 

It seems to be an operator class created on 9.5 which is not present on 9.6. 

 

Try to create the operator class on 9.6 as well same as 9.5 and then proceed with the upgrade.

 

 

Highlighted
Level 2 Adventurer

Re: Upgrade error

Hi Ranjan,

 

Shouldn't the new DB (ie. 9.6) be empty (initialized beofre upgrade)? If not on which DB do I need to create Operator Family.

Highlighted
EDB Team Member

Re: Upgrade error

Hi ram1992,

 

To avoid this error, first you need to drop the operator class from postgres 9.5 cluster, then perform the upgrade activity between 9.5 to 9.6, once the upgrade is successfull, create a operator class on newly upgraded cluster 9.6.

 

Hope this helps you.

 

 

Highlighted
Level 2 Adventurer

Re: Upgrade error

Thanks, kapil

I have upgraded using dump and restore method. Will test your suggesstions on any test severs and try to upgrade it.

Highlighted
EDB Team Member

Re: Upgrade error

Hi ram1992,

 

Thank you for the update. 

 

Hope your issue has been resloved with dump and restore method, however we will waif for your feedback with upgrade method.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks