Re: Full_page_write is off in backup mode - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Full_page_write is off in backup mode
Date
Msg-id CA+TgmoaJnxLsye947g7j_0y=Xuv8M4dP=9KRJWwVr5jqpuzP9g@mail.gmail.com
Whole thread Raw
In response to Full_page_write is off in backup mode  (searcher s <just.search.go@gmail.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_receivexlog and replication slots
Next
From: Robert Haas
Date:
Subject: Re: test_shm_mq failing on anole (was: Sending out a request for more buildfarm animals?)