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

2023-12-05 Thread Joshua Drake
8.4 does not support -j On Mon, Dec 4, 2023 at 8:22 AM Ron Johnson 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 > wrote: > >> On Mon, 2023-12-04 at 11:07 -050

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

2023-12-04 Thread Ron Johnson
(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 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 -

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

2023-12-04 Thread kaido vaikla
Add a pg binary path to script br Kaido On Mon, 4 Dec 2023 at 18:13, Alan Hodgson 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 -

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

2023-12-04 Thread Alan Hodgson
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 cronta