Thread: pg_dump: [tar archiver] write error appending to tar archive

"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


> "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
>