Skip to Content
This question has been flagged
7 Replies
3364 Views
Avatar
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?


Avatar
Discard
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.

Avatar
Mark Byham
Author Best Answer

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


Avatar
Discard
Avatar
Caret IT Solutions Pvt. Ltd.
Best Answer

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


Avatar
Discard
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.