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

(Sorry for top-posting. Blame gmail.)

Turns out that PG 8.4.20 is also installed from the RHEL repository.

Thanks.

On Mon, Dec 4, 2023 at 11:13 AM 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?
>
>