large file limitation

From: jeff(dot)brickley(at)motorola(dot)com (Jeff)
To: pgsql-general(at)postgresql(dot)org
Subject: large file limitation
Date: 2002-01-10 21:10:35
Message-ID: dea33a90.0201101310.2e25b3@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have installed Postgres 7.1.3 on a Solaris 2.8 machine. When I dump
the database the file is larger than the 2 GB limit. I checked with
our unix admin and he confirmed that Solaris 2.8 would not support
files larger than 2GB until he made a modification to use large files.
He made the modification and we verified that the unix system could
handle files larger than 2GB. I then dumped the database again and
noticed the same situation. The dump files truncate at the 2GB limit.
I suppose I need to recompile Postgres now on the system now that it
accepts large files. Is there any library that I need to point to
manually or some option that I need to pass in the configuration? How
do I ensure Postgres can handle large files (>2GB)

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-01-10 21:41:55 Re: Insert Performance with WAL and Fsync
Previous Message Jim Martinez 2002-01-10 20:57:57 duplicating tables (accross databases)