Re: pg_upgrade: out of memory - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_upgrade: out of memory
Date
Msg-id 22246.1348841733@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_upgrade: out of memory  ("Carrington, Matthew (Produban)" <Matthew.Carrington@Produban.co.uk>)
Responses Re: pg_upgrade: out of memory
List pgsql-general
"Carrington, Matthew (Produban)" <Matthew.Carrington@Produban.co.uk> writes:
> I've tried to explore the issue a bit more using 9.2.1. Here's a trace of the build and dump tests ...

As long as you're building your own copy, how about building with
--enable-debug and getting a stack trace showing where the error is
being thrown?  Setting a breakpoint at exit_horribly() ought to do
the trick.  To be concrete:

    gdb pg_dump
    gdb> b exit_horribly
    gdb> run --port 65432 ... rest of command line for pg_dump ...
    ... wait for breakpoint to be hit, then ...
    gdb> bt
    ... copy and paste the printout here ...
    gdb> quit

            regards, tom lane


pgsql-general by date:

Previous
From: "ac@hsk.hk"
Date:
Subject: Re: replicate or multi-master for 9.1 or 9.2
Next
From: "Carrington, Matthew (Produban)"
Date:
Subject: Re: pg_upgrade: out of memory