Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian! - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Date
Msg-id 15166.1143733738@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!  (lmyho <lm_yho@yahoo.com>)
Responses Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
List pgsql-admin
lmyho <lm_yho@yahoo.com> writes:
> In more detail, the logs looks like:
> ...
> imcomplete startup packet
> received fast shutdown request
> shuttingdown
> database system is shut down
> logger shutting down

> Something like this, each has a little different, but ends the same way.

This is not a "server does not start" problem.  This is something
sending SIGINT to the postmaster, which makes it terminate.

Do all the log files mention "incomplete startup packet" right before
the shutdown request?  That's not a very usual message, and it might
be a clue to what's causing the SIGINT.

You might try setting log_line_prefix to '%m ' in postgresql.conf to add
timestamps to the log messages --- that would tell us more about which
messages are actually appearing close together in time.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Salem Berhanu"
Date:
Subject: Re: postgres and persistant connections (using Apache::DBI)
Next
From: Steve Linabery
Date:
Subject: can't get connection during pg_dump