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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: lmyho <lm_yho(at)yahoo(dot)com>
Cc: Chris Travers <chris(at)verkiel(dot)metatrontech(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Date: 2006-03-30 15:48:58
Message-ID: 15166.1143733738@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

lmyho <lm_yho(at)yahoo(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Linabery 2006-03-30 16:00:42 can't get connection during pg_dump
Previous Message Salem Berhanu 2006-03-30 15:48:42 Re: postgres and persistant connections (using Apache::DBI)