# Postgres data table missing

**URL:** <https://forum.inductiveautomation.com/t/postgres-data-table-missing/70449>\
**Category:** Ignition\
**Created:** [March 1, 2023, 12:27am UTC](https://forum.inductiveautomation.com/t/postgres-data-table-missing/70449 "2023-03-01T00:27:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\
**Post date:** [March 1, 2023, 12:27am UTC](https://forum.inductiveautomation.com/t/postgres-data-table-missing/70449/1 "2023-03-01T00:27:24Z")

</div>

Recently I am migrating the database from ms sql to postgres.

But it's the second time I didn't see the user/trending tables generated automatically.  
I have three projects currently migrated:

1. the first project is migrated and the following data table appears straightaway.
2. second project was migrated but the following tables appears after I restarted the gateway.
3. third project didn't have the table appears at all, even after the gateway restarted and the database restarted. But for the third project, I have enabled the audit function and the audit table was generated automatically in the database.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/6/6696f72b0090a9e96353253a38a131ad8995fa10.png)

Not sure where I can find out the root cause? I checked the log book, it appears normal.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/4/64bb63842c37f8b8aa6f91ddcb9498140e5ac5b5.png)

---

<div class="post-metadata">

**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\
**Post date:** [March 1, 2023, 1:21am UTC](https://forum.inductiveautomation.com/t/postgres-data-table-missing/70449/2 "2023-03-01T01:21:50Z")

</div>

the tables come back after I created the first user.