How do I mend a failed upgrade to Postgresql 9.3

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How do I mend a failed upgrade to Postgresql 9.3

postgresql postgresql9.3

1 Odpowiedz

8511 Widoki

Chris Dennis

Hello folks

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?

cheers

Chris

Chris Dennis

Autor

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

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Unable to run the PostgreSQL service Rozwiązane postgresql postgresql9.3	6 gru 23	43089
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 lut 25	663
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 sty 25	6560
Odoo backend to Google Data Studio Rozwiązane postgresql	2 sty 24	10137
Reason why Odoo being slow when there is huge data inside the database postgresql	7 sty 24	47570

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!