Kakoli Sen wrote:
Hi, Actually, I tried stopping server by 'kill `cat /opt/pgsql/data/postmaster.pid`. This did not work. So I used kill -9 on Red Hat 4. This is a test database where we are in the process of setting up. So it does not have live data. Still I do agree, it was not a good idea. Now, do I have to re-install PostgreSQL or is there any way out?
Well, if it's a test database you should be able to rename or remove the data directory and then re-run initdb, since you don't care about the data in the database.
I'm sure you want to find out why this happened, though, so maybe you should keep the damaged database around for a while and see if anybody here has ideas about what could've happened.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
