help getting a backtrace from 9.2 on Ubuntu 13.04?

From: Chris Curvey <ccurvey(at)zuckergoldberg(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: help getting a backtrace from 9.2 on Ubuntu 13.04?
Date: 2013-09-09 14:00:36
Message-ID: EE2174E2DC02564F848D30D14B432D279DC44A52@exchangemb2.local.zuckergoldberg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have a production server running PG 8.4 on RHEL6. I have a development server running PG 9.2 on Ubuntu 13.04. Periodically, I like to take a dump of the production server and load it on the development machine.

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.

I'm looking at the instructions at http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

Which points me to https://wiki.edubuntu.org/DebuggingProgramCrash

Which tells me to install the “dbg” version of my package, so I have installed postgresql-9.2-dbg

The PG wiki page tells me to download and run list-dbgsym-packages-v2.sh, but the Edubuntu page says that that script has been supplanted by list-symbols-packages-v2.sh. Okay, so I run

chris(at)mu:~/Downloads$ sudo bash list-symbols-packages-v2.sh -p $(pidof -s postgres)

and get

warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7fffcbae5000

any idea where I go from here?

Disclaimer

THIS IS A CONFIDENTIAL COMMUNICATION. The information contained in this e-mail is attorney-client privileged and confidential, intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are here by notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail or by telephone (908) 233-8500.Thank you..

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pg noob 2013-09-09 14:10:35 Re: select DISTINCT
Previous Message Oliver Kohll - Mailing Lists 2013-09-09 13:50:27 Re: Making substrings uppercase