Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3016A9FB5AC for ; Wed, 16 May 2007 09:37:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 15120-06 for ; Wed, 16 May 2007 09:36:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E2C5A9FB6C8 for ; Wed, 16 May 2007 09:36:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from obelix.askesis.nl (laudanum.demon.nl [82.161.125.16]) by svr4.postgresql.org (Postfix) with ESMTP id 58C515AF03F for ; Wed, 16 May 2007 12:36:56 +0000 (GMT) Received: obelix 172.31.0.1 from 172.31.1.1 172.31.1.1 via HTTP with MS-WebStorage 6.0.6249 Received: from panoramix by obelix; 16 May 2007 14:36:45 +0200 Subject: pg_dump not enough space to create a backup FreeBSD 6.1? From: Joost Kraaijeveld To: pgsql-admin@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Wed, 16 May 2007 14:36:45 +0200 Message-Id: <1179319005.13002.6.camel@panoramix> Mime-Version: 1.0 X-Mailer: Evolution 2.6.3 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.174 tagged_above=0 required=5 tests=AWL=0.037, BAYES_50=0.001, FORGED_RCVD_HELO=0.135, UNPARSEABLE_RELAY=0.001 X-Spam-Level: X-Archive-Number: 200705/139 X-Sequence-Number: 25459 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? TIA -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl