Re: Barman disaster recovery solution

2019-03-01 Thread David Steele
Achilleas, On 2/27/19 11:39 AM, Achilleas Mantzios wrote: 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

RE: Barman disaster recovery solution

2019-02-28 Thread Ahmed, Nawaz
Sent: Thursday, 28 February 2019 7:41 PM To: Achilleas Mantzios ; Ahmed, Nawaz ; pgsql-general@lists.postgresql.org Subject: Re: Barman disaster recovery solution On 2/28/19 9:21 AM, Achilleas Mantzios wrote: > On 28/2/19 1:08 π.μ., Ahmed, Nawaz wrote: >> >> Hi, >> >&g

Re: Barman disaster recovery solution

2019-02-28 Thread David Steele
On 2/28/19 9:21 AM, Achilleas Mantzios wrote: 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

Re: Barman disaster recovery solution

2019-02-27 Thread Achilleas Mantzios
* 14 Rodborough Road, Frenchs Forest NSW 2086, Australia *T* +61 2 9452 9027 na...@fast.au.fujitsu.com <mailto:na...@fast.au.fujitsu.com> fastware.com.au <http://fastware.com.au/> *From:*Achilleas Mantzios *Sent:* Wednesday, 27 February 2019 8:40 PM *To:* pgsql-general@lists.postgresql.or

Re: Barman disaster recovery solution

2019-02-27 Thread Achilleas Mantzios
On 27/2/19 6:52 μ.μ., Mark Fletcher wrote: On Wed, Feb 27, 2019 at 1:39 AM Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote: Hello, as promised here is my blog : https://severalnines.com/blog/current-state-open-source-backup-management-postgresql Nice blog post. If

Re: Barman disaster recovery solution

2019-02-27 Thread David Steele
On 2/27/19 4:48 PM, Achilleas Mantzios wrote: On 27/2/19 4:16 μ.μ., David Steele wrote: On 2/27/19 2:31 PM, Achilleas Mantzios wrote: On 27/2/19 1:58 μ.μ., rich...@simkorp.com.br wrote: Just to notice, I d o use backup from standby and WAL archive from standby. It is possible. But you have to

Re: Barman disaster recovery solution

2019-02-27 Thread Mark Fletcher
On Wed, Feb 27, 2019 at 1:39 AM Achilleas Mantzios < ach...@matrix.gatewaynet.com> wrote: > > Hello, as promised here is my blog : > > https://severalnines.com/blog/current-state-open-source-backup-management-postgresql > > Nice blog post. If you're aiming for a comprehensive run down of tools, I

Re: Barman disaster recovery solution

2019-02-27 Thread Edson Carlos Ericksson Richter
lleas Mantzios *Data: *qua, 27 de fev de 2019 06:40 *Para: *pgsql-general@lists.postgresql.org <mailto:pgsql-general@lists.postgresql.org>; *Cc:* *As! sunto:*Re: Barman disaster recovery solution On 21/2/19 9:28 π.μ., Achilleas Mantzios wrote: On 21/2/19 9:17 π.μ., Julie Nishimura wrote: Doe

Re: Barman disaster recovery solution

2019-02-27 Thread Achilleas Mantzios
ts.postgresql.org>; *Cc:* *As! sunto:*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 traffi

Re: Barman disaster recovery solution

2019-02-27 Thread Edson Carlos Ericksson Richter
o do meu Telefone LG/ -- Mensagem original-- *De: *Achilleas Mantzios *Data: *qua, 27 de fev de 2019 06:40 *Para: *pgsql-general@lists.postgresql.org <mailto:pgsql-general@lists.postgresql.org>; *Cc:* *As! sunto:*Re: Barman disaster recovery solution On 21/2/19 9:28 π.μ., Achilleas Mantzi

Re: Barman disaster recovery solution

2019-02-27 Thread Achilleas Mantzios
On 27/2/19 4:16 μ.μ., David Steele wrote: On 2/27/19 2:31 PM, Achilleas Mantzios wrote: On 27/2/19 1:58 μ.μ., rich...@simkorp.com.br wrote: Just to notice, I d o use backup from standby and WAL archive from standby. It is possible. But you have to configure standby with option of wal archive

Re: Barman disaster recovery solution

2019-02-27 Thread David Steele
On 2/27/19 2:31 PM, Achilleas Mantzios wrote: On 27/2/19 1:58 μ.μ., rich...@simkorp.com.br wrote: Just to notice, I d o use backup from standby and WAL archive from standby. It is possible. But you have to configure standby with option of wal archive "always". I guess there are issues with

Re: Barman disaster recovery solution

2019-02-27 Thread Achilleas Mantzios
*Cc:* *As! sunto:*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 10 f

Re: Barman disaster recovery solution

2019-02-27 Thread Achilleas Mantzios
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 10 files/day or more. I have written an article, not yet

Re: Barman disaster recovery solution

2019-02-21 Thread Stephen Frost
Greetings, * Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: > No backup solution (no matter which one you choose) is 100% guaranteed: your > disks may fail, your network mail fail, your memory may fail, files get > corrupted - so, setup a regular "restore" to separate "test backup

Re: Barman disaster recovery solution

2019-02-21 Thread Edson Carlos Ericksson Richter
Em 21/02/2019 04:17, Julie Nishimura escreveu: Does anyone use this solution? any recommenations? Thanks! We do use it. IMHO, those are minimum recommendations: 1) start using it! It's easy and robust. 2) for minimal impact over production servers, setup replicated servers and create

Re: Barman disaster recovery solution

2019-02-21 Thread Andreas Kretschmer
Am 21.02.19 um 08:17 schrieb Julie Nishimura: Does anyone use this solution? any recommenations? Thanks! sure, many of our customers. why not? Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com

Re: Barman disaster recovery solution

2019-02-20 Thread Achilleas Mantzios
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 10 files/day or more. I have written an article, not yet publised, on a comparison on the 3 most known

Barman disaster recovery solution

2019-02-20 Thread Julie Nishimura
Does anyone use this solution? any recommenations? Thanks!