pg_dump: [tar archiver] write error appending to tar archive
Hello,
we have a shell-script, which executes the pg_dump once a day. This script ran already for about 6 months successfully.
Now we got the following error:
pg_dump: [tar archiver] write error appending to tar archive (wrote 28186, attempted 32767)
There is enough space on the hard disk.
Any ideas?
Regards
Michaela
"MG" <pgsql-general@carladata.de> writes:
Now we got the following error:
pg_dump: [tar archiver] write error appending to tar archive (wrote =
28186, attempted 32767)
There is enough space on the hard disk.
How big is the dump file? I seem to recall that tar format has a limit
on the size of individual members (tables), and maybe an overall size
limit as well. Another issue is that I think the members are first
built as temp files in /tmp, so the member size is constrained by how
much space you have on that filesystem.
If that's the story, switching to the "custom" format is the answer.
regards, tom lane
Where do I find the man page.
Regards
Michaela
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "MG" <pgsql-general@carladata.de>
Sent: Tuesday, February 13, 2007 3:46 PM
Subject: Re: [GENERAL] pg_dump: [tar archiver] write error appending to tar
archive
Show quoted text
"MG" <pgsql-general@carladata.de> writes:
could you tell me the directory where the temp files are built. It
doesn't
seem to be in /tmp.It'd be whereever tmpfile() wants to put it; see the man page for that
function.regards, tom lane
On 2/21/07, MG <pgsql-general@carladata.de> wrote:
Where do I find the man page.
Try 'man pg_dump' or browse www.postgresql.org for Documentation if you
can't get to any, Google is your best friend.
----- Original Message -----
Show quoted text
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "MG" <pgsql-general@carladata.de>
Sent: Tuesday, February 13, 2007 3:46 PM
Subject: Re: [GENERAL] pg_dump: [tar archiver] write error appending to
tar
archive"MG" <pgsql-general@carladata.de> writes:
could you tell me the directory where the temp files are built. It
doesn't
seem to be in /tmp.It'd be whereever tmpfile() wants to put it; see the man page for that
function.regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?