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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ericson Smith <eric(at)did-it(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_restore not able to restore files larger that 2.4GB
Date: 2002-09-09 20:47:20
Message-ID: 13648.1031604440@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ericson Smith <eric(at)did-it(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-09-09 20:50:09 Re: Load sharing question
Previous Message Tom Lane 2002-09-09 20:37:07 Re: Creating tons of tables to support a query