Re: pg_dump error - filesystem full

Поиск
Список
Период
Сортировка
От Poul Møller Hansen
Тема Re: pg_dump error - filesystem full
Дата
Msg-id 440F471F.3020509@pbnet.dk
обсуждение исходный текст
Ответ на Re: pg_dump error - filesystem full  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_dump error - filesystem full  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
>> Try export TMPDIR=/var/tmp.
>>
>
> Also, unless you have a really good reason to be using -Ft dump format,
> I'd recommend -Fc format instead.  It's better tested and doesn't suffer
> from various limitations of the tar format, notably the need for a temp
> file.
>
Thanks,  it takes much longer time, but the filesize is only 1/5 of the
tar size, so it's ok.
Also great with the TMPDIR hadn't thought about that.

Poul



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Out of memory error on pg_restore
Следующее
От: "Moises Alberto Lindo Gutarra"
Дата:
Сообщение: Re: Out of memory error on pg_restore