Re: psql won't stayed connected - Mailing list pgsql-admin

From Kevin Izzet
Subject Re: psql won't stayed connected
Date
Msg-id OF8C7AB545.C0FC08C5-ON80256EE8.0031C501-80256EE8.0031E905@nsc.com
Whole thread Raw
In response to psql won't stayed connected  ("Kevin Izzet" <Kevin.Izzet@nsc.com>)
Responses Re: psql won't stayed connected  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin


Hi Tom,


Thanks for the reply but forgive my ignorance but how do I setup the debugger breakpoint ?




Regards

Kevin Izzet

Database / Unix  Administrator
Tel:     (Code)+44(0)1475 655606
Fax:    (Code)+44(0)1475 637755
Email:  Kevin.Izzet@nsc.com



"Tom Lane" <tgl@sss.pgh.pa.us>

05/08/2004 20:13

       
        To:        "Kevin Izzet" <Kevin.Izzet@nsc.com>
        cc:        pgsql-admin@postgresql.org
        Subject:        Re: [ADMIN] psql won't stayed connected



"Kevin Izzet" <Kevin.Izzet@nsc.com> writes:
> Aug  5 17:01:38 uklnx04 postgres[28522]: [230-1] DEBUG:  00000:
> InitPostgres
> Aug  5 17:01:38 uklnx04 postgres[28522]: [230-2] LOCATION:  PostgresMain,
> postgres.c:2639
> Aug  5 17:01:38 uklnx04 postgres[28522]: [231-1] DEBUG:  00000:
> proc_exit(0)
> Aug  5 17:01:38 uklnx04 postgres[28522]: [231-2] LOCATION:  proc_exit,
> ipc.c:95

That's pretty bizarre ... I didn't think there were any code paths that
would get to proc_exit without emitting an error message.

Can you set a debugger breakpoint at proc_exit and see what the call
stack looks like?  (You can slow things down enough to attach to the
backend with gdb by using the -W switch:
                PGOPTIONS="-W 30" psql ...

                                                  regards, tom lane






*************************************************************************************
This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is prohibited. If you are not the intended or authorised recipient please contact the sender by reply email and delete all copies of this message

pgsql-admin by date:

Previous
From: mike g
Date:
Subject: Re: Connecting to remote Database
Next
From: Edgars
Date:
Subject: test