From: David Steele <david@pgmasters.net>
To: Craig James <cjames@emolecules.com>
To: pgsql-admin@postgresql.org
Subject: Re: pgbackrest: backup from standby
Date: Mon, 20 Aug 2018 16:10:33 -0400
Message-ID: <d68fd488-d572-f5db-0732-22f94de2e107@pgmasters.net> (raw)
In-Reply-To: <d67a6a2a-5b8b-ee93-ea3f-464b8d8aa6ce@pgmasters.net>
References: <CAFwQ8rcyq5ymqsqEV0VSyqeVZvhEh-qmU2+fK3EXA0C8uHNWzg@mail.gmail.com>
<d67a6a2a-5b8b-ee93-ea3f-464b8d8aa6ce@pgmasters.net>
On 8/20/18 3:36 PM, David Steele wrote:
> On 8/20/18 12:12 PM, Craig James wrote:
>
>> There are sections in the user guide on /Backup from a Standby
>> <https://pgbackrest.org/user-guide.html#standby-backup>/ and on /S3
>> Support <https://pgbackrest.org/user-guide.html#s3-support>/, but I
>> can't sort out how to combine them. Apparently I need to define
>> pg1-host/pg1-path, and pg2-host/pg2-path, then a stanza for S3. But does
>> all this go in the pgbackrest.conf of the primary ("radon" in my case),
>> or on the standby, or somehow split across both?
>
> You have an asymmetrical configuration here since there is not backup
> server and shown in the pgBackRest docs. That makes configuration quite
> a bit harder and make failover harder.
Sorry, this was a bit garbled. I meant to say:
You have an asymmetrical configuration here since there is no repo
server as shown in the pgBackRest docs. That makes configuration quite
a bit harder and makes failover harder.
In the end, I think your migration would be made simpler by migrating
the pgBackRest repository before the database.
Is saving bandwidth an overriding concern or just a nice to have?
Regards,
--
-David
david@pgmasters.net
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: david@pgmasters.net, cjames@emolecules.com
Subject: Re: pgbackrest: backup from standby
In-Reply-To: <d68fd488-d572-f5db-0732-22f94de2e107@pgmasters.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox