Re: [GENERAL] pg_dump error - filesystem full

2006-03-08 Thread 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 conce

Re: [GENERAL] pg_dump error - filesystem full

2006-03-08 Thread 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,

Re: [GENERAL] pg_dump error - filesystem full

2006-03-07 Thread 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

Re: [GENERAL] pg_dump error - filesystem full

2006-03-07 Thread 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)--

[GENERAL] pg_dump error - filesystem full

2006-03-07 Thread 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