Thread: Re: Bug #948: Postgresql server abruptly shutdown now data
Re: Bug #948: Postgresql server abruptly shutdown now data
From
"SALUNKHE,MANDAR (HP-Singapore,ex1)"
Date:
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