Re: pg_dump error - filesystem full

From: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump error - filesystem full
Date: 2006-03-08 21:05:35
Message-ID: 440F471F.3020509@pbnet.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moises Alberto Lindo Gutarra 2006-03-08 21:10:16 Re: Out of memory error on pg_restore
Previous Message Tom Lane 2006-03-08 20:54:11 Re: Out of memory error on pg_restore