Обсуждение: 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
"A mente que se abre a uma nova ideia jamais voltará ao seu tamanho original" - Albert Einstein

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,