Re: Some Problems - Shall I reinstall the DB?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Some Problems - Shall I reinstall the DB?
Дата
Msg-id 4D4729E1.6080005@gmail.com
обсуждение исходный текст
Ответ на Some Problems - Shall I reinstall the DB?  (vwu98034@lycos.com)
Список pgsql-general
On 01/31/2011 01:18 PM, vwu98034@lycos.com wrote:
> The DB connection problem has nothing to do with Hibernate. As I have said that the problem can be solved by
restartingthe DB. 
>This problem occurs with my application as well as DdVisualizer.

So know we know it is a generic connection problem. Is there information
in the Postgres logs that might be helpful?

>
> And as I have mentioned, the id error doesn't occur to other table.

Again is there any information generated in the logs when you try to
connect to that table?  Another thing to check is whether the max id in
the table is greater then the last value for the sequence associated
with that table. Could be id(s) got inserted without using the sequence.

>

At this time reinstalling the DB would seem to be excessive. There is no
guarantee that the problem won't just appear again with out knowing what
is in the first place.

--
Adrian Klaver
adrian.klaver@gmail.com

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Some Problems - Shall I reinstall the DB?
Следующее
От: bricklen
Дата:
Сообщение: PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"