Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
7 ตอบกลับ
3394 มุมมอง
อวตาร
Mark Byham

Hi All,

I have Odoo 12 CE on a CentOS 7.5 VM on Azure. I followed steps by linuxise to install and it all works perfectly except for backing up the database.

 I go to .../web/database/backup and click backup, enter password (password must be correct as it tells me access denied if different) and then I get this

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

I have seen some old forum entries suggesting to run pg_dump. I fail at the first hurdle, can't get log into psql :(

Can anyone tell me how to resolve this problem? Also how do I log into psql?


อวตาร
ละทิ้ง
Cybrosys Techno Solutions Pvt.Ltd

for logging into Postgres, try,

sudo su postgres

click enter, then

psql

Cybrosys Techno Solutions Pvt.Ltd

Just a found a video which might help you on taking back up from terminal: https://www.youtube.com/watch?v=KUHD4YGXseI

Cybrosys Techno Solutions Pvt.Ltd

Hi, Thanks! I'm in Postgres, now just looking at a few things.

อวตาร
Mark Byham
ผู้เขียน คำตอบที่ดีที่สุด

Hi Yenthe,
I see that Version 10 server is installed but there’s an older version of psql, is that a problem?
 psql (9.2.24, server 10.6)

WARNING: psql version 9.2, server version 10.0.
Some psql features might not work.
Also I tried to run pg_dump but I don't see any error and it just doesn't work.

Thanks,

Mark


Hi All,
I have fixed this issue, it was due to the psql client and pg_dump set to v9 and postgres server is v10

Changing sym links to v10 folder worked but I had to do the same for pg_dump and it probably needs doing for all commands.

This from http://tuxtrix.blogspot.com/2014/12/how-to-fix-psql-version-84-server.html

Now, lets make sure, the newer version links to the default path set. 

# mv /usr/bin/psql /usr/bin/psql-bk
# ln -s  /usr/pgsql-10/bin/psql /usr/bin/psql

and..
# mv /usr/bin/psql /usr/bin/pg_dump-bk
# ln -s  /usr/pgsql-10/bin/pg_dump /usr/bin/pg_dump




Thanks,

Mark


อวตาร
ละทิ้ง
อวตาร
Caret IT Solutions Pvt. Ltd.
คำตอบที่ดีที่สุด

Hello Mark Byham,

First, Odoo 12 need Postgres 10 minimal, the pg client should be at least v10.

Second, Delete (Drop) db if you create it manually from pgadmin.

To access log in Azure refer below:

https://docs.microsoft.com/en-us/azure/postgresql/concepts-server-logs#access-server-logs-through-portal-or-cli


Thank You


อวตาร
ละทิ้ง
Yenthe Van Ginneken (Mainframe Monkey)

That is nonsense, there is nowhere a fixed requirement for postgres 10 for Odoo 12.

OdooBot

Hi Yenthe,

I see that Version 10 server is installed but there’s an older version of psql, is that a problem?

 

psql (9.2.24, server 10.6)

WARNING: psql version 9.2, server version 10.0.

         Some psql features might not work.

 

Thanks,

Mark

 

From: Yenthe Van Ginneken <yenthespam@gmail.com>
Sent: Thursday, 17 January 2019 5:36 AM
To: Mark Byham <mark@techboss.com.au>
Subject: Re: Web .../web/database/backup Backup of database fails

 

That is nonsense, there is nowhere a fixed requirement for postgres 10 for Odoo 12.

 

Sent by Odoo S.A. using Odoo.