Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Johnson
Subject vacuumdb seems not to like option -j when run from crontab
Date
Msg-id CANzqJaAbSRD1aPtkL_5bj16Gi77Hi=-eVqDVThGuBa4Sxgbn1w@mail.gmail.com
Whole thread Raw
Responses Re: vacuumdb seems not to like option -j when run from crontab  (Alan Hodgson <ahodgson@lists.simkin.ca>)
List pgsql-general
Tree view
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.

Attachment

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: libpq crashing on macOS during connection startup
Next
From: Alan Hodgson
Date:
Subject: Re: vacuumdb seems not to like option -j when run from crontab