Feature request #3769

PostGIS connections: take them from PgAdmin3?

Added by Paolo Cavallini about 8 years ago. Updated over 1 year ago.

Status:Open
Priority:Low
Assignee:-
Category:Data Provider/PostGIS
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:13828

Description

It seems interesting to load the connection settings for PostGIS from
those in .pgadmin3 (or syncing them both), so the user should not repeat the config twice.

History

#1 Updated by Mayeul Kauffmann about 8 years ago

A few notes on this interesting idea:

  • If you have 30 databases on 3 local servers (e.g. dev, testing, prod) and only one of those databases has tables with spatial objects, you do not want to list them all in qgis. So you should be given the choice.
  • In any case this should be optional (you should be able to configure it manually, and you still need to give a password if you are not using a socket or another method of authentification).
  • This relies on knowing where this pgadmin config file is. I guess it is in ~/pgadmin3 in most GNU/Linux box.

In qgis developer mailing list, Alessandro F. said:

"WinOz doesn't uses any file to store permanent settings: it uses the System Registry instead. so pgadmin connections are stored under the following registry key:

HKEY_CURRENT_USER/Software/pgAdmin III/Servers
"

#2 Updated by Giovanni Manghi over 7 years ago

  • Target version changed from Version 1.7.0 to Version 1.7.4

#3 Updated by Giovanni Manghi about 7 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

#4 Updated by Pirmin Kalberer over 6 years ago

  • Target version changed from Version 2.0.0 to Future Release - Nice to have

#5 Updated by Giovanni Manghi about 2 years ago

  • Pull Request or Patch supplied set to No
  • Easy fix? set to No

#6 Updated by Paolo Cavallini over 1 year ago

  • Description updated (diff)

Still unimplemented in QGIS3

#7 Updated by Nyall Dawson over 1 year ago

Is this possible with pgadmin4? Or should we just close as irrelevant now?*

  • Saying this as a staunch pgadmin 3 holdout.

#8 Updated by Paolo Cavallini over 1 year ago

No idea about pga4, sorry.

#9 Updated by Paolo Cavallini over 1 year ago

Still true in QGIS 3.

#10 Updated by Giovanni Manghi over 1 year ago

  • Category changed from Data Provider to Data Provider/PostGIS

this should be "moved" to pgadmin4, but considered how bad it is I really don't know who would use it.

#11 Updated by Paolo Cavallini over 1 year ago

Agreed, it's not even available on Debian Sid.

#12 Updated by Paolo Cavallini over 1 year ago

  • Assignee deleted (nobody -)

Also available in: Atom PDF