Re: Issues with restoring - Mailing list pgsql-general

From beer
Subject Re: Issues with restoring
Date
Msg-id 1204.128.237.251.59.1143558877.squirrel@128.237.251.59
Whole thread Raw
In response to Re: Issues with restoring  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom

Dont think its large file support, I'm running on FC4, the problem existed on FC1 too.

I'll try the custom format and see if that helps.  Thanks for the recommendation.

-bill

On Mon, March 27, 2006 4:35 pm, Tom Lane said:
> "beer" <beer@cmu.edu> writes:
>> We have a medium sized database that when dumped creates +4G files
>> within the tar archive.  When we restore it seems that pg_restore has a
>> 4G limit for reading files, once it reads 4G of a file, it moves on to
>> the next file.  Has anyone else experienced this problem?
>
> There is a member size limit inherent to the tar-archive code, although I
> thought it was 8G not 4G.  I'd recommend using custom format (-Fc not
> -Ft).
>
> Still, if the thing is truncating your data and not telling you so, that'd
> qualify as a bug.
>
> On some platforms there might be a problem with lack of large-file support
> at the stdio level, too.  What is your platform?
>
> regards, tom lane
>
>


pgsql-general by date:

Previous
From: "Holger Hoffstaette"
Date:
Subject: Re: PostgreSQL's XML support comparison against other RDBMSes
Next
From: Seneca Cunningham
Date:
Subject: Re: More AIX 5.3 fun - out of memory ?