Re: Automate pg_basebackup in linux

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Automate pg_basebackup in linux
Date: 2021-06-07 17:11:10
Message-ID: ee046be6-1d5c-b29c-2286-533cfd3e1ae4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 6/7/21 10:56 AM, Stephen Frost wrote:
> Greetings,
>
> * Ron (ronljohnsonjr(at)gmail(dot)com) wrote:
>> On 6/5/21 12:14 PM, SMAX Inbound wrote:
>>> 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"?)
> Writing a script that actually does everything correct is actually
> really hard, unfortunately. I know, I tried (and using perl too, not
> just unix shell...). Leveraging pg_basebackup makes it a bit easier as

That's what I meant: script to run pg_bb.

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2021-06-08 01:19:36 Re: patroni recovery_min_apply_delay parameter
Previous Message Stephen Frost 2021-06-07 15:56:34 Re: Automate pg_basebackup in linux