Thread: pg_dump && tar && /tmp
Hi, I have a FreeBSD box with a quite large database, and my /tmp is only 128MB, and pg_dump -F t should needs about 2GB. As I can't make /tmp bigger, is there a way to tell pg_dump to dump it's files somewhere else ? -- Mathieu Arnold
Have you tried changing $TEMP when you start postgresql? On Sat, May 10, 2003 at 05:48:26PM +0200, m@mat.cc wrote: > Hi, > > I have a FreeBSD box with a quite large database, and my /tmp is only 128MB, > and pg_dump -F t should needs about 2GB. As I can't make /tmp bigger, is > there a way to tell pg_dump to dump it's files somewhere else ? > -- Jim C. Nasby (aka Decibel!) jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
--Le 10/05/2003 12:19 -0500, Jim C. Nasby écrivait : | Have you tried changing $TEMP when you start postgresql? | It used to be TMPDIR. I'll try that. -- Mathieu Arnold
--Le 10/05/2003 12:19 -0500, Jim C. Nasby écrivait : | Have you tried changing $TEMP when you start postgresql? | I tried some export TEMP="/usr/tmp" when launching postmaster, when launching pg_dump, does not work. -- Mathieu Arnold