backup database from postgresql 10.18 and restore it to postgresql 12.8

Question

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) · Accepted 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 · Answer

Thank you Jainesh for responding,

相关帖文	回复	查看
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 2月 25	1825
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 1月 25	8493
Download database with only master data 已解决 databasebackup	2 10月 24	1990
Odoo backend to Google Data Studio 已解决 postgresql	2 1月 24	10138
Reason why Odoo being slow when there is huge data inside the database postgresql	7 1月 24	49369

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！