Datacenter Provisioning - Installation of a POSTGRESQL Database Server - MONGODB - [Raspberry PI 4/Rock64]

(**) Translated with

[ 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.


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.


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


I refer you to this article


For management, administration, tuning of Postgresql or MongoDB databases: DuckDuckGo….

(**) Translated with