Re: Stand by server (9.6.6) with corrupt file

2017-12-25 Thread Edson Carlos Ericksson Richter
I've used rsync method as described in PostgreSQL wiki. Database is quite large, and pg_basebackup fail after running for several hours over a 5Mbps link. To me, rsync appears to be more reliable over unstable links. Nevertheless, if some data has been corrupted during copy across the wire,

Re: Stand by server (9.6.6) with corrupt file

2017-12-23 Thread Martin Marques
El 22/12/17 a las 10:29, Edson Carlos Ericksson Richter escribió: > Environment: PostgreSQL 9.6.6 installed from yum repository. Oracle > Linux 7 EL x64. Dell servers with Raid 5 (hw). > > > I was testing our database backup system (based on pgBarman), and > discovered that one base file is corru

Re: Stand by server (9.6.6) with corrupt file

2017-12-22 Thread Edson Carlos Ericksson Richter
No, it is a normal table. *Edson Carlos Ericksson Richter* /SimKorp Ltda/ Fone: (51) 3366-7964 Embedded Image /"A mente que se abre a uma nova ideia jamais voltará ao seu tamanho original"/ - Albert Einstein Em 22/12/2017 11:42, Stephen Frost escreveu: Greetings, * Edson Carlos Ericksson

Re: Stand by server (9.6.6) with corrupt file

2017-12-22 Thread Stephen Frost
Greetings, * Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: > I was testing our database backup system (based on pgBarman), and > discovered that one base file is corrupt in our standby database > server. The file is OK in master server, but has 0 bytes in size in > standby server.