Re: PG_dump fatal error (second post) - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: PG_dump fatal error (second post)
Date
Msg-id NEBBLAAHGLEEPCGOBHDGAEKOHMAA.nickf@ontko.com
Whole thread Raw
In response to PG_dump fatal error (second post)  ("Nick Fankhauser" <nickf@ontko.com>)
List 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
>


pgsql-admin by date:

Previous
From: Lucas Brasilino
Date:
Subject: Re: Problems installing PostgreSQL-7.3.3 RPM
Next
From: Dani Oderbolz
Date:
Subject: Re: PG_dump fatal error (second post)