Re: large file limitation

Jeff,

Since your problems have to do with backups, a better solution than
reconfiguring your kernel and recompiling postgres might be to split up
the backups into smaller files.

pg_dump mydb | split -b 1000m - backupfile

man backup

--brian

On Fri, 2002-01-18 at 13:03, Bill Cunningham wrote:
> Check the user limit (ulimit) for the user your running postgres under.
> Its probably causing the problem.
>
> - Bill
>
> Jeff wrote:
>
> >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
> >
> >
> >---------------------------(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
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org