# Can't connect with PostgreSQL Database (wrong username)
**URL:** https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708
**Category:** General
**Created:** [2 December 2019 18:55 UTC](https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708 "2019-12-02T18:55:14Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@koenverschuren](https://discourse.nodered.org/u/koenverschuren)
#### Post date: [2 December 2019 18:55 UTC](https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708/1 "2019-12-02T18:55:15Z")
hi all,
I have a question. When building op a connection up between a Things network node and a PostgreSQL database (with Postgrestor) I get a error. The error states: "error: password authentication failed for user "Vers"". User "vers" is my Windows user account and I think that i made a mistake while installing or something. I get it on a server and on my personal computer. Has anybody experience with or know how to fix it?
my setup:
node.js version v12.13.1
node-red version v1.0.3
thank you in advance
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [2 December 2019 20:43 UTC](https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708/2 "2019-12-02T20:43:14Z")
I've never used PostgreSQL but if it is like mysql you need to have a user defined in the database, so is 'Vers' a user defined in the database?
---
### Author:  [@koenverschuren](https://discourse.nodered.org/u/koenverschuren)
#### Post date: [2 December 2019 20:49 UTC](https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708/3 "2019-12-02T20:49:05Z")
The user defined in the database is postgres. In the node I filled in the user postgres user with the correct password. It looks like he select@ the Windows user (vers) instead of the database user I filled in.
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [2 December 2019 20:52 UTC](https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708/4 "2019-12-02T20:52:41Z")
Which node-red-contrib-??? node are you using?
if you are using `node-red-contrib-postgrestor` did you fill in the user inteh security tab?
---
### Author:  [@koenverschuren](https://discourse.nodered.org/u/koenverschuren)
#### Post date: [3 December 2019 09:04 UTC](https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708/5 "2019-12-03T09:04:50Z")
Hi,
I use indeed the "node-red-contrib-postgrestor" node. 
In the picture above are the settings. I use it in this case for a Insert command.
---
### Author:  [@CokeInn](https://discourse.nodered.org/u/CokeInn)
#### Post date: [18 April 2020 22:03 UTC](https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708/6 "2020-04-18T22:03:06Z")
Hi
facing the same issue - node-red on raspberry tries to connect with 'pi' user
Did you solve it?
---
### Author:  [@koenverschuren](https://discourse.nodered.org/u/koenverschuren)
#### Post date: [19 April 2020 16:19 UTC](https://discourse.nodered.org/t/cant-connect-with-postgresql-database-wrong-username/18708/7 "2020-04-19T16:19:31Z")
hi,
yes I fixed it. I used the wrong library the correct one for my implemenatation is: node-red-contrib-postgres