Re: PG_dump fatal error (second post)

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Dani Oderbolz" <oderbolz(at)ecologic(dot)de>, <pgsql-admin(at)postgresql(dot)org>
Cc: <nickf(at)ontko(dot)com>
Subject: Re: PG_dump fatal error (second post)
Date: 2003-07-21 12:32:53
Message-ID: NEBBLAAHGLEEPCGOBHDGAEKOHMAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Dani-

The file is nowhere near 2GB, and a regular text dump running at the same
time always completes successfuly, with a resulting file size about 4 times
what the tar-format file was when it died. Also note that this worked on the
same server using the same database using v7.2 of postgreSQL.

Thanks for the idea. (That was my first thought as well.)

-Nick

> how big does your tar file get when you get the error?
> I would guess that its 2GB at this time, which would indicate
> that you just
> hit a File System Limit.
> To prevent this, I guess you should use the "split" command to
> split your file in pieces of less than 2 GB size.
>
> Regards,
> Dani
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Olivier Reuland 2003-07-21 12:55:49 common_fields: permission denied
Previous Message Dani Oderbolz 2003-07-21 12:16:08 Re: PG_dump fatal error (second post)