Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rABZI-005FK3-U5 for pgsql-general@arkaria.postgresql.org; Mon, 04 Dec 2023 16:13:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rABZH-000A75-9I for pgsql-general@arkaria.postgresql.org; Mon, 04 Dec 2023 16:13:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rABZG-000A6D-L7 for pgsql-general@lists.postgresql.org; Mon, 04 Dec 2023 16:13:10 +0000 Received: from bongo.birch.relay.mailchannels.net ([23.83.209.21]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rABZD-008mDh-PD for pgsql-general@lists.postgresql.org; Mon, 04 Dec 2023 16:13:09 +0000 X-Sender-Id: _forwarded-from|207.216.206.240 Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id 8045D841AD7 for ; Mon, 4 Dec 2023 16:13:04 +0000 (UTC) Received: from outbound2o.ore.mailhop.org (unknown [127.0.0.6]) (Authenticated sender: duocircle) by relay.mailchannels.net (Postfix) with ESMTPA id 4388484315D for ; Mon, 4 Dec 2023 16:13:04 +0000 (UTC) ARC-Seal: i=2; s=arc-2022; d=mailchannels.net; t=1701706384; a=rsa-sha256; cv=pass; b=4C5NYsRgO7xJRP2sXxHT+Rwdk3B0Vo498lZiZVT/dqPP8A0FEbdyOyXQPYOex5BdHmqfxF Y7BOsKEQytyUwy5ZEaNf1EjG0jVCZWAq0gnXIgiVCztXAvFcxOePNca7h4bwY+M4ShYy/s 6B1kUF36oI/dzgLn6sADNGSW9S71rerYJeh+Ka+yaLhuGWt7sJpaUog+OojJdsKR60THdT c5v/ttpgWhEAOagcatPUd018EKWmjMXIXnfcK32xtC5HnKDZN9C7JYxORQBWC3SIyINCiB jd3/Y0bxvp287CrGmK8rcBZKGkNWfvKE6cck+7bxoHAolzqQZbbJtSMv/ltWvA== ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1701706384; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references:dkim-signature; bh=Ya2psqDaBDorU2l9DsF6qGshxK3DOFKqhk2l6VC7I70=; b=CNJTMa9BzFHBgPqNJuu7bhO8E0xskcofh0MGbfpIzFkyhsuKcXTLU5JU6OinzyPTe+Fu5y nnOrQdGHFpxPw/Eahv6pe6JGn8VNmvI7JVdiYj+pjilRV0oAOVJQ+baFwDSL+xFHrlV12G LibTIyxbEKtdRP6kXLbcwtQGznV6KgKMvXJHxeSZi1nqF8xYnG1SMfGA2uzWRYdaofKBpK Ocil+eXp6mtvbZyIOrwDwf2mIeyXfYT9cb8vMV/+HsLkaSAD1cYydkW/AtyUaxCfJFVVvo POeGYix6SPwdGt3fdODJvirAp2iYTtDlekyPY1uGNEvJbvOZ2Uw6EPy51FXWhg== ARC-Authentication-Results: i=2; rspamd-696ff67dc8-5hgkh; arc=pass ("outbound.mailhop.org:s=arc-outbound20181012:i=1"); auth=pass smtp.auth=duocircle smtp.mailfrom=ahodgson@lists.simkin.ca X-Sender-Id: _forwarded-from|207.216.206.240 X-MC-Relay: Forwarding X-MailChannels-SenderId: _forwarded-from|207.216.206.240 X-MailChannels-Auth-Id: duocircle X-Blushing-Ruddy: 7063c25f311f5392_1701706384297_1417432271 X-MC-Loop-Signature: 1701706384297:3000162967 X-MC-Ingress-Time: 1701706384297 Received: from outbound2o.ore.mailhop.org (outbound2o.ore.mailhop.org [54.187.213.119]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.118.12.6 (trex/6.9.2); Mon, 04 Dec 2023 16:13:04 +0000 ARC-Seal: i=1; a=rsa-sha256; t=1701706384; cv=none; d=outbound.mailhop.org; s=arc-outbound20181012; b=a1PB8vzgFe6cp0lBtbrteE4mQoOkJ+Y31BcqTOXqJ/TbgblE1NlV9Z8y/Y3TU5ODh73X22N1krmVG 2UPQmB3azugDM3nGimzoxX/BQwWo/FAlGXlAX32ayYeVdFJAf5weT4f08CZxlT3i6ZSpVbwTM8bvp9 079G9nnkxpu4lnLVusXllpMDaQoaej5DAJdNLTtKYyhSbEjIIms2LAr+G8lGwwWdUZoo6p5PeLiIe6 jVZEa+Z4zFXzvD73BsHrgz6+7RNNUBQISqjTQSgb+wud0b6eFA6w9SGhPrQnT5ELrGoDrvZ+OVXfvZ VNl1dCj4cdlpKxGxURoU/S7cxFMZDDA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=outbound.mailhop.org; s=arc-outbound20181012; h=mime-version:content-type:references:in-reply-to:date:to:from:subject: message-id:dkim-signature:dkim-signature:dkim-signature:from; bh=Ya2psqDaBDorU2l9DsF6qGshxK3DOFKqhk2l6VC7I70=; b=GtpH/pT1JKI1wBbI8JUP3qUUfgda/pnMRSzji0bXTrm7sXSMNT4ySlmrfwiPVW1WZuKaXG9n1jXO1 QoYhb9H/FTIRCx66SPEja0XoMuNJCHKVJvfnC5BO9NoNUnvGL5qbLHJXEVw4vZkcTri3kfjdFy1aeG yBd95+bab+pFtL3MfJpu5Ta6LgkGJCcUFrKFl5xTyDd2kye/lHMaYIvqomySp/w4RRGq8CVSFNU6dS MlD4HjbaLb/YsIg4fWtR1piQNvgPeRxv3cZM7QGGgJOB61rHE3Ucrr6KqE/m9uQv6bzrRi8mzcMpCz JzGCOBgHbsIcj1e5Od5WhERdMYh7c+g== ARC-Authentication-Results: i=1; outbound4.ore.mailhop.org; spf=pass smtp.mailfrom=lists.simkin.ca smtp.remote-ip=172.105.109.24; dkim=pass header.d=lists.simkin.ca header.s=athena header.a=rsa-sha256 header.b=rzk5eaa2; dmarc=pass header.from=lists.simkin.ca; arc=none header.oldest-pass=0; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lists.simkin.ca; s=duo-1610662143981-d3c4c825; h=mime-version:content-type:references:in-reply-to:date:to:from:subject: message-id:from; bh=Ya2psqDaBDorU2l9DsF6qGshxK3DOFKqhk2l6VC7I70=; b=gaWIhXrC3BY4nDZl0xG2LETcplZP9XrPbsU4ciGK/KIu2UlEBQxX6x7Izng0KPkOoYQipeGtAe2Ai 3OD9ROGo8AGti6icpcYlmM8kIc6BeQYVUujtvfU7xLex1yGfHs2mKieOppvPXa2nZFfoceDG54lVEy m997NeeV0PBKIbMU= DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outbound.mailhop.org; s=dkim-high; h=mime-version:content-type:references:in-reply-to:date:to:from:subject: message-id:from; bh=Ya2psqDaBDorU2l9DsF6qGshxK3DOFKqhk2l6VC7I70=; b=bdhEK/AKuO+lYOTCUA6bOxHEfbz5KWwmi0YicrP1WVrfFk8pR54X5s5WUbDVQkRVcwaqZJnvLWKPY YERlumxQ0wTQ996YxwiQaA9jVbMnN4GRwAB0f4qmCrg+cluSFmBGWxQ6FTZf7coPEW6iSmTfdntcD7 cqe2WdJ4Q5nJosFxyhrhpkoXwtsVwoI1Hbb77bgpI8L7Ei2N2BafLcN6fcSqv2LhKX+ZoCh3AFzvbT xbA4EoJBxePZF5XrX+HFnFMEgeustdjoo+MhAkEIDJSD+vxdNq7pJ5KsebA23DPUeA1YAqXxCOtgSG Ynd7G0tjxXjLG5CuTWQhIErmhu05/qQ== X-Originating-IP: 172.105.109.24 X-MHO-RoutePath: c2lta2lu X-MHO-User: ff4f11a7-92bf-11ee-b92d-2b2b5a144ce7 X-Report-Abuse-To: https://support.duocircle.com/support/solutions/articles/5000540958-duocircle-standard-smtp-abuse-information X-Mail-Handler: DuoCircle Outbound SMTP Received: from athena.simkin.ca (athena.simkin.ca [172.105.109.24]) by outbound4.ore.mailhop.org (Halon) with ESMTPSA id ff4f11a7-92bf-11ee-b92d-2b2b5a144ce7; Mon, 04 Dec 2023 16:13:03 +0000 (UTC) Received: from skynet.simkin.ca (d207-216-206-240.bchsia.telus.net [207.216.206.240]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (secp384r1) server-digest SHA384) (No client certificate requested) by athena.simkin.ca (Postfix) with ESMTPSA id C33E0C6BB7CB for ; Mon, 4 Dec 2023 08:12:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=lists.simkin.ca; s=athena; t=1701706357; bh=KwjRbfOxEz2gruN0wyzhJ+RuP0rBrF5siHjMtdUvtpA=; h=Subject:From:To:Date:From:To:Subject:Date:Reply-To; b=rzk5eaa2Av3z5H+AjeTbeoqHydri3C5NfQRtEYKPT0AWbkzGUL9XPrvWSXguYggwz a5hrP3H0uUed8Ql2JAsU27vb1EyKuLnUxIrSWety2voyjf/kpw6Aa7J2mTwMLUy0Ar Fadg6VbUGhi9sLZijJL6Kb7NSmbzaqeEhawD1JIhdijUrZiYdS0l7Bk9gBzuYlv7LQ RzK9U05kouO1Nij2SAwE6zj2/H6wR86rc4qwSe8LiN6zzDU35wXlG67cYJ/pez8m7Q SNHCzGiUPrJc6aq1D1nT16othN4DEgNtyAG9mtKB83KNcrNKW1Ua/Ud6GLjqjoUtBq V7EPVXKluh77g== Received: from skynet.simkin.ca (skynet.simkin.ca [IPv6:::1]) by skynet.simkin.ca (Postfix) with ESMTP id 5644222D50FCA for ; Mon, 4 Dec 2023 08:13:00 -0800 (PST) Message-ID: <2ad37caf6e1554fc6a12830fbc6e01a35adcd0e3.camel@lists.simkin.ca> Subject: Re: vacuumdb seems not to like option -j when run from crontab From: Alan Hodgson To: pgsql-general@lists.postgresql.org Date: Mon, 04 Dec 2023 08:13:00 -0800 In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-Zd+B2ko11/U3BjwwTmsZ" X-PGP-Key: fp="EF82 6F8D A3BA A096 FFA3 05F2 A7A0 40A5 34E5 AA0B"; id="0x34E5AA0B"; get= User-Agent: Evolution 3.48.4 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-Zd+B2ko11/U3BjwwTmsZ Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable On Mon, 2023-12-04 at 11:07 -0500, Ron Johnson wrote: > PG 9.6.24 (Yes, it's EOL.) >=20 > 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" >=20 > But not when running from crontab: > vacuumdb -p5433 -j4 --analyze tap_d > vacuumdb: invalid option -- 'j' > Try "vacuumdb --help" for more information. >=20 > Obviously I'm missing something, but don't see what it is.=A0 > Attached is the script it runs from. >=20 Is your user and PATH the same? ie. are you running the same vacuumdb executable? --=-Zd+B2ko11/U3BjwwTmsZ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
On Mon, 2023-12-04 at 11:07 -0500, Ron Johnson wr= ote:
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 databas= e "tap_d"

But not when running from cro= ntab:
vacuumdb -p5433 -j4 --analyze tap_d<= br>vacuumdb: invalid option -- 'j'
Try "vacuumdb --help" for more inform= ation.

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?

--=-Zd+B2ko11/U3BjwwTmsZ--