Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
postgresqlpostgresql9.3
1 Besvara
11053 Vyer
Avatar
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

Avatar
Avbryt
Avatar
Chris Dennis
Författare Bästa svar

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
Avatar
Avbryt
Relaterade inlägg Svar Vyer Verksamhet
Unable to run the PostgreSQL service Löst
postgresql postgresql9.3
Avatar
Avatar
Avatar
Avatar
Avatar
6
dec. 23
47370
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released
postgresql
Avatar
0
feb. 25
4384
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied
postgresql
Avatar
Avatar
Avatar
2
jan. 25
12628
Odoo backend to Google Data Studio Löst
postgresql
Avatar
Avatar
2
jan. 24
10140
Reason why Odoo being slow when there is huge data inside the database Löst
postgresql
Avatar
Avatar
Avatar
Avatar
7
maj 26
53391