# Problem to create user at gateway using postgredSQl database

**URL:** <https://forum.inductiveautomation.com/t/problem-to-create-user-at-gateway-using-postgredsql-database/71143>\
**Category:** Ignition\
**Created:** [March 16, 2023, 8:50am UTC](https://forum.inductiveautomation.com/t/problem-to-create-user-at-gateway-using-postgredsql-database/71143 "2023-03-16T08:50:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [March 16, 2023, 8:50am UTC](https://forum.inductiveautomation.com/t/problem-to-create-user-at-gateway-using-postgredsql-database/71143/1 "2023-03-16T08:50:26Z")

</div>

Hello I create PostgreSQl database connection

translate: error "scada-user relationship does not exist

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/4/24fdb1fa5b1893244c7b278de9fea93bd336a7e3.png)

When I try to create user , it doesn't work

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/e/1e60df5215c3d9dc9a564c2b0244e5039b1ecf10.png)

PostgreSQl database

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/f/7f8a7864b36a47d2e7efb453fe841020fb0a0404.png)

Can you tell me what I forgot to configure in PostgreSQl or on the gateway? Please

---

<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:** [March 16, 2023, 10:05am UTC](https://forum.inductiveautomation.com/t/problem-to-create-user-at-gateway-using-postgredsql-database/71143/2 "2023-03-16T10:05:05Z")

</div>

You need to use the adminstration account in PostgreSQL (not in Ignition), typically `postgres`, to create a login account that Ignition can use and _ **assign** _ its password. Typically, one would make that DB user the owner of the database hierarchy you will use with Ignition. At a minimum, that user must be granted the necessary access (again, done in PostgreSQL, not in Ignition).

On the Ignition side, you provide that user and password in the connection setup page so Ignition can use them to authenticate to PostgreSQL.