Stephen Frost wrote:
> * Edson Carlos Ericksson Richter (richter@simkorp.com.br) wrote:
> > Anyway, instead digging into rsync functionality (or bugs - I doubt,
> > but who knows?), I do prefer to have a script I can run to check if
> > there is obvious failures in standby servers.
>
> As mentioned, zero-byte files can be perfectly valid. PostgreSQL does
> have page-level CRCs, if you initialized your database with them (which
> I would strongly recommend).
Page-level checksums would not detect the problem being complained in
this thread, however.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services