Re: large file limitation - Mailing list pgsql-general

From Jan Wieck
Subject Re: large file limitation
Date
Msg-id 200201190106.g0J16Wd07311@saturn.janwieck.net
Whole thread Raw
In response to Re: large file limitation  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: large file limitation
List pgsql-general
Andrew Sullivan wrote:
> On Thu, Jan 10, 2002 at 01:10:35PM -0800, Jeff wrote:
> > handle files larger than 2GB.  I then dumped the database again and
> > noticed the same situation.  The dump files truncate at the 2GB limit.
>
> We just had the same happen recently.
>
> >  I suppose I need to recompile Postgres now on the system now that it
> > accepts large files.
>
> Yes.

    No.  PostgreSQL is totally fine with that limit, it will just
    segment huge tables into separate files of 1G max each.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: bug in pg_restore
Next
From: Tom Lane
Date:
Subject: Re: large file limitation