Re: FATAL: the database system is starting up

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: FATAL: the database system is starting up
Дата
Msg-id 1394692939489-5795847.post@n5.nabble.com
обсуждение исходный текст
Ответ на FATAL: the database system is starting up  ("William E. Moreno A." <wmoreno3@yahoo.com>)
Список pgsql-general
fluxh wrote
> I have the same problem. I have a log like patrick keshishian. I have not
> a backup.
>
> I don't know that do.
>
> Help me please!!!
>
> Information:
>
> - Server with RAID1 on SAS HD Hot-plug.
> - Ubuntu Server 12.04 x64.
> - Postgresql 9.1.
>
> When I do "psql" PostgreSQL shows "psql: FATAL: the database system is
> starting up" and when I write pg_dump or I try connect with pgAdmin3.

You should supply your actual log file and also provide some narrative of
what exactly you were doing prior to this condition occurring.  Some context
as to architecture wouldn't hurt - such as how many and what kinds of
applications are connecting to the database, especially those that maintain
persistent connections.

System commad output like top and ps may also be of value though after you
provide the background a more directed Q&A can follow.

In short it sounds like you need to force PostgreSQL to shutdown and then
start it back up again.  If you are using the apt package you'd do this via
some invocation of pg_ctlcluster for which there is ample documentation of
both it and the underlying pg_ctl command.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/FATAL-the-database-system-is-starting-up-tp4941646p5795847.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


В списке pgsql-general по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: libpq - lack of support to set the fetch size
Следующее
От: Johannes Bauer
Дата:
Сообщение: UNIQUE contraint that is initially deferred in Postgres 8.4.13