Re: [GENERAL] Transaction logging

Поиск
Список
Период
Сортировка
От Thomas Reinke
Тема Re: [GENERAL] Transaction logging
Дата
Msg-id 36D2DD57.E5C9C545@e-softinc.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Transaction logging  (jim@reptiles.org (Jim Mercer))
Ответы Re: [GENERAL] Transaction logging  (jim@reptiles.org (Jim Mercer))
Re: [GENERAL] Transaction logging  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-general
Don't use syslog under any circumstances!!!!

1. Syslog breaks up records longer than X number of bytes - you'd
   have to piece them together.

2. Communication to syslog is over udp - (i.e. unreliable message
   sends) thus message loss can occur.

3. All the other complaints about syslog already mentioned: additional
   data added to the logs, etc.

Jim Mercer wrote:
>
> > This is a great idea.  I have not been successful in tracking any
> > information on syslog.  Any suggestions on where I might find some good
> > documentation on syslog?
> >
> >       Just a quick thought, but how about using syslog? That can be used
> > to post queries to a remote server, and it can be told to store the
> > "postgres" stuff to a seperate file on that server.
>
> i don't know that syslog is robust enough for what you want.
>
> i don't think it has any error checking to verify that a message was
> received, etc.
>
> most BSD's and linux would have good refernce ports of syslogd, etc.
>
> --
> [ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
> [ The telephone, for those of you who  have forgotten, was a commonly used ]
> [ communications technology in the days before electronic mail.            ]
> [ They're still easy to find in most large cities. -- Nathaniel Borenstein ]

--
------------------------------------------------------------
Thomas Reinke                            Tel: (416) 460-7021
Director of Technology                   Fax: (416) 598-2319
E-Soft Inc.                         http://www.e-softinc.com

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

Предыдущее
От: James Thompson
Дата:
Сообщение: Re: [GENERAL] Database Creation Script
Следующее
От: jim@reptiles.org (Jim Mercer)
Дата:
Сообщение: Re: [GENERAL] Transaction logging