bricklen <bricklen@xxxxxxxxx> writes: > There are several hot standby servers attached to the master, some > streaming, and one in a different data centre that is using WAL shipping > only. > The streaming slave IIRC got the corruption from the master (I can't check > now, it was rebuilt). > What would have happened to the WAL-shipping-only standby if the WALs were > all applied? Would it have it balked at applying a WAL containing bad data > from the master, or would it have applied the WAL and continued on? For the > latter, would physical corruption on the master even transfer via WAL? Hard to tell. I'd have guessed that corruption that made a page unreadable would not transfer across WAL (streaming or otherwise), because the master could not have read it in to apply an update to it. However, we don't know the exact sequence of events here; there may have more than one step on the way to disaster. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
