Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
7 Odpowiedzi
3392 Widoki
Awatar
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?


Awatar
Odrzuć
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.

Awatar
Mark Byham
Autor Najlepsza odpowiedź

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


Awatar
Odrzuć
Awatar
Caret IT Solutions Pvt. Ltd.
Najlepsza odpowiedź

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


Awatar
Odrzuć
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.