Re: Bug #948: Postgresql server abruptly shutdown now data - Mailing list pgsql-bugs

From SALUNKHE,MANDAR (HP-Singapore,ex1)
Subject Re: Bug #948: Postgresql server abruptly shutdown now data
Date
Msg-id B2CFBDADA593FE4D9BD360111FB7F231068D4D76@xsg01.sgp.hp.com
Whole thread Raw
List pgsql-bugs
Dear Tom,
Thanks for your help.

Can you look to see if ipc-daemon is even running?
Yes, when I start ipc-daemon it is running and also I can see its pid both
in the cygwin window and also in Task Manager ( windows). Only later when I
run the
Administrator@HPA4W357 /usr/local/pgsql/bin
$ ./postmaster -i -D /usr/local/pgsql/data
command do things hang up.

About the stack trace part, we have little idea about that part for cygwin,
but is there anyone else you know who could guide us in this?

Thanks for all your help.

Thanks

Mandar Salunkhe
460 Alexandra Road, PSA Building
Singapore 119963
Phone: 65-63617413      HP Telnet Number: 831-7413
Email: mandar.salunkhe@hp.com


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us <mailto:tgl@sss.pgh.pa.us> ]
Sent: Monday, April 21, 2003 9:44 AM
To: SALUNKHE,MANDAR (HP-Singapore,ex1)
Cc: pgsql-bugs@postgresql.org; ARACHI,FRANCIS (HP-Singapore, ex5);
FRANKLIN,JOHNSON (HP-Singapore, ex5)
Subject: Re: [BUGS] Bug #948: Postgresql server abruptly shutdown now data
base doesnt start


"SALUNKHE,MANDAR (HP-Singapore,ex1)" <mandar.salunkhe@hp.com> writes:
> We have rebooted the server and checked if there is any pid for
> ipc-daemon but there was none. Is there any other way to check for "if
> it has any on-disk state that needs to be cleaned up."?

Sorry, I have no idea --- I avoid Windows and have never used Cygwin.

Can you look to see if ipc-daemon is even running?

I'm not sure what debugging tools are available under Cygwin, but if you
have gdb then you could start the postmaster under gdb and then look to see
what the stack trace looks like after it hangs.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "SALUNKHE,MANDAR (HP-Singapore,ex1)"
Date:
Subject: Re: Bug #948: Postgresql server abruptly shutdown now data
Next
From: Erik Walthinsen
Date:
Subject: BUG: Infinite syslog() loop