Shane Wright wrote:

Hi,

I'm trying to upgrade our 25Gb database from 7.1.3 to 7.3.4 - pg_dump
worked fine, although piping through split to get a set of 1Gb files.

But, after a few attempts on using pg_restore to get the data into the
new installation I'm having a few problems; basically it restores  the
first few tables fine (big tables too), but now it's just hanging on
one table; using 100% CPU but hardly touching the disk at all (vmstat
reports about 50kb every few minutes).

what show an strace on that process ?



Regards Gaetano Mendola


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to