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

Dear Tom,
Thanks for your reply.
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."?
Please do reply as the matter is critical.

Thanks

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

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us> ]
Sent: Thursday, April 17, 2003 10:48 PM
To: mandar(dot)salunkhe(at)hp(dot)com; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] Bug #948: Postgresql server abruptly shutdown now
database doesnt start

pgsql-bugs(at)postgresql(dot)org writes:
> But now when we run this , we get

> hp(at)ACACIA ~
> $ cd /usr/local/pgsql/bin/

> hp(at)ACACIA /usr/local/pgsql/bin
> $ ipc-daemon &
> [1] 18140

> hp(at)ACACIA /usr/local/pgsql/bin
> $ ./postmaster -i -D /usr/local/pgsql/data

> And the process hangs there.

I'd have to guess that something is wrong with ipc-daemon. You should look
to see if it has any on-disk state that needs to be cleaned up.

regards, tom lane