"Chun Yit\(Chronos\)" <ivanbeh@chronos.com.my> writes:
> what i did is i=20
> 1) kill -9 (postmaster process id).
> 2) remove the postmaster.pid file under /usr/local/pgsql/data/
> 3) restart the postmaster process.
The *first* thing you ought to do is learn not to do that. You
deliberately broke the safety interlocks that keep two separate sets of
backends from being active in a single database. If there's corrupted
data in there now, I think it's your own fault.
regards, tom lane