question about sql database connection

Post Reply
Gomez
Posts: 2
Joined: Sun Mar 08, 2020 10:09 pm

question about sql database connection

Post 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
Schulze
Support
Support
Posts: 304
Joined: Fri Mar 22, 2019 4:21 pm
Contact:

Re: question about sql database connection

Post 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.
Schulze
Support
Support
Posts: 304
Joined: Fri Mar 22, 2019 4:21 pm
Contact:

Re: question about sql database connection

Post 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
Post Reply