(**) Translated with www.DeepL.com/Translator
[ LEVEL ] Beginner I try as much as possible to privilege the implementation of software using the “PostgreSql” database.
Moreover, the incident management software I use: Trudesk, requires a MongoDB database service.
Concerning Trudesk, its new versions are unfortunately no longer available for download. The last update is dated 05/02/2020, we can consider that there will be no more maintenance on this product.
This procedure allows the installation of a server to store application data:
- Nextcloud
- Matrix
- Ossec
- Trudesk
- …
You can install these two services on the same machine, unless you heavily load both systems simultaneously.
Prerequisite
To perform this operation you must :
- have a Raspberry PI4 server (4BG mini recommended) with 64-bit RaspiOS or a Rock64 with 64-bit ArmBian.
- have followed the procedure Follow the procedure for installation of operating systems
- know how to execute a command in a Linux console
- be connected “root” to the console, for sudo users: type
sudo bash
. - have a 32GB SD card or SSD disc connected to the USB3 port.
Postgresql
Installation of necessary packages
apt-get -y update
apt-get -y install postgresql
The service starts automatically and listens by default on port 5432/TCP.
systemctl status postgreql
postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Fri 2020-11-13 19:17:08 CET; 2 months 14 days ago
Main PID: 752 (code=exited, status=0/SUCCESS)
Tasks: 0 (limit: 4915)
CGroup: /system.slice/postgresql.service
Opening Communication Ports (Firewall)
Protocol | Port | Way | Network Interfaces |
---|---|---|---|
TCP | 5432 | Input | Interface(s) connected to the datacenter |
MongoDB
I refer you to this article
Conclusion
For management, administration, tuning of Postgresql or MongoDB databases: DuckDuckGo….