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

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(at)math(dot)tu-freiberg(dot)de> /| \__
Network admin, systems programmer /_|____\
_/\ | __)
$ ./configure \\ \|__/__|
checking whether build environment is sane... yes \\/___/ |
checking for AIX... no (we already did this) |