Re: Hanging with pg_restore and large objects - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Hanging with pg_restore and large objects
Date
Msg-id 6A15E58C-B0F3-4FDB-9AD9-EB002D10D1EC@solfertje.student.utwente.nl
Whole thread Raw
In response to Hanging with pg_restore and large objects  ("Reuven M. Lerner" <reuven@lerner.co.il>)
Responses Re: Hanging with pg_restore and large objects  ("Reuven M. Lerner" <reuven@lerner.co.il>)
List pgsql-general
On 7 Dec 2010, at 14:51, Reuven M. Lerner wrote:
> My guess is pg_dump in 8.3 is somehow causing a problem in the dumpfile on or around that large object.

Which version of pg_dump did you use? The one that came with the 9.0 install or the one from the old 8.3 one? It should
havebeen the first of these two. 

Regardless, IMHO it shouldn't behave like it does for you now. It doesn't look like it's waiting on a lock elsewhere
(Notwith a CPU load like that), so it should either refuse or bail out, not enter some seemingly endless loop. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4cfe7a60802658365545708!



pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [ADMIN] restore In parallel postgres 9
Next
From: "Massa, Harald Armin"
Date:
Subject: is anyone from the pokertracker.com within this mailing list?