Re: vacuumdb seems not to like option -j when run from crontab

Add a pg binary path to script
br
Kaido

On Mon, 4 Dec 2023 at 18:13, Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca> wrote:

> On Mon, 2023-12-04 at 11:07 -0500, Ron Johnson wrote:
>
> PG 9.6.24 (Yes, it's EOL.)
>
> When running "vacuumdb -p5433 -j4 --analyze tap_d" from a bash prompt, it
> works as expected:
> $ vacuumdb -p5433 -j4 --analyze tap_d
> vacuumdb: vacuuming database "tap_d"
>
> But not when running from crontab:
> vacuumdb -p5433 -j4 --analyze tap_d
> vacuumdb: invalid option -- 'j'
> Try "vacuumdb --help" for more information.
>
> Obviously I'm missing something, but don't see what it is. Attached is
> the script it runs from.
>
>
> Is your user and PATH the same? ie. are you running the same vacuumdb
> executable?
>
>