# Internal Historian - QuestDB, not listed in Database Query Browser

**URL:** <https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238>\
**Category:** Ignition 8.3 Early Access\
**Created:** [August 1, 2025, 6:37am UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238 "2025-08-01T06:37:59Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![THauptman](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@THauptman](https://forum.inductiveautomation.com/u/THauptman)\
**Post date:** [August 1, 2025, 6:37am UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/1 "2025-08-01T06:37:59Z")

</div>

Hi everyone.

I set up Internal Historian QuestDB and linked a tag to this storage provider. I can see in the status page that the tag data is being stored successfully.

However, I don’t see this storage provider listed in the **Database Query Browser** in the Designer.

Am I missing something?

Thanks in advance for your help!

---

<div class="post-metadata">

**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\
**Post date:** [August 1, 2025, 10:42am UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/2 "2025-08-01T10:42:30Z")

</div>

I believe I read somewhere that if you want to be able to read it using Postgres queries that you need to check a box in the settings of the provider. Even then, I believe you'd probably need to set up a separate database connection manually. From Ignition, the historian isn't intended to do manual queries from itself as those should use the built in scripting functions for this like `queryTagHistory`.

---

<div class="post-metadata">

**Author:** ![robertm](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@robertm](https://forum.inductiveautomation.com/u/robertm)\
**Post date:** [August 1, 2025, 3:20pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/3 "2025-08-01T15:20:05Z")

</div>

Are the alarm journals and audits going to divorced from the quest dB database and still use something like MSSQL? Will tables like user/roles be intergrated into the questDB or also still in an external dB. Trying to wrap my head around is the integrated historian purely for tag data. Also, will there be a means to import existing SQL historical data into an 8.3 upgrade or will two historians need to be maintained?

---

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [August 1, 2025, 3:39pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/4 "2025-08-01T15:39:06Z")

</div>

QuestDB seems to be a more powerful alternative for the history provider.  
I suppose alarms journal and audits stay with sql db...That’s probably why there is only 1 licences for the 2 modules.  
That enable to smoothly upgrade existing 8.1 system to 8.3, existing historian for tag data can be unchanged or when you switch to questdb you need to use system.historian.\* new function too...

---

<div class="post-metadata">

**Author:** ![Kyle.Chase](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@Kyle.Chase](https://forum.inductiveautomation.com/u/Kyle.Chase)\
**Post date:** [August 1, 2025, 5:27pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/5 "2025-08-01T17:27:36Z")

</div>

The internal QuestDB historian does not use a database connection to perform it's function. What are you trying to accomplish with database connection?

---

<div class="post-metadata">

**Author:** ![David\_Folkner](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@David\_Folkner](https://forum.inductiveautomation.com/u/David_Folkner)\
**Post date:** [August 4, 2025, 6:34pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/6 "2025-08-04T18:34:07Z")

</div>

I wanted to begin playing with the database. I wanted to look at the data outside of ignition, configure replication for high availability, etc. With it being "internal," I have very few methods for interacting with it and determining if the data is good or more advanced features.

---

<div class="post-metadata">

**Author:** ![Steve\_Laubach](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steve_laubach/32/60900_2.png) [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\
**Post date:** [August 4, 2025, 8:26pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/7 "2025-08-04T20:26:52Z")

</div>

In case you didn't notice there's a new set of API calls for the historian

> **[system.historian | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/scripting-functions/system-historian)**
>
> Historian Functions

I don't know if this helps you but I noticed this new section so I thought I'd mention it.

---

<div class="post-metadata">

**Author:** ![Kyle.Chase](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@Kyle.Chase](https://forum.inductiveautomation.com/u/Kyle.Chase)\
**Post date:** [August 4, 2025, 8:51pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/8 "2025-08-04T20:51:08Z")

</div>

We are using QuestDB Embedded, so features available via QuestDB Enterprise, such as high availability, role based security, and tiered storage as not available. We are working on a solution to support synchronizing data using Ignition redundancy, but that is not available at this time.

You can access the internal historian database, in a read only manner, by creating a Postgres connection to the following details:

```python
Connection String: jdbc:postgresql://localhost:8812/qdb
Username: user
Password: ignition

```

Writing arbitrary data to the internal historian is not a planned feature at this time.

---

<div class="post-metadata">

**Author:** ![Andre\_Hennecke](https://avatars.discourse-cdn.com/v4/letter/a/e95f7d/32.png) [@Andre\_Hennecke](https://forum.inductiveautomation.com/u/Andre_Hennecke)\
**Post date:** [August 5, 2025, 9:54am UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/9 "2025-08-05T09:54:44Z")

</div>

Could you please share a timeline for the Backup and High-Availability features for the new internal database or is this already planned for the 8.3 release? These seem like essential components for a production-ready environment.

---

<div class="post-metadata">

**Author:** ![David\_Folkner](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@David\_Folkner](https://forum.inductiveautomation.com/u/David_Folkner)\
**Post date:** [August 5, 2025, 12:34pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/10 "2025-08-05T12:34:18Z")

</div>

> [@Kyle.Chase](#):
>
> Writing arbitrary data to the internal historian is not a planned feature at this time.

The default postgres connection isn't available either, but it looks installable. I'll look into that.

I don't see a setting for the password and username, that seems like a security issue.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 5, 2025, 12:37pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/11 "2025-08-05T12:37:26Z")

</div>

> [@Andre\_Hennecke](#):
>
> share a timeline

Bwah, ha, ha, ha! 🤣

"IA" and "timeline" aren't friends. 😇

---

<div class="post-metadata">

**Author:** ![Steve\_Laubach](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steve_laubach/32/60900_2.png) [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\
**Post date:** [August 5, 2025, 12:38pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/12 "2025-08-05T12:38:20Z")

</div>

Timeline... When it's done.

I'd still take that over "before it's done" which is what one particular competitor does.

---

<div class="post-metadata">

**Author:** ![Kyle.Chase](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@Kyle.Chase](https://forum.inductiveautomation.com/u/Kyle.Chase)\
**Post date:** [August 5, 2025, 12:51pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/13 "2025-08-05T12:51:35Z")

</div>

The server is bound to the loopback interface and is read only.

What do you mean by "the default postgres connection isn't available"?

---

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [August 5, 2025, 12:58pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/14 "2025-08-05T12:58:55Z")

</div>

in the meantime to have a redundant quest historian,  
we can perhaps use an history splitter with a local quest internal historian for the first connection and a remote historian with gan pointing to the local quest internal historian of the backup gateway ?

---

<div class="post-metadata">

**Author:** ![David\_Folkner](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@David\_Folkner](https://forum.inductiveautomation.com/u/David_Folkner)\
**Post date:** [August 5, 2025, 1:22pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/15 "2025-08-05T13:22:44Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/b/5b027b72874330cfa8bde5c2ff2b2653d652f93d.png)

There is no choice for PostGres out of the box, I'd need to upload my own JDBC drivers I think.

And though read only is great, some customers want even read access to be limited...

---

<div class="post-metadata">

**Author:** ![Kyle.Chase](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@Kyle.Chase](https://forum.inductiveautomation.com/u/Kyle.Chase)\
**Post date:** [August 5, 2025, 1:50pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/16 "2025-08-05T13:50:36Z")

</div>

Is this a fresh install or an upgrade? We provide a Postgres JDBC Module, which should be present on a fresh install.

---

<div class="post-metadata">

**Author:** ![Andre\_Hennecke](https://avatars.discourse-cdn.com/v4/letter/a/e95f7d/32.png) [@Andre\_Hennecke](https://forum.inductiveautomation.com/u/Andre_Hennecke)\
**Post date:** [August 5, 2025, 1:53pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/17 "2025-08-05T13:53:54Z")

</div>

> [@pturmel](#):
>
> > [@Andre\_Hennecke](#):
> >
> > share a timeline
> 
> Bwah, ha, ha, ha! 🤣
> 
> "IA" and "timeline" aren't friends. 😇

You can try it 😁

---

<div class="post-metadata">

**Author:** ![brandon1](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\
**Post date:** [August 5, 2025, 1:57pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/18 "2025-08-05T13:57:18Z")

</div>

> [@Kyle.Chase](#):
>
> Writing arbitrary data to the internal historian is not a planned feature at this time.

Okay I hear you about not storing arbitrary data. But what about Ignition's own audit event and alarm journal data? Putting that in a high performance first-party historian seems like a no brainer to me. Are you saying that a future 8.3.x version will not make that an option when configuring those systems instead of a database connection?

---

<div class="post-metadata">

**Author:** ![David\_Folkner](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@David\_Folkner](https://forum.inductiveautomation.com/u/David_Folkner)\
**Post date:** [August 5, 2025, 2:29pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/19 "2025-08-05T14:29:11Z")

</div>

> [@THauptman](#):
>
> Thanks in advance for your help!

Fresh install using docker.

---

<div class="post-metadata">

**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\
**Post date:** [August 5, 2025, 2:52pm UTC](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238/20 "2025-08-05T14:52:54Z")

</div>

You have to modify the `ignition.conf` file to enable PGwire and restart the gateway to enable the database connection.

> **[Gateway and Gateway Network Parameters | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/appendix/reference-pages/gateway-configuration-file-reference/gateway-and-gateway-network-parameters#internal-historian---quest-db)**
>
> Gateway Parameters

[Next page](https://forum.inductiveautomation.com/t/internal-historian-questdb-not-listed-in-database-query-browser/109238.md?page=2)
