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 1lpbLB-0001B6-Px for pgsql-admin@arkaria.postgresql.org; Sat, 05 Jun 2021 18:48:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lpbL9-0000RC-LT for pgsql-admin@arkaria.postgresql.org; Sat, 05 Jun 2021 18:48:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lpbL9-0000R4-AZ for pgsql-admin@lists.postgresql.org; Sat, 05 Jun 2021 18:48:11 +0000 Received: from mail-ot1-x336.google.com ([2607:f8b0:4864:20::336]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lpbL5-00046K-Tl for pgsql-admin@lists.postgresql.org; Sat, 05 Jun 2021 18:48:10 +0000 Received: by mail-ot1-x336.google.com with SMTP id w23-20020a9d5a970000b02903d0ef989477so8088817oth.9 for ; Sat, 05 Jun 2021 11:48:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=ovhn8qmSWJbII3K7cdVTta5TmWgZJ0+Itf1xKH3fv3Q=; b=jezhKqwkYkEACzrl9xEf81OHLC3vV5gmoMmVcHi4+RFwo2bH2q8XIliWdmwh4lPNGA cMFwGd4i/LFR3TsE5BaptUgSrgQydsqd+VOG/fWFNuvWpG2N+dpVUQARmImBcRRyhG0N i/tV7d4EPNuEdt9ExkRnyk+e1y4JMmyvUHTGXIPrBNfbaMtihOu2qxR5duqWqqHoqt3m M3MWuuJqPa2kDtXXyiCIGuImk8roZaBx+MAKGAUU+YzHsLl447bC779HML8bsPKCW24g S2wTB8bLQgfoQPpaztCJkxQErkJCtAO0y6wFfDJOuFAPv5YREXdCnseqBsAo+PL4RStY yq+Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=ovhn8qmSWJbII3K7cdVTta5TmWgZJ0+Itf1xKH3fv3Q=; b=hSxFECKJAJ5mPnWs9PY3k6jUglmwv7XYEZg84v0llSN4rHGcmukuKLWPs53OBpbU2f yXtxEnUmsvh12lSffY7uTZ7RK9OlLTosLJ79FSYoTj6edwPTbXWGIF5IwINX0j2k9bjr QR54mahA2GvIWtvpZPFey6Jta8m8nnWv1BPnxeIM0DCY68ywPXflM1UHKFzJIF0moOP8 SCbrH6/yD147heAEvB+1dEKxau3eiYc92LdkKPOsCRNOhd2wgZGKKlTeKGAcFfsZzztK u3J30Jp7HMlv4bZP102uvmJJqo7R9dWGWc7QVK/qbqIQE6SxNj56zlCQ/wuw6voaLR+n hkZA== X-Gm-Message-State: AOAM532uyEM2a30gsCibcw26Vq8+l0cmCU0omp+Kvs1XV0XXJXzGDVYL 42Zw0h+cGRycFb9lLlMdEgm6Gv5S69Y4Fg== X-Google-Smtp-Source: ABdhPJyLgeeF8Wc9jI+AvTeQOROggzA6bM6iMuj5k0fP0xNI+gAAu03nXWrrh9yMzJSbSxWL5Pa4hg== X-Received: by 2002:a9d:226c:: with SMTP id o99mr7898620ota.134.1622918885468; Sat, 05 Jun 2021 11:48:05 -0700 (PDT) Received: from [192.168.88.10] (ip174-67-141-204.no.no.cox.net. [174.67.141.204]) by smtp.googlemail.com with ESMTPSA id n13sm1200367oop.8.2021.06.05.11.48.04 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 05 Jun 2021 11:48:05 -0700 (PDT) Subject: Re: Automate pg_basebackup in linux To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: <345839be-63ea-5a68-da74-4121cfddbf88@gmail.com> Date: Sat, 5 Jun 2021 13:48:04 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------EF3751B30B3C6E635F1E72D3" Content-Language: en-US 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. --------------EF3751B30B3C6E635F1E72D3 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 6/5/21 12:14 PM, SMAX Inbound wrote: > > Hi All, > > is there any script to automate pg_basebackup in linux using cron job.. > i.e. shell script that will automate taking basebackup weekly, and > removing previous backup and wal files once base backup is successfully > completed... > If you know any shell scripting languages, such a script is easy to write.  (Are you saying that you don't know "shell"?) -- Angular momentum makes the world go 'round. --------------EF3751B30B3C6E635F1E72D3 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit On 6/5/21 12:14 PM, SMAX Inbound wrote:

Hi All,

is there any script to automate pg_basebackup in linux using cron job.. i.e. shell script that will automate taking basebackup weekly, and removing previous backup and wal files once base backup is successfully completed...


If you know any shell scripting languages, such a script is easy to write.  (Are you saying that you don't know "shell"?)

--
Angular momentum makes the world go 'round.
--------------EF3751B30B3C6E635F1E72D3--