Hi Assil, To save yourself from having to click away all of the error popups, you should always click the "Test Connection" button below the authentication section when you are creating a new connection.
If Hannes' answer does not solve your problem, it would be helpful if you send the full error that you are seeing. There are several possible errors that PostgreSQL could be returning, and the approach will vary depending on the error. You might also want to describe what method you used to connect to PostgreSQL and to create the database (psql, PGAdmin, DBeaver etc.). Your PostgreSQL may have stopped running and you may need to restart it, etc. that is why you want to check that you can still connect. You also may want to check the documentation page to make sure you are filling in all the necessary information, note that 3.10 is an out of date version of QGIS but the documentation on this point has not changed, also you might want to upgrade to a newer QGIS for bug fixes, etc.. https://docs.qgis.org/3.28/en/docs/user_manual/managing_data_source/opening_data.html?highlight=browser%20postgresql#database-related-tools -Thayer On Tuesday, February 7, 2023 at 03:00:47 PM EST, [email protected] <[email protected]> ---------------------------------------------------------------------- Date: Tue, 7 Feb 2023 02:40:14 +0100 From: Assil Hafdi <[email protected]> To: [email protected] Subject: [Qgis-user] Technical advice Message-ID: <CAOhm6hOg_r7qBN0JRm=-v8gawnsqjmr5yjtfgr1mdqhyskj...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Good evening I have encountered an issue with qgis 3.10 where i can't make postgis connections despite having postgresql installed and creating my data base after i name the connection and set authentication i keep getting the ente credentials pop-up even tho i enter the right credentials it keeps popping up agter 5 or 6 times it just says connection failed would love to get some help since I've scoured the internet for help but didn't find anything I would appreciate the help since im using qgis for school project Thank you in advance -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230207/69c170b4/attachment-0001.htm> ------------------------------
_______________________________________________ QGIS-User mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
