Re: [ADMIN] pg_dump not enough space to create a backup FreeBSD 6.1?
Joost Kraaijeveld wrote: Can I somehow use another partition to store the temporaray files without changing my /tmp mount? Set the environment variable TMPDIR. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [ADMIN] pg_dump not enough space to create a backup FreeBSD 6.1?
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: [EMAIL PROTECTED]:/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 [EMAIL PROTECTED]:/data/even]# df -h Filesystem SizeUsed Avail Capacity Mounted on /dev/aacd0s1g125G5.8G109G 5%/data /dev/aacd0s1e484M 86K445M 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 [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [ADMIN] pg_dump not enough space to create a backup FreeBSD 6.1?
Joost Kraaijeveld [EMAIL PROTECTED] writes: Running pg_dump on a FreeBSD 6.1 machine gives me: [EMAIL PROTECTED]:/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) Do you have a specific reason to use -Ft rather than -Fc mode? -Fc does not have this limitation, nor some other ones. While I don't wish to actually deprecate -Ft, I wonder whether the documentation should provide a more forceful recommendation to use -Fc unless you have a good reason not to. regards, tom lane ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly