Postgres Pro
Downloads
Home   >   mailing lists

Re: Is full_page_writes=off safe in conjunction with PITR? - Mailing list pgsql-hackers

From markir@paradise.net.nz
Subject Re: Is full_page_writes=off safe in conjunction with PITR?
Date
Msg-id 1145055870.44402a7e86c9b@www.paradise.net.nz
Whole thread Raw
In response to Is full_page_writes=off safe in conjunction with PITR?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Quoting Tom Lane <tgl@sss.pgh.pa.us>:
> I fear we still have to disable full_page_writes (force it ON) if
> XLogArchivingActive is on. Comments?

Yeah - if you are enabling PITR, then you care about safety and integrity, so it
makes sense (well, to me anyway).

Cheers

Mark

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: two-argument aggregates and SQL 2003
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Possible race in UnlockBuffers() and UnpinBuffer()