I'm running OpenERP version 7.0_20130811_231021-5 on Arch Linux, and the latest system upgrade has replaced Postgresql 9.2 with 9.3. Yes, I should have checked before allowing the upgrade...
I followed the instructions at wiki.archlinux.org/index.php/PostgreSQL#Upgrading_PostgreSQL and all went well until running pg_upgrade. The errors at the end of the log are:
... pg_restore: creating COMMENT COLUMN "ir_act_server"."expression" pg_restore: creating COMMENT COLUMN "ir_act_server"."email" pg_restore: creating COMMENT COLUMN "ir_act_server"."action_id" pg_restore: creating TABLE ir_act_url pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 190; 1259 59957 TABLE ir_act_url openerp pg_restore: [archiver (db)] could not execute query: ERROR: column "name" in child table must be marked NOT NULL Command was: -- For binary upgrade, must preserve pg_type oid SELECT binary_upgrade.set_next_pg_type_oid('59959'::pg_catalog.oid);
Any ideas how to mend that? Or do I need to revert to pg 9.2?
In the absence of better ideas, I downgraded postgresql to 9.2 like this:
# systemctl stop postgresql # cd /var/cache/pacman/pkg # pacman -U postgresql-9.2.4-2-x86_64.pkg.tar.xz postgresql-libs-9.2.4-2-x86_64.pkg.tar.xz
Renamed /var/lib/postgres/data-9.2 back to just data.
# systemctl restart postgresql Warning: Unit file of postgresql.service changed on disk, 'systemctl daemon-reload' recommended. # systemctl daemon-reload
Postgresql 9.2 is running, and OpenERP works again.
I've made sure that it won't happen again by adding this line to /etc/pacman.conf:
IgnorePkg = postgresql postgresql-libs
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 10/29/13, 3:15 PM|
|Seen: 2986 times|
|Last updated: 3/16/15, 8:10 AM|