Re: pg_restore not able to restore files larger that 2.4GB

Ericson Smith <eric@did-it.com> writes:
> We have a backup that's 2.4GB. pg_restore exist with a message that the
> file is too big.
> We have the latest RedHat install and kernel on EXT3 with plenty of Ram,
> Disk and CPU.
> Any suggestions?

You need to compile pg_restore with large file support enabled.

PG 7.3 attempts to do so by default, but in earlier versions you'd have
to figure out the necessary CFLAGS additions yourself :-(

            regards, tom lane