Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb seems not to like option -j when run from crontab - Mailing list pgsql-general

From Alan Hodgson
Subject Re: vacuumdb seems not to like option -j when run from crontab
Date
Msg-id 2ad37caf6e1554fc6a12830fbc6e01a35adcd0e3.camel@lists.simkin.ca
Whole thread Raw
In response to vacuumdb seems not to like option -j when run from crontab  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: vacuumdb seems not to like option -j when run from crontab  (kaido vaikla <kaido.vaikla@gmail.com>)
Re: vacuumdb seems not to like option -j when run from crontab  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: vacuumdb seems not to like option -j when run from crontab
Next
From: kaido vaikla
Date:
Subject: Re: vacuumdb seems not to like option -j when run from crontab