As @UliNobbe already explained, the PostgreSQL server in DSM is only meant for internal purposes of DSM. And even though some people managed to “open it up” and use it for external software like mAirListDB, this purpose has never been supported officially, and it might just stop to work after some years. Bad luck.
You could use MariaDB instead, there is an official package for DSM.
So this means that we have purchased the wrong NAS. Haven’t we?
Headshaking regards, a happy weekend and stay healthy!
Edit: There is an explanation of how to set up MariaDB with mAirList to be found here. (This is working fine for me but, according to @Torben, will cause issues with a setup incorporating multi user environments.) But as you have managed to get PostgreSQL running already, I assume you might not need this. :o)
I really love my Synology DS213j NAS . It works like a charm, for storage audio files and the PostgreSLQ database. Years after the installation of PostgreSQL (with help from @Torben ) I read here in the forum that this was not a supported solution. It has always performed smoothly, though. Fair enough.
I have a multi-user set-up, since I have a play out PC with mAirList Professional Studio and I have a production PC with mAirList Management licence, where I import and edit my files. Both PC’s are connected to the (PostgreSQL) Database. Does this mean I cannnot use MariaDB or MySQL?
OK, here’s the situation. I cannot connect to the PostgreSQL Database anymore, so cloning is no longer possible
I installed mAirList 6.3 beta Trial (professional Studio, same as my licence). I did not import the settings of mAirList 6.1 yet, since my old databse settings are still in there. I installed a LocalDB for mAirList 6.3. Now I want to copy all my settings of mAirList 6.1 to mAirList 6.3, except for the database settings.