Re: Out of space making backup

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Farhan Malik <malikpiano(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of space making backup
Date: 2009-12-25 18:19:43
Message-ID: 4B35023F.3050105@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Farhan Malik wrote:
> That sounds right. The error I get from the software is 2009/12/25
> 10:21:40.812: [00001EA8][ThreadBackupRestore] Restore Error: pg_dump:
> [tar archiver] could not write to output file: No space left on device
>
> Is there a way to have postgre put those large temp files on a
> different drive? I only have 4GB free on my C: drive and once the
> temp files go over that I get an out of space error. I have tons of
> free space on other drives, including the one where I am asking that
> the final backup.zip file goes.
>
> As for changing the backup to a custom format, I will pass that on to
> the developer of the software.
>

wild guess says, the value of the TEMP environment variable when the
backup software is started will determine the path of where that
temporary file is written. In MS Windows this usually defaults to
%USERPROFILE%\Local Settings\Temp\

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Morgan Lloyd 2009-12-25 18:27:09 Re: Updating from 8.2 to 8.4
Previous Message Adrian Klaver 2009-12-25 17:39:09 Re: Updating from 8.2 to 8.4