Observing a common error in Freeradius with Postgres but not justification why it happens

Alan DeKok aland at deployingradius.com
Sat Sep 2 13:30:02 UTC 2023


On Sep 2, 2023, at 8:19 AM, Nathan Ward <lists+freeradius at daork.net> wrote:
> I don’t think you shared how many rows you have, but, 8GB of rows will be a
> lot.

  Yup.

> If you need this data to be retained, my suggestion is that you get someone
> experienced with postgres to help you design this DB and the queries.

  A simple thing is to have one database for current information (e.g. last month or so), and a separate database for historical information.

  I write articles about this:  https://networkradius.com/articles/2022/05/24/split-historical-database.html

  Alan DeKok.



More information about the Freeradius-Users mailing list