Re: [GENERAL] pg_dump error - filesystem full

[Tom Lane]

=?ISO-8859-1?Q?Poul_M=F8ller_Hansen?= <[EMAIL PROTECTED]> writes:
>> Also, unless you have a really good reason to be using -Ft dump format,
>> I'd recommend -Fc format instead.

> Thanks,  it takes much longer time, but the filesize is only 1/5 of the 
> tar size, so it's ok.

If you're more concerned about time than space, I think you can turn off
the compression that -Fc format uses by default.

regards, tom lane

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pg_dump error - filesystem full

[Poul Møller Hansen]

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



---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org

Re: [GENERAL] pg_dump error - filesystem full

[Tom Lane]

Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Am Dienstag, 7. März 2006 11:13 schrieb Poul Møller Hansen:
>> Is there a way to make pg_dump use /var/tmp as a temporary filespace
>> instead ?

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

regards, tom lane

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

Re: [GENERAL] pg_dump error - filesystem full

[Peter Eisentraut]

Am Dienstag, 7. März 2006 11:13 schrieb Poul Møller Hansen:
> Is there a way to make pg_dump use /var/tmp as a temporary filespace
> instead ?

Try export TMPDIR=/var/tmp.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match

[GENERAL] pg_dump error - filesystem full

[Poul Møller Hansen]

/tmp: write failed, filesystem is full
pg_dump: [tar archiver] could not write to tar member (wrote 0, 
attempted 101)


Is there a way to make pg_dump use /var/tmp as a temporary filespace 
instead ?



Thanks, Poul



---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match