On 26/12/2009 12:44 AM, Brian Modra wrote:
use select pg_start_backup('some-name') (in psql logged in a postres)
then start a tar of /var/lib/pgsql/data/, to stdout and pipe this to
tar on another server using ssh
This won't work on a Windows machine. Windows does not permit files that
are op
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 2009/12/25
>> 10:21
Farhan Malik wrote:
That sounds right. The error I get from the software is 2009/12/25
10:21:40.812: [1EA8][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
diff
2009/12/25 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
> 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
Farhan Malik writes:
> 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
Farhan Malik wrote:
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
