Re: FW: Setting up of PITR system.

Поиск
Список
Период
Сортировка
От Sriram Dandapani
Тема Re: FW: Setting up of PITR system.
Дата
Msg-id 6992E470F12A444BB787B5C937B9D4DF03D37269@ca-mail1.cis.local
обсуждение исходный текст
Ответ на FW: Setting up of PITR system.  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Ответы Re: FW: Setting up of PITR system.  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
Re: FW: Setting up of PITR system.  ("Andy Shellam" <andy.shellam@mailnetwork.co.uk>)
Список pgsql-admin
We have high volume inserts happening with wal files being generated
very rapidly. Will the fact that the files change as the tar happens
have any effect at all on the recovery..assuming all the appropriate wal
archive logs are available.

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jim C. Nasby
Sent: Friday, March 31, 2006 10:11 AM
To: Tom Lane
Cc: andy.shellam@mailnetwork.co.uk; 'Rajesh Kumar Mallah';
pgsql-admin@postgresql.org
Subject: Re: FW: [ADMIN] Setting up of PITR system.

On Wed, Mar 29, 2006 at 09:46:30AM -0500, Tom Lane wrote:
> It definitely is a pain in the neck that GNU tar complains about files
> changing underneath it --- I've looked for a way to disable that, or
at
> least reduce it to a warning instead of an error condition, but gtar
> doesn't seem to have such a switch.  You should try alternative backup
> tools such as cpio or rsync.

Or you might submit a patch to GNU tar. There's also a BSD version of
tar, it's on at least FreeBSD (not sure if there's a stand-alone version
avaiable). It might not suffer from the same problem, though I haven't
tried it. I do have a machine I could try it with if that would help.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: FW: Setting up of PITR system.
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Bloated pg_shdepend_depender_index