From: Tom Lane <tgl@sss.pgh.pa.us>
To: lmyho <lm_yho@yahoo.com>
Cc: Chris Travers <chris@verkiel.metatrontech.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Date: Thu, 30 Mar 2006 10:48:58 -0500
Message-ID: <15166.1143733738@sss.pgh.pa.us> (raw)
In-Reply-To: <20060330041419.80853.qmail@web30804.mail.mud.yahoo.com>
References: <20060330041419.80853.qmail@web30804.mail.mud.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, lm_yho@yahoo.com, chris@verkiel.metatrontech.com
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
In-Reply-To: <15166.1143733738@sss.pgh.pa.us>
References: <20060330041419.80853.qmail@web30804.mail.mud.yahoo.com> <15166.1143733738@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox