From: | Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> |
---|---|
To: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
Subject: | Application trying to use wrong user when logging into the database |
Date: | 2021-03-28 13:44:59 |
Message-ID: | Wt5eqfXFsGBGpT6_-YFFDGuTpOheH21XUc2vodexpEarm11iuomdcCPCOhtJvUnMg35WVoWz72d7tpMmyvdJN-3WGqayIThKQlAFyxVrKRU=@protonmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I'm writing a web app using Node.js and pg-promise along with PostgreSQL. I've been following the documentation to connect to the database found here:
https://github.com/vitaly-t/pg-promise/wiki/Connection-Syntax#configuration-object
and have all the right data supplied. But instead of using my applications role which I created in PostgreSQL it is trying to use my Linux user name "simon" and is failing authentication because of it. I'm just confused at the moment. At no point in time have I created a role called "simon" and I have never tried to connect to any of my databases using the role name "simon", so why is it trying to authenticate as "simon"?
Sorry if this is a silly question but it has me completely stumped.
Simon.
From | Date | Subject | |
---|---|---|---|
Next Message | Bzzzz | 2021-03-28 14:00:04 | Re: Application trying to use wrong user when logging into the database |
Previous Message | vinay kumar | 2021-03-24 01:07:01 | Re: Understanding recovery conflict due to bufferpin |