Subject: Re: pg_backrest no longer backing up
To: Aldo Sarmiento <aldo@bigpurpledot.com>, pgsql-admin@postgresql.org
References: 
 <CAHX=r6yti58x1z4y8q_zqr_P+8_Aq5_uPKSJDu1xDaV+rtjQmA@mail.gmail.com>
 <72f3c86c-8b35-783d-a117-8a72d9abb2d9@pgmasters.net>
 <CAHX=r6w0DfDWfJf=3wXo_yEsY5n18Tm-r8WWSpFjx7XUHFMxGw@mail.gmail.com>
From: David Steele <david@pgmasters.net>
Message-ID: <06ba49be-1ef6-b979-339b-a4af7e933ed1@pgmasters.net>
Date: Mon, 13 Mar 2017 16:34:48 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:45.0)
 Gecko/20100101 Thunderbird/45.8.0
MIME-Version: 1.0
In-Reply-To: 
 <CAHX=r6w0DfDWfJf=3wXo_yEsY5n18Tm-r8WWSpFjx7XUHFMxGw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi Aldo,

On 3/8/17 5:53 PM, Aldo Sarmiento wrote:
> 
> Actually got it figured out. Main thing is that I should clarify that
> the aforementioned crontab was irrelevant since I was looking at the
> replica.
> 
> Once logged into master, the crontab is intact and uncommented. 

That makes sense.

> The
> problem was that a backup failed and pg_backrest was failing to start.
> 
> I tried adding auto-stop=true to conf, but it didn't help. In the end I
> just did pg_stop_backup() and things are running smoothly now.

The option is actually stop-auto:

http://www.pgbackrest.org/user-guide.html#backup/option-stop-auto

But it wasn't added until 0.80 so wouldn't work for you anyway.

> As for the upgrade, yes that's a need we have. Just trying to see if we
> can migrate our current backups to work with the new version so we don't
> lose ability for PITR.

It might be possible but would require specialized knowledge and custom
code.  We decided to make a clean break at 1.0 and require users to
create a new repository due to the number of changes in the format.

Regards,
-- 
-David
david@pgmasters.net


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin