Issue [PPP-27343] Postgres Backup fails every time

[Tscherno]

I get the following Backup task notification every time the backup of the domain with postgres db runs:

<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="warnings" log-location="/opt/psa/PMM/sessions/2016-12-28-041756.339/migration.result">
<object name="server" type="server">
<object type="domain" name="domain.de" uuid="domain#domain.de">
<object type="postgresql" name="rss">
<message code="msgtext" id="c8defd93-d5d3-49fa-81bd-c9850493b7dd" severity="warning">
<description>Failed to execute backup database</description>
</message>
<message severity="warning" id="b11114fc-f2e1-4ca2-80e8-69512ef563ff" code="msgtext">
<description>Not all the data was backed up into /var/lib/psa/dumps/domains/domain.de/databases/rss_2 successfully. /usr/lib/postgresql/9.5/bin/pg_dump: invalid option -- &#39;i&#39;
Try &quot;pg_dump --help&quot; for more information.
</description>
</message>
</object>
</object>
</object>
</execution-result>

 

[Sergey Prohorov]

Hello. Could you please post output of the following commands:
# plesk version
# grep PGSQL /etc/psa/psa.conf

 

[Tscherno]

plesk version
Product version: Plesk Onyx 17.0.17 Update #12
Update date: 2016/12/22 06:57
Build date: 2016/11/17 16:00
OS version: Ubuntu 16.04
Revision: ab6766191d3ba26e7b21255ab007fc7fc56d84c6
Architecture: 64-bit
Wrapper version: 1.2


grep PGSQL /etc/psa/psa.conf
PGSQL_DATA_D /var/lib/postgresql/9.5/main
PGSQL_CONF_D /etc/postgresql/9.5/main
PGSQL_BIN_D /usr/lib/postgresql/9.5/bin

 

[Sergey Prohorov]

The error was reproduced. I created the bug PPP-27343. It will be fixed in one of the nearest updates. Thank you for the report.