Re: Database shut down unexpectedly.

In response to Tim Uckun <timuckun@gmail.com>:

> Today the database shut down unexpectedly.  I have included the log file
> that shows the shutdown. Can anybody tell me why this happened and how I can
> make sure it doesn't happen again.
>
> The only thing I can think of that I did was to specify a password for the
> postgres user in the operating system.

Not likely to cause the DB to restart ... at least not in any OS
configuration that I'm aware of.  However, you don't mention what
OS you're running ... that might be important.

> Here is the log file.  Very strange.
>
> 2009-03-25 00:02:01 GMT LOG:  incomplete startup packet
> 2009-03-25 00:30:05 GMT LOG:  could not receive data from client: Connection
> timed out
> 2009-03-25 00:30:05 GMT LOG:  unexpected EOF on client connection
> 2009-03-25 00:30:05 GMT LOG:  could not receive data from client: Connection
> timed out
> 2009-03-25 00:30:05 GMT LOG:  unexpected EOF on client connection
> 2009-03-25 00:32:15 GMT LOG:  could not receive data from client: Connection
> timed out
> 2009-03-25 00:32:15 GMT LOG:  unexpected EOF on client connection
> 2009-03-25 02:41:57 GMT LOG:  incomplete startup packet
> 2009-03-25 02:41:57 GMT LOG:  received smart shutdown request

                               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Sure looks like someone intentionally shut the database down.