Re: psql -f backup.out || file too big - SOLVED

Поиск
Список
Период
Сортировка
От Helge Bahmann
Тема Re: psql -f backup.out || file too big - SOLVED
Дата
Msg-id Pine.LNX.4.21.0111121819010.11635-100000@lothlorien.stunet2.tu-freiberg.de
обсуждение исходный текст
Ответ на Re: psql -f backup.out || file too big - SOLVED  (Jorge Sarmiento <jsarmiento@ccom.org>)
Список pgsql-general
On Mon, 12 Nov 2001, Jorge Sarmiento wrote:

[backup.out > 2GB]
> the solution was:
>
> psql < backup.out
>
> instead of
>
> psql -f backup.out
[...]
> what that psql -f limit documented somewhere?

This is not a limitation of psql, but of lacking "large file support"
selected at compile time.

If you recompile psql and add the option "-D_FILE_OFFSET_BITS=64" then
psql -f should work as well.

Regards
--
Helge Bahmann <bahmann@math.tu-freiberg.de>             /| \__
Network admin, systems programmer                      /_|____\
                                                     _/\ |   __)
$ ./configure                                        \\ \|__/__|
checking whether build environment is sane... yes     \\/___/ |
checking for AIX... no (we already did this)            |


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

Предыдущее
От: "Oberpriller, Wade D."
Дата:
Сообщение: Creating languages with relative path to shared libraries
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Creating languages with relative path to shared libraries