Re: help getting a backtrace from 9.2 on Ubuntu 13.04?

From: Marcin Mańk <marcin(dot)mank(at)gmail(dot)com>
To: Chris Curvey <ccurvey(at)zuckergoldberg(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: help getting a backtrace from 9.2 on Ubuntu 13.04?
Date: 2013-09-10 00:30:29
Message-ID: CAK61fk4DSKjsbVvNssfkU6GbJc8H=QA2Lj9T5c8o_02Ms8wGyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 9, 2013 at 4:00 PM, Chris Curvey <ccurvey(at)zuckergoldberg(dot)com>wrote:

> But I'm having troubles with the 9.2 server crashing when I'm restoring
> the dump. I'm using the 9.2 version of pg_dump. I've tried restoring a
> custom-format dump with pg_restore, and I've tried restoring a text-format
> dump with pqsl, and both of them are crashing on me.
>
> The data is too sensitive for me to submit a database dump to the
> community, but I'd like to submit a stack trace, in the hopes that someone
> might be able to figure out what's going on. But I'm having some trouble
> getting this done.
>

Is it crashing on a specific database object? pg_restore -v will tell you
how far it went. Then try to restore only that object. Is it perhaps
crashing on a specific row?

Try producing a self contained test case (like only the culprit table,
anonymized).

Regards
Marcin Mańk

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Hahn 2013-09-10 00:39:57 Re: Call for design: PostgreSQL mugs
Previous Message Cyclix 2013-09-10 00:17:58 Re: Call for design: PostgreSQL mugs