Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
7 Vastaukset
3398 Näkymät
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
Hylkää
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
Tekijä Paras vastaus

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
Hylkää
Avatar
Caret IT Solutions Pvt. Ltd.
Paras vastaus

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
Hylkää
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.