Re: pg_dump causes postgres crash - Mailing list pgsql-general

From Jeff Amiel
Subject Re: pg_dump causes postgres crash
Date
Msg-id 777010.97329.qm@web60823.mail.yahoo.com
Whole thread Raw
In response to Re: pg_dump causes postgres crash  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump causes postgres crash  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> I can't help thinking you are looking at generalized
> system
> instability.  Maybe someone knocked a few cables
> loose while
> installing new network hardware?

Database server/storage instability or network
instability?

There is no doubt that there is something flaky about
the networking between the db server and the box(es)
trying to do the pg_dump.  We have indeed had issues
(timeouts, halts, etc) moving large quantities of data
across various segments to and from these boxes...like
the db server....but how would this effect something
like a pg_dump?

Would a good stack trace (assuming I want to crash my
database again) help here?





____________________________________________________________________________________Ready for the edge of your seat?
Check out tonight's top picks on Yahoo! TV.
http://tv.yahoo.com/

pgsql-general by date:

Previous
From: Terry Yapt
Date:
Subject: FATAL: could not reattach to shared memory (Win32)
Next
From: Oleg Bartunov
Date:
Subject: Re: How to switch off Snowball stemmer for tsearch2?