Re: Barman versus pgBackRest

That was about barman, in the barman group.  This is asking about
pgbackrest...  :)

So: does pgbackrest have this ability which barman does not have? The
"--db-include" option seems to indicate that you can restore a single db,
but does indicate whether or not you can rename it.

On 09/04/2018 08:44 AM, Thomas Poty wrote:
> Your problem looks like this one ;-)
> https://groups.google.com/forum/#!topic/pgbarman/kXcEpSLhw8w
> <https://groups.google.com/forum/#%21topic/pgbarman/kXcEpSLhw8w>
> answer may help
>
> Physical backup/restore operates on a whole cluster...
>
> Le mar. 4 sept. 2018 à 14:47, Ron <ronljohnsonjr(at)gmail(dot)com
> <mailto:ronljohnsonjr(at)gmail(dot)com>> a écrit :
>
> On 09/04/2018 07:14 AM, Thomas Poty wrote:
>> > Do you just change the IP address of the "restore target"?
>> Do you expect a typical restore command?
>
> I'm investigating barman and pgBackRest to replace our exitsing
> NetBackup system, so don't know what you mean by "typical restore
> command".
>
> Here are our typical use cases:
>
> 1. If my barman backup server has full backups, diffs and WALs for
> database server MAIN_PG_SERVER, which hosts databases D1, D2 and D3,
> how much work is it to do a PITR restore of D2 to a *different* Pg server?
>
> 2. Can I restore an older copy of database D2 to MAIN_PG_SERVER,
> *giving it a new name* (so that now there would be databases D1, D2,
> D3 *and D2_OLD*)?  That's pretty trivial on SQL Server, and something
> I've had to do before so the operations staff can research a problem.)
>
> Thanks
>
> --
> Angular momentum makes the world go 'round.
>

--
Angular momentum makes the world go 'round.