Re: pgsql 7.1.2 server hanging...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pgsql 7.1.2 server hanging...
Дата
Msg-id 1405.993519954@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pgsql 7.1.2 server hanging...  (Ed Loehr <eloehr@austin.rr.com>)
Список pgsql-general
Ed Loehr <eloehr@austin.rr.com> writes:
> I am trying out postgresql 7.1.2.  I'm experiencing a hung server on
> linux 2.4.2-2 when I run a sql script that drops & reloads many PL/pgSQL
> functions and triggers, as well as hanging during VACUUM ANALYZE.

Are you sure it's hung, and not just waiting on some open transaction
in another backend that's holding a lock on some table?  There's nothing
even slightly unusual about the log excerpts you're showing...

            regards, tom lane

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

Предыдущее
От: lbayuk@mindspring.com (ljb)
Дата:
Сообщение: Re: 7.1.2 ERROR: UNIQUE constraint matching given keys for referenced table ......
Следующее
От: "Dave Cramer"
Дата:
Сообщение: RE: PostgreSQL: YMMV?