pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBackup Question for Point-in-Time Recovery
3+ messages / 2 participants
[nested] [flat]
* Backup Question for Point-in-Time Recovery
@ 2011-09-10 17:19 Rural Hunter <ruralhunter@gmail.com>
2011-09-10 17:30 ` Re: Backup Question for Point-in-Time Recovery Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 1 reply; 3+ messages in thread
From: Rural Hunter @ 2011-09-10 17:19 UTC (permalink / raw)
To: pgsql-admin
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Backup Question for Point-in-Time Recovery
2011-09-10 17:19 Backup Question for Point-in-Time Recovery Rural Hunter <ruralhunter@gmail.com>
@ 2011-09-10 17:30 ` Guillaume Lelarge <guillaume@lelarge.info>
2011-09-11 01:17 ` Re: Backup Question for Point-in-Time Recovery Rural Hunter <ruralhunter@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Guillaume Lelarge @ 2011-09-10 17:30 UTC (permalink / raw)
To: Rural Hunter <ruralhunter@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Backup Question for Point-in-Time Recovery
2011-09-10 17:19 Backup Question for Point-in-Time Recovery Rural Hunter <ruralhunter@gmail.com>
2011-09-10 17:30 ` Re: Backup Question for Point-in-Time Recovery Guillaume Lelarge <guillaume@lelarge.info>
@ 2011-09-11 01:17 ` Rural Hunter <ruralhunter@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rural Hunter @ 2011-09-11 01:17 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
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.
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-09-11 01:17 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-09-10 17:19 Backup Question for Point-in-Time Recovery Rural Hunter <ruralhunter@gmail.com>
2011-09-10 17:30 ` Guillaume Lelarge <guillaume@lelarge.info>
2011-09-11 01:17 ` Rural Hunter <ruralhunter@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox