Skip site navigation (1) Skip section navigation (2)

Re: Backup strategies

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Backup strategies
Date: 2008-10-15 13:21:12
Message-ID: gd4qo2$gvl$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
Guillaume Lelarge wrote:
> Ivan Voras a écrit :

>> It looks like PostgreSQL freezes the state of the "data" directory in
>> this case (and new data goes only to the transaction log - pg_xlog),
>> which effectively creates an application-level snapshot. Good to know.
> 
> Nope. Even files in data directory change. That's why the documentation
> warns against tools that emit errors for files that change during the copy.

Ok, thanks. This is a bit off-topic, but if it's not how I imagine it,
then how is it implemented?

In response to

Responses

pgsql-performance by date

Next:From: Matthew WakelingDate: 2008-10-15 13:37:40
Subject: Re: Backup strategies
Previous:From: Guillaume LelargeDate: 2008-10-15 11:40:30
Subject: Re: Backup strategies

pgsql-general by date

Next:From: Matthew WakelingDate: 2008-10-15 13:37:40
Subject: Re: Backup strategies
Previous:From: AndrusDate: 2008-10-15 11:59:49
Subject: Opptimizing projections containing unused columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group