backup database from postgresql 10.18 and restore it to postgresql 12.8

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

CRM
e-Commerce
Contabilitate
Inventar
PoS
Project
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

backup database from postgresql 10.18 and restore it to postgresql 12.8

postgresql databasebackup

2 Răspunsuri

2455 Vizualizări

Fathiabm

Good morning everyone,

i am trying to restore a database created in an older version of postgresql, and it gives me this error message( i am using odoo13):

Database restore error: Postgres subprocess ('/usr/bin/pg_restore', '--dbname=test', '--no-owner', '/tmp/tmplqv2n1ih') error 1

Can you help me please !

Thank you.

Jainesh Shah(Aktiv Software)

Cel mai bun răspuns

Hi Fathiabm,

- This type of error occurs when you upload sql file or dump file from UI.
- You have to download zipfile from older version and then upload it to new version.
- You can also restore database using psql command if you are ubuntu user.
- If you need any help, please share us more details.

Fathiabm

Autor

Thank you Jainesh for responding,

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 feb. 25	1243
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 ian. 25	7596
Download database with only master data Rezolvat databasebackup	2 oct. 24	1545
Odoo backend to Google Data Studio Rezolvat postgresql	2 ian. 24	10137
Reason why Odoo being slow when there is huge data inside the database postgresql	7 ian. 24	48531

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!