best way to storing logs - Mailing list pgsql-general

From Ibrahim Edib Kokdemir
Subject best way to storing logs
Date
Msg-id CABnTomKQLSDE1x7a5YVhWSWoqtQLq5qHSHBP3yQHKqsY5ABzvg@mail.gmail.com
Whole thread Raw
Responses Re: best way to storing logs  (PT <wmoran@potentialtech.com>)
List 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 by date:

Previous
From: Gary Chambers
Date:
Subject: pgcrypto Documentation/Function Mismatch
Next
From: Tatsuo Ishii
Date:
Subject: Re: pgpool Connections Distributions Among Nodes