Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 743FA9FB3A9 for ; Wed, 16 May 2007 13:22:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 32260-07 for ; Wed, 16 May 2007 13:22:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 7B16C9FB340 for ; Wed, 16 May 2007 13:22:26 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 837B0564C5; Wed, 16 May 2007 11:22:25 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 16 May 2007 11:22:23 -0500 Date: Wed, 16 May 2007 11:22:23 -0500 From: "Jim C. Nasby" To: Joost Kraaijeveld Cc: pgsql-admin@postgresql.org Subject: Re: pg_dump not enough space to create a backup FreeBSD 6.1? Message-ID: <20070516162223.GP14548@nasby.net> References: <1179319005.13002.6.camel@panoramix> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1179319005.13002.6.camel@panoramix> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070516:j.kraaijeveld@askesis.nl::uN7407y3NAG3lQaI:0000000000000 0000000000000000000000002ZIT X-Hashcash: 1:20:070516:pgsql-admin@postgresql.org::DnSLRhnAUSc/4wbh:00000000000 0000000000000000000000007cei X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/140 X-Sequence-Number: 25460 On Wed, May 16, 2007 at 02:36:45PM +0200, Joost Kraaijeveld wrote: > Hi, > > Running pg_dump on a FreeBSD 6.1 machine gives me: > > [root@s13.nedstars.nl:/data/even]# pg_dump -Ft -f ./my_db-2007-5-16.backup -U user my_db > > /tmp: write failed, filesystem is full > pg_dump: [tar archiver] could not write to tar member (wrote 0, > attempted 86) > > pg_dump: *** aborted because of error > > [root@s13.nedstars.nl:/data/even]# df -h > > Filesystem Size Used Avail Capacity Mounted on > /dev/aacd0s1g 125G 5.8G 109G 5% /data > /dev/aacd0s1e 484M 86K 445M 0% /tmp > > The database is, when dumped in text format and gzipped, 40 Mb, so I > assume that there is enough space on the /tmp drive to store the temp > files of the pg_dump. > > Is that assumption OK? Can I somehow use another partition to store the > temporaray files without changing my /tmp mount? tar is what's creating the temp files, not pg_dump. AFAIK it obeys the TEMP environment variable, so changing that should make things good. -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)