Re: Partition, inheritance for storing syslog records.

2019-11-18 Thread David Rowley
On Tue, 12 Nov 2019 at 00:45, Mimiko wrote: > There could be not sub-partition by fromhost. Only by syslogtag, then by year. > > So how could be this accomplished both in version 8.4 and in version 12. > Other ideas are welcome. > > The main goal is to be able to quickly investigate logs from som

Re: Partition, inheritance for storing syslog records.

2019-11-18 Thread Mimiko
Any one can give some advice? On 11.11.2019 13:45, Mimiko wrote: Hello. I beg for the community ideas on how to do in the best way. I use centrally storing syslog messages in Postgres. All devices send syslog messages to a server (or could be several in fault tolerance) which use rsyslog to s