I'm encountering the following error on the streaming standby after disabling full_page_writes on the primary database.
select pg_backup_start('Is this risky');
ERROR: WAL generated with full_page_writes=off was replayed since last restartpoint
HINT:
This means that the backup being taken on the standby is corrupt and
should not be used. Enable full_page_writes and run CHECKPOINT on the
primary, and then try an online backup again.
Given that both my primary and standby databases are located on a ZFS file system, which provides its own data integrity mechanisms, does the full_page_writes=off error from pg_backup_start indicate a real risk of corruption in the standby database, or is the error message inapplicable in a ZFS environment?"
Environment information
PostgreSQL version: 16
primary_conninfo: configured with connection to primary