Re: Stand by server (9.6.6) with corrupt file

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, shall not the standby start?

Regards,

*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 23/12/2017 09:58, Martin Marques escreveu:
> 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 corrupt in our standby database server.
>> The file is OK in master server, but has 0 bytes in size in standby server.
> How was the standby built? Did you use a recovered backup from barman or
> did you clone from the master with some tool. An if it's the former,
> which exact process did you use? (Using pg_basebackup would be the
> safest way of cloning)
>
> Regards,
>