"Chun Yit\(Chronos\)" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend