Thread: vacuumdb seems not to like option -j when run from crontab
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"
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.
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.
Attachment
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?
Add a pg binary path to script
br
Kaido
br
Kaido
On Mon, 4 Dec 2023 at 18:13, Alan Hodgson <ahodgson@lists.simkin.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?
(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@lists.simkin.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?
8.4 does not support -j
On Mon, Dec 4, 2023 at 8:22 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
(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@lists.simkin.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?