From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, Dhaval Shah <dhaval(dot)shah(dot)m(at)gmail(dot)com>, pgsql-docs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: [GENERAL] PITR and tar |
Date: | 2007-05-14 01:04:53 |
Message-ID: | 200705140104.l4E14rn21632@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general |
Jim C. Nasby wrote:
> Moving to -docs...
>
> Does anyone know what the history of the docs saying that GNU tar had
> issues with files changing underneath it? According to this report it's
> actually BSD tar that has the issue.
As I remember, Tom was the one who found that GNU tar would return a
non-zero exit status if the file changed during backup, so you couldn't
determine if the backup was successful based on the exit code.
---------------------------------------------------------------------------
>
> On Wed, May 09, 2007 at 10:19:05AM -0700, Jeff Davis wrote:
> > On Wed, 2007-05-09 at 11:40 -0500, Jim Nasby wrote:
> > > Actually, looking at the docs, the problem is with some versions of
> > > GNU tar. AFAIK bsdtar is perfectly happy to archive files that have
> > > changed from underneath it.
> > >
> >
> > $ tar --version
> > bsdtar 1.2.53 - libarchive 1.3.1
> >
> > That fails to create a file in proper gzip format when the files are
> > concurrently modified.
> >
> > However,
> >
> > $ tar --version
> > tar (GNU tar) 1.14
> > Copyright (C) 2004 Free Software Foundation, Inc.
> > This program comes with NO WARRANTY, to the extent permitted by law.
> > You may redistribute it under the terms of the GNU General Public
> > License;
> > see the file named COPYING for details.
> > Written by John Gilmore and Jay Fenlason.
> >
> > That _appears_ to work.
> >
> > Perhaps FreeBSD users should take notice of this problem. It's certainly
> > not a postgresql problem, but I know there are a lot of freebsd users
> > here, and using tar on fast-changing data may be rare outside of
> > postgresql.
> >
> > Regards,
> > Jeff Davis
> >
>
> --
> Jim Nasby decibel(at)decibel(dot)org
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2007-05-14 01:17:40 | Autovacuum and XID wraparound |
Previous Message | Tom Lane | 2007-05-13 23:45:30 | Re: Documentation of pg_badkend_pid and stats functions |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-05-14 01:46:21 | Re: [GENERAL] PITR and tar |
Previous Message | Jim C. Nasby | 2007-05-13 22:54:43 | Re: How access table by tableoid |