Re: Barman disaster recovery solution

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: "Ahmed, Nawaz" <Nawaz(at)fast(dot)au(dot)fujitsu(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Barman disaster recovery solution
Date: 2019-02-28 07:21:55
Message-ID: 9331ddc5-ebfb-0328-3b88-c1fa04b9b3af@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 28/2/19 1:08 π.μ., Ahmed, Nawaz wrote:
>
> Hi,
>
> I believe the "file copy" method (listed in the table) in pgbackrest is based on pg_basebackup, so i think it should be "pg_basebackup over ssh" as pgbackrest internally calls pg_basebackup. David
> Steele can correct me.
>
No, apparently pgbackrest does not rely on pg_basebackup. Have you ever heard pg_basebackup supporting diff and incr backups ? Or checksums? Or compression ? Or aborted backup resumption ?
>
> Best Regards,
>
> **
>
> *Nawaz Ahmed
> Software Development Engineer
>
> Fujitsu Australia Software Technology Pty Ltd*
> 14 Rodborough Road, Frenchs Forest NSW 2086, Australia
> *T* +61 2 9452 9027
> Nawaz(at)fast(dot)au(dot)fujitsu(dot)com <mailto:Nawaz(at)fast(dot)au(dot)fujitsu(dot)com>
> fastware.com.au <http://fastware.com.au/>
>
> *From:*Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
> *Sent:* Wednesday, 27 February 2019 8:40 PM
> *To:* pgsql-general(at)lists(dot)postgresql(dot)org
> *Subject:* Re: Barman disaster recovery solution
>
> On 21/2/19 9:28 π.μ., Achilleas Mantzios wrote:
>
> On 21/2/19 9:17 π.μ., Julie Nishimura wrote:
>
> Does anyone use this solution? any recommenations?
>
> Thanks!
>
>
> Barman will fit most requirements. PgBackRest excels when WAL traffic goes on 100000 files/day or more. I have written an article, not yet publised, on a comparison on the 3 most known
> solutions. Will post a link as soon as it gets published.
>
>
> Hello, as promised here is my blog :
> https://severalnines.com/blog/current-state-open-source-backup-management-postgresql
>
>
>
>
> --
>
> Achilleas Mantzios
>
> IT DEV Lead
>
> IT DEPT
>
> Dynacom Tankers Mgmt
>
>
>
>
> --
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
>
> Disclaimer
>
> The information in this e-mail is confidential and may contain content that is subject to copyright and/or is commercial-in-confidence and is intended only for the use of the above named addressee.
> If you are not the intended recipient, you are hereby notified that dissemination, copying or use of the information is strictly prohibited. If you have received this e-mail in error, please
> telephone Fujitsu Australia Software Technology Pty Ltd on + 61 2 9452 9000 or by reply e-mail to the sender and delete the document and all copies thereof.
>
>
> Whereas Fujitsu Australia Software Technology Pty Ltd would not knowingly transmit a virus within an email communication, it is the receiver’s responsibility to scan all communication and any files
> attached for computer viruses and other defects. Fujitsu Australia Software Technology Pty Ltd does not accept liability for any loss or damage (whether direct, indirect, consequential or economic)
> however caused, and whether by negligence or otherwise, which may result directly or indirectly from this communication or any files attached.
>
>
> If you do not wish to receive commercial and/or marketing email messages from Fujitsu Australia Software Technology Pty Ltd, please email unsubscribe(at)fast(dot)au(dot)fujitsu(dot)com
>

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2019-02-28 07:47:11 Overloaded && operator from intarray module prevents index usage.
Previous Message Achilleas Mantzios 2019-02-28 07:08:42 Re: Barman disaster recovery solution