Issues with restoring - Mailing list pgsql-general

From beer
Subject Issues with restoring
Date
Msg-id 2358.128.237.236.250.1143493395.squirrel@128.237.236.250
Whole thread Raw
Responses Re: Issues with restoring  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hello Folx!

We are running into a problem that I wanted to run by the group before I report it as a bug.

We have a medium sized database that when dumped creates +4G files within the tar archive.  When we restore it seems
thatpg_restore has a 4G limit for reading files, once it reads 4G of a file, it moves on to the next file.  Has anyone
elseexperienced this problem?  Is there a documented way for mitigating this issue that I have not found?  Is this a
bugor are we doing something incorrectly to cause this?  It seems to me if pg_restore has a hard limit of 4G filesize
thenpg_dump should have the same limit. 

TIA

-bill


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: getting deadlocks on full table lock
Next
From: "Merlin Moncure"
Date:
Subject: Re: getting deadlocks on full table lock