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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!
Дата
Msg-id 15166.1143733738@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!  (lmyho <lm_yho@yahoo.com>)
Ответы Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian!  (lmyho <lm_yho@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Salem Berhanu"
Дата:
Сообщение: Re: postgres and persistant connections (using Apache::DBI)
Следующее
От: Steve Linabery
Дата:
Сообщение: can't get connection during pg_dump