On Mon, Sep 9, 2013 at 4:00 PM, Chris Curvey <ccur...@zuckergoldberg.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