[GENERAL] Out of space making backup

2009-12-25 Thread Farhan Malik
When making a backup of my database I run out of space.  I tell it to put the backup file on my K: drive, which has tons of free space, but during the backup postgresql creates a temporary folder on my C: Drive where it initially writes data.  I don't have enough space on my C: drive for all the da

Re: [GENERAL] Out of space making backup

2009-12-25 Thread Farhan Malik
> Reading between the lines, I suspect you are trying to use 'tar' output > format, which does have a need to make temp files that can be large. > If I guessed right, I'd suggest using 'custom' format instead.  There > really is no advantage to tar format, and several disadvantages besides > this o

Re: [GENERAL] Out of space making backup

2009-12-25 Thread Farhan Malik
Thanks. Changing the environmental variable has solved that issue. It ultimately required 13GB of free space to create a 2GB backup file. On Fri, Dec 25, 2009 at 1:19 PM, John R Pierce wrote: > Farhan Malik wrote: >> >> That sounds right.  The error I get from the software is 2

[GENERAL] Out of space making backup

2009-12-25 Thread Farhan Malik
When making a backup of my database I run out of space. I tell it to put the backup file on my K: drive, which has tons of free space, but during the backup postgresql creates a temporary folder on my C: Drive where it initially writes data. I don't have enough space on my C: drive for all the da