Re: Bug #948: Postgresql server abruptly shutdown now data

"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

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