Re: How could we make it simple to access the log as a table?

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: How could we make it simple to access the log as a table?
Дата
Msg-id m28vgciabm.fsf@2ndQuadrant.fr
обсуждение исходный текст
Ответ на Re: How could we make it simple to access the log as a table?  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: How could we make it simple to access the log as a table?  (Christopher Browne <cbbrowne@gmail.com>)
Список pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> This is really where I was hoping to eventually get to with the logging
> changes that have been discussed over the past couple of years.  We need
> to have a mechanism to allow logging to different places, based on
> information included in the log message and/or context, where one of
> those places could potentially be some kind of receiver process that
> then dumps the message into a table, either on the local system or on a
> remote system.

That looks like syslog features? 
> What exactly all of that looks like and how it works is a pretty big
> discussion, but I'd definitely love to hear from others who are
> interested in changes to our logging infrastructure.

I though about exposing the log CSV files as partitions of a log table,
each partition being a FDW able to read the file.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Backends stalled in 'startup' state: index corruption
Следующее
От: Christopher Browne
Дата:
Сообщение: Re: How could we make it simple to access the log as a table?