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

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: vacuumdb seems not to like option -j when run from crontab
Дата
Msg-id CANzqJaAnOm_3ix3DxAMmV5w60qPRZjmNEjZUs_ZDqE2iMB02Sw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: vacuumdb seems not to like option -j when run from crontab  (Alan Hodgson <ahodgson@lists.simkin.ca>)
Ответы Re: vacuumdb seems not to like option -j when run from crontab
Список pgsql-general
Дерево обсуждения
(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?

В списке pgsql-general по дате отправления:

Предыдущее
От: kaido vaikla
Дата:
Сообщение: Re: vacuumdb seems not to like option -j when run from crontab
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Help understand why DELETE is so slow