Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ptklc-0005QM-An for pgsql-admin@arkaria.postgresql.org; Tue, 02 May 2023 07:49:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ptklb-0007zh-6B for pgsql-admin@arkaria.postgresql.org; Tue, 02 May 2023 07:49:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ptkla-0007zX-S8 for pgsql-admin@lists.postgresql.org; Tue, 02 May 2023 07:49:42 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ptklY-0005Ck-GS for pgsql-admin@lists.postgresql.org; Tue, 02 May 2023 07:49:41 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-b9dcd91a389so4123142276.2 for ; Tue, 02 May 2023 00:49:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1683013779; x=1685605779; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=umQt6nspsLfm2HOqeqsroFEplpvOrbGtGHvP8QsR4Z0=; b=R33gncE5sylYiykQm2AUNzCOz4qi95kMhanvKPJLG6uZ8zBOeTHuJrIp6+o5ld+Pp4 vH31CgOaX9XSGnJy20LmxO/KgOdQLsizXoSMhFGPY3bmiHZs4plZfkmQk3bTlvf4G8WQ f+xvPlW4+9HFGwPyb8CoZB3vuc2VhzlfXPzP9II/sqmBwyDtciEgZG8QUmPwE8bOfQV5 TlwkZ1Pdl1Y3oxFGekGp7uuh43tIruh8AitfeUEpU8i2QcP/KCt+TIXVRF76IHNh1QLj H8aHYiGK7dvBpIe9hWjljUpxVZ4FWgkDuZ9uBNSjB+OUO/21Mi22UUptiATXTQwTURfE t+8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1683013779; x=1685605779; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=umQt6nspsLfm2HOqeqsroFEplpvOrbGtGHvP8QsR4Z0=; b=GTugWqUkrCqIGIn9vmgiadOlLBqSqq5vNQ9lq0qfE3cwCqetaJ1IsnxJ5bd/L22VSf o/jjoclKfJnWMmsUt7UzUM4+cWWgUREG2HAuxCDEC7KRUz3fRATs+yv4oGvEcuUE5mlu 3I+RnTB5ZiSBSaPvxABK1T8Wq/fwUeSFVovxCfJSSW4Wo3I+e3QnqKF48WLuiHhAdh9V NgUZ+zFyr1A3OTdUdewwFacWiMec1eid1AQ+A109J2NKNgYHsSVLFQCTjojVKTAGzmbj btL6Uwu+t0iW3GPb4fXqzBZiE9BIxwnziKyFSBoBvwKcQQUw8dxTINzI3HEkl6G/v/7c 5zkg== X-Gm-Message-State: AC+VfDxIrQg31WoASWtwUHImFBeNHAAa5MeiZ9jxmTgi6pTgJC4/W1Wc 7GaWhmAIIuFLR+uEBXm2CQfI3nHz6gA= X-Google-Smtp-Source: ACHHUZ7aaBW27v+OK0z1XImfYwRDNsbbX4qGBwoEd22j+DnZJb8ahmiZG4+DJbhGQ5Es70DCs4P3vQ== X-Received: by 2002:a25:b322:0:b0:b96:752:4635 with SMTP id l34-20020a25b322000000b00b9607524635mr14647972ybj.63.1683013779487; Tue, 02 May 2023 00:49:39 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:d08:786:d5c1:fde6? ([2600:1700:bd2c:b810:d08:786:d5c1:fde6]) by smtp.googlemail.com with ESMTPSA id i125-20020a255483000000b00b9a65b05384sm3162294ybb.15.2023.05.02.00.49.39 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 02 May 2023 00:49:39 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------GHNVFLgkAPI5650inzS83Hhk" Message-ID: <8dcd5f2f-659d-811c-a68e-b93fda8a4ee2@gmail.com> Date: Tue, 2 May 2023 02:49:38 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: pg_dump why no indicator of completion Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: <6EF026A5-5CEC-48AB-B27E-C225DAE6E10A@elevated-dev.com> <491f094b-93f9-6a7d-1846-901aa583171c@gmail.com> From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------GHNVFLgkAPI5650inzS83Hhk Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 5/1/23 21:42, richard coleman wrote: > As these databases are both in constant use, with users that have, how do > I put it kindly, interesting workflows, it really isn't possible to cron a > backup job. You can't edit crontab to run a script a few minutes from "now"? (My "postgres" crontabs are replete with commented out /ad hoc/ scripts which get uncommented and rescheduled as needed.) -- Born in Arizona, moved to Babylonia. --------------GHNVFLgkAPI5650inzS83Hhk Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 5/1/23 21:42, richard coleman wrote:
As these databases are both in constant use, with users that have, how do I put it kindly, interesting workflows, it really isn't possible to cron a backup job.

You can't edit crontab to run a script a few minutes from "now"?  (My "postgres" crontabs are replete with commented out ad hoc scripts which get uncommented and rescheduled as needed.)

--
Born in Arizona, moved to Babylonia.
--------------GHNVFLgkAPI5650inzS83Hhk--