Re: pg_dump and 2gb limit on windows and version 8.1.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump and 2gb limit on windows and version 8.1.3
Дата
Msg-id 1843.1242662833@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump and 2gb limit on windows and version 8.1.3  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> I think you should upgrade to 8.1.17 which likely contains the fix as
> well.

If you are thinking of this fix:

2007-02-19 10:05  mha

    * src/bin/pg_dump/: pg_backup_archiver.c, pg_backup_archiver.h,
    pg_backup_custom.c, pg_backup_files.c, pg_backup_tar.c, pg_dump.h
    (REL8_2_STABLE), pg_backup_archiver.c, pg_backup_archiver.h,
    pg_backup_custom.c, pg_backup_files.c, pg_backup_tar.c, pg_dump.h:
    Fix pg_dump on win32 to properly dump files larger than 2Gb when
    using binary dump formats.

it doesn't appear to have been back-patched into 8.1.  However the log
message suggests a workaround: use plain-text output format.

In any case, continuing to depend on an 8.1.x server on Windows
(especially one as old as 8.1.3) is just plain stupid.  We dropped
support for that release series for very good reasons.  The OP needs
to get off that version --- just accepting someone's diktat that it
"can't be upgraded" is irresponsible, unless the data it contains is
of no value (which I doubt or we wouldn't be fielding this question).

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump and 2gb limit on windows and version 8.1.3
Следующее
От: Sam Mason
Дата:
Сообщение: Re: Excel and pg