Question

How do i connect postgresql db from visual studio 2019 ?

hi everyone , here’s what i’ve been trying : step#1 : sign in to DO , in the Database CLuster, select Connection Details . step#2 : in Visual Studio 19 , Tools > Connect to Database > Change Data source to PostgresSQL step#3 : fill in the fields (SSL mode = Require) step#4 : Test connection

so far, what im getting is 28P01 : Password authentication failed for user ‘xxxxx’

Anyone can help me?

TQIA


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Hi @menarsikya,

From the error you are getting it would seem the password you are using is incorrect. Please make sure you are using the PostgreSQL user with it’s proper password.

Despite that, it does seem like you can connect to the server and everything. As soon as you’ve placed the proper password, everything should be working as expected.

Regards, KDSys