Re: File system snapshots for multiple file systems

From: Fujii Masao <fujii(dot)masao(at)oss(dot)ntt(dot)co(dot)jp>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: File system snapshots for multiple file systems
Date: 2008-04-08 06:05:32
Message-ID: 47FB0B2C.7010103@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas wrote:
> 1. call pg_start_backup('foo')
> 2. tar/etc. the whole data directory, except for pg_xlog
> 3. tar pg_xlog
> 4. call pg_stop_backup()
>
> If we just made sure that we don't delete or recycle any WAL files while
> the backup is being taken, that would work, right?

When is the backup history file for PITR backed up?
Just after pg_stop_backup()? Next backup?

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
TEL (03)5860-5115
FAX (03)5463-5490

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Albe Laurenz 2008-04-08 07:16:33 Re: Improve shutdown during online backup
Previous Message Andrew Dunstan 2008-04-08 04:37:13 Re: [HACKERS] pgsql: Implement a few changes to how shared libraries and dynamically