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
Accounting
Inventory
PoS
Project management
MRP

Take the tour

All Posts People Badges

Tags (View all)

odoo v14 accounting v15 odoo16features

About this forum

Help

backup database from postgresql 10.18 and restore it to postgresql 12.8

postgresql databasebackup

2 Replies

1881 Views

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)

Best Answer

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

Author

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!

Related Posts	Replies	Views
Download database with only master data Solved databasebackup	2 Oct 24	221
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	1 Jul 24	3445
Odoo backend to Google Data Studio Solved postgresql	2 Jan 24	10134
Reason why Odoo being slow when there is huge data inside the database postgresql	7 Jan 24	45435
Postgresql db connection failing often and causing http 500 error Odoo v11 postgresql	0 Mar 23	1038

This question has been flagged

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