There two way selfhost matrix server via synapse docker
-
Default way with SQLITE database
-
Using POSTGRESQL [ recommend for large events like bigger inbox or in large rooms ]
use any one meathod
Example of 'Homeserver.yaml' with postgre support
check file example_homeserver.yaml file this file for showcase how to i implimented the support
this can be generate using setup_matrix_server.sh script