MADRIX Forum • question about sql database connection
Page 1 of 1

question about sql database connection

Posted: Wed Oct 28, 2020 10:27 pm
by Gomez
Olá madrix

For our project we would use radar and for testing we bought an interface stella and connected it to the network and rdm lamps.
The lamps are found by the radar and values are also retrieved.
But some problems prevent us from using it.

1. Is there is a way to set up a backup system to back up radar data.

2. We can't activate the psql settings in radar even though we have configured the stella and the psql server in the same network.

3. We see in the manual that the psql settings have a network port but no network IP address for the server. What else must be available to automatically find the database server on the network.

Regards Gómez

Re: question about sql database connection

Posted: Mon Nov 02, 2020 5:09 pm
by Schulze
Hi Gomez,

Please see my answers below:

1. "Is there is a way to set up a backup system to back up radar data."
- No sorry, since a database system as being used to store the collected data, the data base is also responsible to secure the data. That means the backup system needs to be provided by the data base system itself (in your case the PostgreSQL database).
- Please note that the Big Data/History feature not only requires a PostgreSQL Server, but also a MADRIX RADAR Big Data license.

2. "We can't activate the psql settings in radar even though we have configured the stella and the psql server in the same network.[...] What else must be available to automatically find the database server on the network.
- Unfortunately this is not possible, since the PostgreSQL Sever needs to be installed locally on the same computer system. It is not possible to access the data base using a network.

Re: question about sql database connection

Posted: Fri Aug 12, 2022 9:18 am
by Schulze
Hi Gomez,

With the release of MADRIX RADAR 1.2 it is now possible to establish connections to a remote PSQL server [and not only locally on the same computer]!

Please find the complete releasenotes here:
https://www.madrix.com/products/software/releases#MR12