| 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: | Whole Thread | Raw Message | 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
| 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 |