Timeline for How can I keep a QGIS connection as simple as psql?
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 1, 2021 at 8:12 | comment | added | Tom | @PeterKrauss Postgres has its own authentication process. Unless you set up peer authentication, your login does not automatically transfer to Postgres. I do a lot of dev work involving Postgres, and I've consistently found that user/pass with roles specified in the DB is more reliable than peer auth. | |
| Jun 30, 2021 at 22:52 | comment | added | Peter Krauss | Hi @Tom, you and Vince are making a big mistake... Again, it is not an online server exposed to attacks from all internet, it is my personal desktop machine, on my house, and conecting database by localhost. So the authentication process is the login on my Linux machine. I use internet-banking, etc. I have local family photos, etc. so it is reliable for me and my personal PostgreSQL use. | |
| S Jun 14, 2021 at 8:26 | history | suggested | Peter Mortensen | CC BY-SA 4.0 |
Copy edited (e.g. ref. <en.wiktionary.org/wiki/question#Noun> and <en.wiktionary.org/wiki/solution#Noun>). Fixed the question formation - missing auxiliary (or helping) verb - see e.g. <www.youtube.com/watch?v=t4yWEt0OSpg&t=1m49s> (see also <www.youtube.com/watch?v=kS5NfSzXfrI> (QUASM)).
|
| Jun 14, 2021 at 8:08 | review | Suggested edits | |||
| S Jun 14, 2021 at 8:26 | |||||
| Jun 14, 2021 at 6:27 | comment | added | Tom | Do you fully understand WHY your commandline works? How the authentication process of PostgreSQL works and why peer authentication is a thing? Why do you believe that giving a username/password ONCE (when setting up the connection) is not "simple"? Your question needs more details to get a good answer. | |
| Jun 14, 2021 at 0:37 | history | became hot network question | |||
| Jun 13, 2021 at 17:56 | comment | added | Peter Krauss | No @Vince, the question is not about env configuration, is about "how to do the same", in an environment where I am happy, no changes, no need for password. | |
| Jun 13, 2021 at 17:56 | review | Close votes | |||
| Jun 15, 2021 at 7:52 | |||||
| Jun 13, 2021 at 17:54 | vote | accept | Peter Krauss | ||
| Jun 13, 2021 at 17:33 | comment | added | Vince |
You shouldn't ever connect to a PostgreSQL database as postgres via QGIS. The admin login exists to allow you to create less privileged login roles and group roles for the actual security model that will be used for your project. Passwords are a way to prevent unauthorized access. psql stores passwords in a dotfile (in clear text!) to permit casual access. This is nearly enough to get PG banished from sites that take security seriously. pgAdmin4 addressed this with encypherment of the connection passwords. It seems this enhancement request is going is the other direction.
|
|
| Jun 13, 2021 at 17:29 | answer | added | ThomasG77 | timeline score: 7 | |
| Jun 13, 2021 at 17:19 | history | edited | ThomasG77 | CC BY-SA 4.0 |
added 1 character in body
|
| Jun 13, 2021 at 17:02 | history | edited | Peter Krauss | CC BY-SA 4.0 |
added 226 characters in body; edited title
|
| Jun 13, 2021 at 16:55 | history | edited | Peter Krauss | CC BY-SA 4.0 |
added 226 characters in body; edited title
|
| Jun 13, 2021 at 16:40 | history | edited | Peter Krauss | CC BY-SA 4.0 |
added 226 characters in body; edited title
|
| Jun 13, 2021 at 16:34 | history | asked | Peter Krauss | CC BY-SA 4.0 |