Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmptgmgLN/dump.sql', u'DatabaseName') error 1

Question

I am facing this issue for last 3 days. I don't know how to solve this issue. I search and got many answers. No one worked for me.
I know, how to back up the database using the command line.
Please help me to sort the issue. Both issue in back up and restore.
Noted: No issue in creating a new database and drop the database.
No Postgresql client conflict. Port No is the same for Postgresql and odoo.conf file.

Ravi Gadhia · Accepted Answer

it's a known issue of version miss-match of postgres and pg_dump.
locate postgres using which command and change correct path of pg_dump using
*
ln -s /usr/postgres-version/bin/pg_dump /usr/bin/pg_dump --force*
~ % which postgres
/usr/local/bin/postgres
~ % which pg_dump
/usr/local/bin/pg_dump
~ % postgres --version
postgres (PostgreSQL) 11.4
~ % pg_dump --version
pg_dump (PostgreSQL) 11.4
​
ref:  https://github.com/odoo/odoo/issues/31085 [1]
​ https://www.odoo.com/forum/help-1/question/database

Gaston Carrera · Answer

Hi Remya!
Yo pude resolverlo, el problema es cuando intentas importar la database seleccionando el objeto "dump.sql" , lo correcto es elejir el objeto .zip que obtienes al Exportar la database, en ese caso me importó con exito y sin errores la informacion completa.
I has been able to solve it , my problem was when i try to import the database clicking "Restore Database" and load the "dump.sql" archive, but the correct way its loading the entire .zip file that export the odoo when you clic in "ba

Bài viết liên quan	Trả lời	Lượt xem
How to Restore Odoo Online Database? Đã xử lý backup restore	3 thg 7 24	6705
Backup procedure for Odoo 14 CE Đã xử lý backup restore	1 thg 5 21	3890
backup in linux and shift to windows backup restore	1 thg 3 24	6094
Can you tell me how we do a complete backup and restore in odoo ? backup restore	3 thg 8 16	4334
Backup and restore odoo 8 backup restore	0 thg 3 16	4127

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!