pg_rewind and full_page_writes on zfs

From: Malte Swart <pg(at)malteswart(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_rewind and full_page_writes on zfs
Date: 2019-05-17 08:56:17
Message-ID: 2285376.9Qy4lotxuy@morab
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am currently building a PostgreSQL cluster with physical replication. I want
to disable full_page_writes as the underlaying filesystem (ZFS) prevents
partial page writes.
I would like to use pg_rewind for faster reintegration of diverted nodes but
pg_rewind refuses to act if full_page_writes are disabled.

Does anyone know whether it is safe to skip this check on ZFS?

Are there other implications of disabling full_page_writes that impact
pg_rewind? The documentation does not state any reason to enable
full_page_writes. The source code [1] mentioned something about modification
during pg_read_binary_file but I do not know if it is relevant for ZFS.

Help appreciated,
Malte.

[1]: https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/bin/
pg_rewind/libpq_fetch.c;hb=HEAD#l74

Browse pgsql-general by date

  From Date Subject
Next Message nigel.andersen 2019-05-17 11:04:16 Re: Upgrading 9.1.17 to which version?
Previous Message AYahorau 2019-05-17 08:04:58 Re: terminating walsender process due to replication timeout