[Odo 13 CE ] Backup is creating 0KB files

[clxadmin]

Thank you for this backup module :-)

I'm running a Odoo 13 CE at CentOS7 with one single database and auto_backup 13.0.13.1.0.1

Settings:
​ | Host | Port | Database | Backup Directory |
​ | localhost | 8069 | fdplive | /odoo/backups | ​

The backup files have all 0 KB. This is what I see at the log files:

2021-06-24 12:34:23,032 919 INFO fdplive odoo.addons.base.models.ir_http: Generating routing map for key 1
2021-06-24 12:34:23,138 919 INFO fdplive odoo.addons.auto_backup.models.db_backup: DUMP DB: fdplive format dump

Backup is started and creates a dump file with 0 KB : 2021_06_24_12_34_23_fdplive.dump

Any suggestions for this issue? I thank you for feedback

[Yenthe666]

Duplicate of:
#186
#187
and more.
I presume you have a big database or no workers or a very short limit time real?

[clxadmin]

I presume you have a big database or no workers or a very short limit time real?
database size is about 500 MByte

config:
limit_memory_hard = 39460012032
limit_memory_soft = 32883343360
limit_request = 8192
limit_time_cpu = 600
limit_time_real = 1200
max_cron_threads = 2
workers = 49

[clxadmin]

@Yenthe666
I also find the same issue like #178 my pg_dump is not find anymore since installing this backup_module
File "/odoo/odoo-server/odoo/tools/misc.py", line 100, in find_pg_tool
raise Exception('Command %s not found.' % name)
Exception: Command pg_dump not found.

I can not find any pg_path = None in my config file

[Yenthe666]

Did you link the wrong one? As 178 doesn't talk about pg_dump in any way.
As for your configs: odd that should be fine as it is a rather small database and should finish within 600s.

[clxadmin]

Hello, yes I link the wrong one - sorry
I still have the same problem with zero bite backup files at multiple installations.

If I try to reproduce this issue by manually create backups with pg_dump, zero byte files happens, if I use pg_dump without the correct permissions/authentification.

I think the same is here using auto_backup calling pg_dump without the needed permissions results in zero byte files. Please can you post a sample of your odoo-server.conf and the pg_hba.conf ? That would be nice

here is my odoo-server.conf :
list_db = True
pg_path = /opt/rh/rh-postgresql10/bin

here is my pg_hba.conf :
"local" is for Unix domain socket connections only
local all all trust
IPv4 local connections:
host all all 127.0.0.1/32 trust