pg_dump: command not found

[cuoredisardegna]

Hi to All,

could Anyone resolve this problem?


It was made a file named backup.sh which contains :

Code: Select all

pg_dump -h localhost -U user -c  -R -v nome_database -n nome_schema > /percorso/dove/salvare/il/file.sql

If the file is executed by the operator it goes ok. It does not require password therefore the pgpass file was configured.

But if the file is executed trough crontab it does not go.
The error message is the subiect:

Code: Select all

pg_dump: command not found

.

Tanks in advance.
Gianni Pinna.

[Roberto Blasco]

Are you working with the bundled versión of postgres ?

[ROCLASI]

Hi Gianni,

You should use the full path to the pg_dump executable. I don't think cron jobs will have any environment variables set from the user.

Hope this helps.

[cuoredisardegna]

Hi Robert,
it is right.
Tank You very much for Your always precious help.
Good year, Robert.
The time is what the men have more than the angels to deserve.
Gianni Pinna