Backup Question for Point-in-Time Recovery

Поиск
Список
Период
Сортировка
Искать

Backup Question for Point-in-Time Recovery

От:
Rural Hunter <ruralhunter@gmail.com>
Дата:
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?


Re: Backup Question for Point-in-Time Recovery

От:
Guillaume Lelarge <guillaume@lelarge.info>
Дата:
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

Re: Backup Question for Point-in-Time Recovery

От:
Rural Hunter <ruralhunter@gmail.com>
Дата:
OK, thank you.

于2011年9月11日 1:30:48,Guillaume Lelarge写到:
> 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.
>
>


FAQ