Re: Stand by server (9.6.6) with corrupt file

Edson Carlos Ericksson Richter <richter@xxxxxxxxxxxxxx> · Mon, 25 Dec 2017 19:32:50 -0200

    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

    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,