Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%

Поиск
Список
Период
Сортировка
От Shane Wright
Тема Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%
Дата
Msg-id 3FB00997.8030704@shanewright.co.uk
обсуждение исходный текст
Ответ на Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: Trying to pg_restore a 7.1.3 db into 7.3.4 - stalling at 100%  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-admin
Gaetano,

er, shedloads of this....

read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0
read(0, "", 4096)                       = 0


methinks thats not a good sign?

Shane

Gaetano Mendola wrote:

> 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Problems Compiling eRserver
Следующее
От: Gautam Saha
Дата:
Сообщение: ER diagram tool for PostgresSQL7.3