Re: [PATCHES] Point in Time Recovery

Поиск
Список
Период
Сортировка
От markw@osdl.org
Тема Re: [PATCHES] Point in Time Recovery
Дата
Msg-id 200407271741.i6RHfd103421@mail.osdl.org
обсуждение исходный текст
Список pgsql-hackers
On 26 Jul, To: simon@2ndquadrant.com wrote:
> Sorry I wasn't clearer.  I think I have a better idea about what's going
> on now.  With the archiving enabled, it looks like the database is able
> to complete 1 transaction per database connection, but doesn't complete
> any subsequent transactions. I'm not sure how to see what's going on.
> Perhaps I should try a newer snapshot from CVS while I'm at it?

I tried to do an strace on the postmaster (and child processes) to see
if that might show something, but when the postmaster starts the
database isn't accepting any connections.  I have the feeling it's not
really starting up.  Trying to shut it down seems to agrees with that.
My wild guess is that the database is sitting waiting for something when
a stored function is called but I'm not sure how to verify that.

Mark


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Savepoints inside functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Savepoints inside functions