Stephen Frost wrote: > * Edson Carlos Ericksson Richter (rich...@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
