Re: ftell error during pg_dump

From: William Garrison <postgres(at)mobydisk(dot)com>
To:
Cc: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: ftell error during pg_dump
Date: 2008-08-12 17:42:44
Message-ID: 48A1CB94.5020307@mobydisk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

yaaaaaaaaaaaaaaaaay!
Thank you.

Magnus Hagander wrote:
> This is almost certainly the bug fixed in 8.2.4 and listed in the
> release notes as:
> "Allow pg_dump to do binary backups larger than two gigabytes on Windows
> (Magnus) "
>
> If it happens to be that your dump could approach the 2Gb limit, I
> suggest you upgrade to 8.2.9 and see if it goes away.
>
>
> As this is entirely a client bug, there would be nothing in the logs.
>
>
> //Magnus
>
> William Garrison wrote:
>
>> I'm embarrassed to say it is 8.2.3 :( I'm not sure why they haven't
>> upgraded our production servers to the latest 8.2 yet. It's running on
>> Windows Server 2003, and it looks like there is plenty of disk space.
>>
>> I googled this and found someone reported defect 2461 for this, some
>> time ago, but I'm not clear how to check the status of that bug. I
>> subscribed to pgsql-bugs so I can ask there as well.
>> http://archives.postgresql.org/pgsql-bugs/2006-06/msg00012.php
>>
>> I also checked the logs from yesterday and I don't see anything that was
>> logged while the pg_dump was running.
>>
>> Tom Lane wrote:
>>
>>> William Garrison <postgres(at)mobydisk(dot)com> writes:
>>>
>>>
>>>> Our IT administrator ran a pg_dump and received the following error:
>>>> pg_dump: [custom archiver] WARNING: ftell mismatch with expected
>>>> position -- ftell used
>>>>
>>>>
>>> What platform, and exactly what version of pg_dump? Is it possible
>>> you ran out of disk space partway through?
>>>
>>> regards, tom lane
>>>
>>>
>>>
>>
>>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Siebert 2008-08-12 18:51:39 8.3.1 Vs 8.3.3
Previous Message Magnus Hagander 2008-08-12 17:21:26 Re: ftell error during pg_dump