From: | Mott Leroy <mott(at)acadaca(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Incomplete Startup Packet |
Date: | 2005-11-16 21:42:03 |
Message-ID: | 437BA7AB.8070604@acadaca.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Some time ago, I accidentally did a kill -9 on the postmaster (yes, I
know, I know), when trying to kill -9 one of the child processes (er,
yeah, probably bad too). This turned out to be pretty bad for us. It put
the database in a bad state. I had to run some kind of hacky command (I
don't recall which one) to even get postgres to start up again. Since
then, the log file is littered with:
LOG: incomplete startup packet
I am ok with the fact that the abrupt killing of the postmaster may have
corrupted some data. It is not a mission critical data we're talking
about. But I'm left with some questions -
Is my database hosed? Does this necessitate a full reinstall of
postgres? While not mission critical data, there is a lot of it, and
many dbs in the cluster which would mean hours of data loading. (The
database seems to be functioning just fine, but I seem to recall reading
that a reinstall is recommended, though I forget why)
- Mott
As a side question, probably unrelated -- i understand that kill -9
postmaster is bad, but how bout killing a child process (a client)? I've
noticed that if you kill a child process, it seems to kill all child
processes and reboot (like a SIGUP?) [I was doing this in order to kill
a hanging transaction.]
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2005-11-16 21:53:50 | Re: Rebranding PostgreSQL |
Previous Message | Vivek Khera | 2005-11-16 21:29:02 | Re: Rebranding PostgreSQL |