| From: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
|---|---|
| To: | Reuven M(dot) Lerner <reuven(at)lerner(dot)co(dot)il> |
| Cc: | pgsql-general(at)postgresql(dot)org, eli-d(at)nova(dot)co(dot)il |
| Subject: | Re: Hanging with pg_restore and large objects |
| Date: | 2010-12-07 18:17:50 |
| Message-ID: | 6A15E58C-B0F3-4FDB-9AD9-EB002D10D1EC@solfertje.student.utwente.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 have been 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 (Not with 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kobi Biton | 2010-12-07 18:18:56 | Re: *****SPAM***** Re: if-clause to an exiting statement |
| Previous Message | Kevin Grittner | 2010-12-07 18:01:03 | Re: restore In parallel postgres 9 |