HeideSQL Access to Default PostgreSQL Archive Database

[yotool]

** Is it possible to connect directly to the default PostGreSQL archival database using HeideSQL (or similar alternatives)?

** Is the PostgreSQL listening on the “standard” TCP port 5432?

** What is the default user-name and password to establish this possible direct connection?

Thanks for your thoughts.

[yotool]

Ok…

I now see that you ar still, by default using your proprietary *.dat archive file format.

** As I asked in a different thread, how can I “edit” the “minute” and “hourly” data entries in Rapid Scada v.6.1 as in the previous 5.X “Server” application”?

That feature was useful for fixing known-bad historical data entries.

Thanks.

[yotool]

update:

I believe I now see how minute/hour/daily archives can be redirected to PostGreSQL.

I have PostGreSQL installed on the local Rapid Scada Windows 10 host.

I have HeideSQL also properly communicating with the default PostGreSQL service running on the standard TCP/IP port for PostGreSQL.

If optionally configured to use the PostGreSQL database engine, I can use this technique to read/write Server module “Archive” data, and take full advantage of all of the PostGreSQL features, but I’m just asking if the proprietary *.dat files can be “edited” as in the past.

Thanks for the help.

[Mikhail]

*.dat format is not proprietary, it’s documented and can be used by anyone for free.

I suppose, you can use HeideSQL or DBeaver to connect to PostgreSQL. However, there is a default tool, named pgAdmin. Username, password and port are specified during PostgreSQL installation.

[Mikhail]

Check the tools such as DatViewer-v6 and TrendTableViewer-v6 that allow to view *.dat files. Tools for editing have not been developed yet. Use ScadaTestClient-v6 to update data in archives.
I hope that the DAT viewers will be updated to editors later.

[Anonymous]

Use a PostgreSQL-Compatible Client:

pgAdmin:
pgAdmin is a popular PostgreSQL administration and management tool. It’s specifically designed for PostgreSQL and provides a user-friendly interface.
Download and install pgAdmin from the official website: https://www.pgadmin.org/
Connect to your PostgreSQL server using the appropriate connection details.

DBeaver:
DBeaver is a universal database tool that supports various database management systems, including PostgreSQL.
Download and install DBeaver from the official website: https://dbeaver.io/
Create a new database connection, select PostgreSQL as the database type, and provide the connection details.

[Author]

Posts