best way to storing logs

Поиск
Список
Период
Сортировка
От Ibrahim Edib Kokdemir
Тема best way to storing logs
Дата
Msg-id CABnTomKQLSDE1x7a5YVhWSWoqtQLq5qHSHBP3yQHKqsY5ABzvg@mail.gmail.com
обсуждение исходный текст
Ответы Re: best way to storing logs  (PT <wmoran@potentialtech.com>)
Список pgsql-general
Hi,
In our environment, we are logging "all" statements because of the security considerations (future auditing if necessary). But the system is very big and produces 100GB logs for an hour and we expect that this will be much more. We are having trouble to find the disk for this amount of data.

Now, we are considering one of the following paths:
- deduped file system for all logs. 
- parsing useful lines with syslog server or pgaudit. And are there any drawbacks for using remote syslog for the logs?

What should be the right path for that?

Regards,
Ibrahim.

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

Предыдущее
От: Gary Chambers
Дата:
Сообщение: pgcrypto Documentation/Function Mismatch
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: pgpool Connections Distributions Among Nodes