Re: psql -f backup.out || file too big - SOLVED - Mailing list pgsql-general

From Helge Bahmann
Subject Re: psql -f backup.out || file too big - SOLVED
Date
Msg-id Pine.LNX.4.21.0111121819010.11635-100000@lothlorien.stunet2.tu-freiberg.de
Whole thread Raw
In response to Re: psql -f backup.out || file too big - SOLVED  (Jorge Sarmiento <jsarmiento@ccom.org>)
List 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 by date:

Previous
From: "Oberpriller, Wade D."
Date:
Subject: Creating languages with relative path to shared libraries
Next
From: Tom Lane
Date:
Subject: Re: Creating languages with relative path to shared libraries