pg_restore not able to restore files larger that 2.4GB

PG prior to 7.3 doesn't do large file support.

On Mon, 2002-09-09 at 14:19, Oleg Bartunov wrote:

Check if you have large file support ?

Oleg
On 9 Sep 2002, Ericson Smith wrote:

Hi,

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?

- Ericson Smith
eric@did-it.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Check if you have large file support ?

Oleg
On 9 Sep 2002, Ericson Smith wrote:

Hi,

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?

- Ericson Smith
eric@did-it.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

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