Re: pg_dump error - filesystem full - Mailing list pgsql-general

From Poul Møller Hansen
Subject Re: pg_dump error - filesystem full
Date
Msg-id 440F471F.3020509@pbnet.dk
Whole thread Raw
In response to Re: pg_dump error - filesystem full  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump error - filesystem full  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of memory error on pg_restore
Next
From: "Moises Alberto Lindo Gutarra"
Date:
Subject: Re: Out of memory error on pg_restore