Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100% - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%
Date
Msg-id 3FAFE25C.4050508@bigfoot.com
Whole thread Raw
In response to Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100% CPU w/ no disk access  (me@shanewright.co.uk (Shane Wright))
Responses Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%
Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: pg_shadow dump annoying problem
Next
From: Andrew Sullivan
Date:
Subject: Re: Problems Compiling eRserver