marius/gist
1
0
Fork 0
Code Issues Activity
main
gist/postgre
History
marius 5d992e89bd Sample SQL query for JSOB for logs
2023-05-06 13:42:24 +00:00
..
postgre adding PostgreSQL DB lab deployment 2023-04-24 17:00:21 +02:00
queries Sample SQL query for JSOB for logs 2023-05-06 13:42:24 +00:00
Readme.txt adding PostgreSQL DB lab deployment 2023-04-24 17:00:21 +02:00

Readme.txt 

These are lab files. The passowords and grants are not real.

* Ansible Playbook that installs a PostgreSQL DBMS
* applies configuration for ingest optimization (performance)
* script generates table to make a database named logs
* table named logs
  * log_data JSONB (rows)

* Corresponding Rsyslog server does the ingest, has a LinkedList queue (currently appox 80 MB)

https://code.because-security.com/marius/gist/src/branch/main/rsyslog