Re: Backup strategies

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan Voras <ivoras(at)freebsd(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Backup strategies
Date: 2008-10-15 15:51:53
Message-ID: 22266.1224085913@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Ivan Voras <ivoras(at)freebsd(dot)org> writes:
> Matthew Wakeling wrote:
>> The files may change, but it doesn't matter, because there is enough
>> information in the xlog to correct it all.

> I'm thinking about these paragraphs in the documentation:

>> You can, however, omit from the backup dump the files within the
>> pg_xlog/ subdirectory of the cluster directory.

The assumption is that a PITR backup configuration provides a separate
pathway for the xlog files to get to the slave database.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-10-15 15:55:03 Re: NATURAL JOINs
Previous Message Tom Lane 2008-10-15 15:46:08 Re: Opptimizing projections containing unused columns

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-10-15 16:13:03 Re: Drupal and PostgreSQL - performance issues?
Previous Message Ivan Voras 2008-10-15 14:58:46 Re: Backup strategies