Re: Backup Question for Point-in-Time Recovery

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Rural Hunter <ruralhunter(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup Question for Point-in-Time Recovery
Date: 2011-09-10 17:30:48
Message-ID: 1315675848.15665.11.camel@localhost.localdomain
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, 2011-09-11 at 01:19 +0800, Rural Hunter wrote:
> I'm making a base backup with 9.1rc by following 24.3.3 in manual:
> http://www.postgresql.org/docs/9.1/static/continuous-archiving.html
> 1. SELECT pg_start_backup('label');
> 2. perform file system backup with tar
> 3. SELECT pg_stop_backup();
>
> But when I was performing step 2, I got warning from tar command that
> file was changed when tar was reading file on some files such as
> 'postgres/base/16405/5659097'. Will I get a good backup in this case?
>

Yes. But note that you can use pg_basebackup in 9.1. It does everything
needed to have a complete file backup.

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message albert 2011-09-10 20:38:24 MSAccess migration to Postgres through ODBC
Previous Message Rural Hunter 2011-09-10 17:19:42 Backup Question for Point-in-Time Recovery