pg_backup_start fails on standby when full_page_writes are disabled on primary - Mailing list pgsql-admin

From Travis Ward
Subject pg_backup_start fails on standby when full_page_writes are disabled on primary
Date
Msg-id b9ddfeee4f6e4f569bb4f1d3a8628918@WICOURTS.GOV
Whole thread Raw
List pgsql-admin
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
restore_command: configured to restore wal-file 

Thanks,

Travis Ward






pgsql-admin by date:

Previous
From: Ian Lawrence Barwick
Date:
Subject: Re: Inquiry About Sharing a Job Opportunity with the PostgreSQL Community
Next
From: Wasim Devale
Date:
Subject: Reindexing