| From: | Jan Wieck <janwieck(at)yahoo(dot)com> |
|---|---|
| To: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
| Cc: | Jeff <jeff(dot)brickley(at)motorola(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: large file limitation |
| Date: | 2002-01-19 01:06:32 |
| Message-ID: | 200201190106.g0J16Wd07311@saturn.janwieck.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)Yahoo(dot)com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-19 01:51:47 | Re: large file limitation |
| Previous Message | Tom Lane | 2002-01-19 00:34:15 | Re: bug in pg_restore |