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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: [tar archiver] write error appending to tar archive
Дата
Msg-id 6958.1171290765@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump: [tar archiver] write error appending to tar archive  ("MG" <pgsql-general@carladata.de>)
Список pgsql-general
"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

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: getting postgres to emulate mysql/sqlserver bit datatype
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"