Thread: Full_page_write is off in backup mode

<p dir="ltr">Hi,<br />     I am using postgres 9.2.2.<br /> The postgresql documentation says, full_page_writes is
forciblyon after executing the function pg_start_backup. But in my server full_page_writes is still off  (not
changed).<br/> 

On Mon, Sep 29, 2014 at 12:06 PM, searcher s <just.search.go@gmail.com> wrote:
> Hi,
>     I am using postgres 9.2.2.
> The postgresql documentation says, full_page_writes is forcibly on after
> executing the function pg_start_backup. But in my server full_page_writes is
> still off  (not changed).

The value of the GUC doesn't actually change.  But the system still
performs full page writes during the backup.  Search the source code
for forcePageWrites to see how it works internally.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company