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 1nMstd-0004qO-P7 for pgsql-admin@arkaria.postgresql.org; Wed, 23 Feb 2022 14:45:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nMstb-0008VQ-2O for pgsql-admin@arkaria.postgresql.org; Wed, 23 Feb 2022 14:45:35 +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 1nMsta-0008VH-La for pgsql-admin@lists.postgresql.org; Wed, 23 Feb 2022 14:45:34 +0000 Received: from mail-ot1-x336.google.com ([2607:f8b0:4864:20::336]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nMstW-0001pQ-KL for pgsql-admin@lists.postgresql.org; Wed, 23 Feb 2022 14:45:33 +0000 Received: by mail-ot1-x336.google.com with SMTP id w16-20020a056830281000b005ad480e8dd5so10586996otu.9 for ; Wed, 23 Feb 2022 06:45:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=ziyglICTE6ORiWMAhea/o/p3uWdopL/tpQyWp2XcIvc=; b=o3YfDJREdeTl/fobuD7CJN8B4ktE6ibbIPOGD3tt5Ncw0Ils9tHV4F3wPQa2NRWj4/ 7z/iUnUuanjRVCe8bCDCs/4/Q15YfbIJGl/9isYOVAIa1gvOqFvcNpNCEhCa/UJ9vK0P UKbAN1TifrybNiPAuk7M+YxEzAfXszud9SD1KEiGVHvqEeuTztEtW0zPgsyIlEoTT01m 0W7E+5sm+GzXttLOsbOW6rA/iJ3mMfQLzfZFfp+CCRB0Jj76ztQKGQIDny6TWj/o0/Cf bldd6yCL5IIxMGQAhQ0wS6ENQpWJr4lkTZ6qOZ2ms/XlYdLmB5TcqPwlVlXZrXDWenBy g+gA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=ziyglICTE6ORiWMAhea/o/p3uWdopL/tpQyWp2XcIvc=; b=EecpjDpiTCfIRAuYxgxdu4avUA9BQZlxLsLVxdhPYVw2SDTkW2JrKF/J6i0oBzqW6a SYDtWRKOj3xKrEZQ2WVWS5fp4hcdSj3TrHIZ+yurf41rlPAD/t7LOVgeOYSRJDrw1mD3 R+8TPePi9m4u0shL0k/bdfCj73apnqNv//TNLAP0KOkpFU+nHiAw59dcO3n4iOh669+B FsiRLgH0v+nzfM0QmdLo8WhyFIeZUOjPi6zJ7VN2T4sf7bCXgI/UkWjx/UIsKj3OSEmW 0dyBQP1SPz6JI8K47UGXynaAW4JZFyj0DRempFt9+03nZUbOkEvpDgRPEPN/63t3C1SB Z1Sw== X-Gm-Message-State: AOAM530KhoCqFu6iHWUQpQ6vfqUU7YYYbU8eRVWVrEb5Un++1quBTypa r3hXnfOUZcwb9UdhWQfMEltoZY81sac= X-Google-Smtp-Source: ABdhPJxrtWleppouMUfxWzqPiTNQJv6qI8NOPPQHzyty1hA2rC4Hh6woTpJSuPfokhd8E9Ipzmaikw== X-Received: by 2002:a05:6830:1d98:b0:5ad:53b1:78a3 with SMTP id y24-20020a0568301d9800b005ad53b178a3mr7595364oti.210.1645627529637; Wed, 23 Feb 2022 06:45:29 -0800 (PST) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id a32sm3251488oaf.10.2022.02.23.06.45.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 23 Feb 2022 06:45:29 -0800 (PST) Subject: Re: Pg_dump backup To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <17994ffb-4dac-99aa-b889-523d2f579c83@gmail.com> Date: Wed, 23 Feb 2022 08:45:28 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.14.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/23/22 8:14 AM, Daulat wrote: > H Team, > > I need your advice. > How can we ensure the pg_dump backup is successful? Check the return code immediately after pg_dump completes: pg_dump .... echo $? If it's 0, then pg_dump exited successfully. Of course, it's always good to test the dump files by restoring them on non-prod systems. -- Angular momentum makes the world go 'round.