Resolved Error whith Backup PostgreSQL Databases

[Nilton Santos]

Hello everybody,

I have the error below when I try to do a Backup of Website whith PostgreSQL database.

[26633]: 2017-10-24 01:03:16.580 ERROR bfce2f4b-69d1-49d0-8c73-d7a5000e951a The psql command is absent on a server, so the dump of PostgreSQL databases can not be created.
See the atached file too.

I have one server whith PostgreSQL 9.5.8(no localhost) on Plesk Onyx 17.5.3.

Thank you for helping

 

[Nilton Santos]

The file /etc/psa/psa.conf was wrong

# PostgreSQL
PGSQL_DATA_D /var/lib/pgsql/data
PGSQL_CONF_D /var/lib/pgsql/data
PGSQL_BIN_D /usr/bin

 

[Peter Carlsson]

Can you please tell me how you run PostgreSQL 9.5.8(no localhost) ?

Have you installed 9.5.8 in CLI?

Do you run PostgreSQL in Docker?

Did you get backup working?

 

[Nilton Santos]

Hello Peter,

In this case i had added a external PostgreSQL 9.5.8 server on Plesk, and after correct the file /etc/psa/psa.conf the problem was solved!

 

[Peter Carlsson]

Thank you for answering.

My problem is how i should add a external PostgreSQL 9.5.8 server on Plesk. I cant find any step by step tutorials on how to.

I so wish that they could update the PostgreSQL service in Plesk so one could choose version and install in GUI.

Im not comfortable doing stuff in CLI.

 

[Nilton Santos]

Hello Peter,

Please, contact the Plesk support through the link below:

Plesk Help Center

They can help you

 

[Peter Carlsson]

Thank you.