search

landam / grass-gis-git-migration-test

0 stars 0 forks source link

Allow users to define PG as their default DB backend globally #185

Open landam opened 5 years ago

landam commented 5 years ago

Reported by sbl on 4 Jan 2016 13:22 UTC There is currently no way to for user(s) to define PostgreSQL as their the default DB backend (instead of SQLite). Other connection parameters than the default have to be defined for each mapset using ''db.connect''. Connection parameters are then stored in the mapset`s VAR file.

A global setting in e.g. a file $HOME/.grass7/dbconnect_default which may contain e.g.:

driver=pg
database=MY_DATABASE
schema="$LOCATION_$MAPSET"
group=MY_GROUP_USER

would be nice.

But that would probably also require changes to the initialization of the DB backend, if the default behavior (meaning SQLite) should be overwritten (and would require that users are granted CREATE rights on SCHEMAs if one wants to have a schema per location/mapset combination)...

Would be nice if such a setting could also be taken into account by t.connect...

Migrated-From: https://trac.osgeo.org/grass/ticket/2847

landam commented 5 years ago

Modified by @landam on 4 Jan 2016 13:30 UTC

landam commented 5 years ago

Comment by neteler on 5 May 2016 14:08 UTC Milestone renamed

landam commented 5 years ago

Comment by neteler on 28 Dec 2016 15:04 UTC Ticket retargeted after milestone closed

landam commented 5 years ago

Modified by @landam on 5 May 2017 20:40 UTC

landam commented 5 years ago

Comment by @landam on 1 Sep 2017 20:28 UTC All enhancement tickets should be assigned to 7.4 milestone.

landam commented 5 years ago

Comment by neteler on 26 Jan 2018 11:40 UTC Ticket retargeted after milestone closed

landam commented 5 years ago

Comment by sbl on 20 Mar 2018 17:15 UTC Assigning enhancement to 7.6

landam commented 5 years ago

Comment by @landam on 25 Jan 2019 21:07 UTC Ticket retargeted after milestone closed