Multiple datasource for archive data

[joshikk]

I was trying to connect to remote datasource. So I tried the following in my settings.ini file.
IT does not work.

org.csstudio.trends.databrowser3/urls=jdbc:postgresql://localhost/archive|RDB jdbc:postgresql://MYDATA/archive|RDB
org.csstudio.trends.databrowser3/archives=jdbc:postgresql://localhost/archive|RDB jdbc:postgresql://MYDATA/archive|RDB

org.csstudio.archive/url=jdbc:postgresql://localhost/archive jdbc:postgresql://MYDATA/archive

On using only the second datasource, it is working. Am I making any error?

I see that the configuration for the datasource is at module level. Is there any way in which I can configure for multiple datasources?

Is it possible to have a datasource configuration at IOC or PV level?
This will help for of distributed datasources.

Regards,
Kuldeep

[kasemir]

If all fails, read the manual. Relevant section is https://control-system-studio.readthedocs.io/en/latest/preference_properties.html#trends-databrowser3:

# Format:  <url>*<url>|<name>
# List of URLs, separated by '*'.
# Each URL may be followed by an "|alias"

If you have multiple data sources, they need to be separated by '*':

jdbc:postgresql://host1.mysite.org/archive|PGArchive*jdbc:mysql://host2.mysite.org/archive|MySQLArchive

[joshikk]

Sorry, I read the preferences listing diagonally Thank you for your help Regards, Kuldeep

…

On Wed, Sep 8, 2021 at 12:02 PM Kay Kasemir ***@***.***> wrote: If all fails, read the manual. Relevant section is https://control-system-studio.readthedocs.io/en/latest/preference_properties.html#trends-databrowser3 : # Format: <url>*<url>|<name> # List of URLs, separated by '*'. # Each URL may be followed by an "|alias" If you have multiple data sources, they need to be separated by '*': jdbc:postgresql://host1.mysite.org/archive|PGArchive*jdbc:mysql://host2.mysite.org/archive|MySQLArchive <http://host1.mysite.org/archive%7CPGArchive*jdbc:mysql://host2.mysite.org/archive%7CMySQLArchive> — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#2006 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATMOMUIOT4CGLZ6G5TX5LNTUA5GGNANCNFSM5DUCSIOA> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.