Обсуждение: pg_restore not able to restore files larger that 2.4GB

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

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

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

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