Re: Hot Backup with rsync fails at pg_clog if under load - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Hot Backup with rsync fails at pg_clog if under load
Date
Msg-id 1316793461-sup-7812@alvh.no-ip.org
Whole thread Raw
In response to Re: Hot Backup with rsync fails at pg_clog if under load  (Linas Virbalas <linas.virbalas@continuent.com>)
Responses Re: Hot Backup with rsync fails at pg_clog if under load
List pgsql-hackers
Excerpts from Linas Virbalas's message of vie sep 23 09:47:20 -0300 2011:
> On 9/23/11 12:05 PM, "Heikki Linnakangas"
> <heikki.linnakangas@enterprisedb.com> wrote:

> But on the standby its size is the old one (thus, it seems, that the size
> changed after the rsync transfer and before the pg_stop_backup() was
> called):
> 
> ls -l pg_clog/
> total 8
> -rw------- 1 postgres postgres 8192 Sep 23 14:31 0000

Sounds like rsync is caching the file size at the start of the run, and
then copying that many bytes, ignoring the growth that occurred after it
started.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: Hot Backup with rsync fails at pg_clog if under load
Next
From: Magnus Hagander
Date:
Subject: Re: Hot Backup with rsync fails at pg_clog if under load