[GRASS-user] How Does GRASS Handle PostgreSQL Database Name Change?

[Daniel Lee]

Hi Rich,

I've also had trouble with using Postgres tables in GRASS and then changing
them. If I deleted the tables in the past, it was always very difficult to
be able to delete the corresponding vector maps. My only real positive
experience in that regard has been to delete the mapset and start anew, but
of course that's about as far from elegant as you can get. Sorry that I
don't know more about the way GRASS interacts with Postgres and where the
connection is stored.

Best,
Daniel

--

B.Sc. Daniel Lee
Geschäftsführung für Forschung und Entwicklung
ISIS - International Solar Information Solutions GbR
Vertreten durch: Daniel Lee, Nepomuk Reinhard und Nils Räder

Deutschhausstr. 10
35037 Marburg
Festnetz: +49 6421 379 6256
Mobil: +49 176 6127 7269
E-Mail: Lee at isi-solutions.org
Web: http://www.isi-solutions.org

ISIS wird gefördert durch die Bundesrepublik Deutschland, Zuwendungsgeber:
Bundesministerium für Wirtschaft und Technologie aufgrund eines Beschlusses
des Deutschen Bundestages, sowie durch die Europäische Union,
Zuwendungsgeber: Europäischer Sozialfonds. Zusätzliche Unterstützung erhält
ISIS von dem Entrepreneurship Cluster Mittelhessen, der Universität
Marburg, dem Laboratory for Climatology and Remote Sensing und dem GIS-Lab
Marburg.
On Mar 21, 2012 9:41 PM, "Rich Shepard" <rshepard at appl-ecosys.com> wrote:

>  I changed the database names so they represent the project rather than the
> state in which they're located. The postgres ALTER DATABASE command does
> the
> job quite well. Unfortunately, grass seems to be confused by the name
> change
> and any attempt to access map attributes or overlay (intersect) the table
> causes the wxPython GUI to crash and a message appears on the console that
> grass was unable to open the old database name (error #16007.1) and unable
> to describe the table _LAB (error #16010.1).
>
>  After changing the postgres database name I ran db.connect to associate
> the new name with the location and mapset. It appears that this does not
> change where grass has the old name tucked away. The VAR file has the new
> database name.
>
>  I want to better understand how grass interacts with postgres and where
> it needs to be modified to reflect the new database names. If this is in
> one of the db.* modules I missed seeing it.
>
> TIA,
>
> Rich
>
> ______________________________**_________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/**mailman/listinfo/grass-user<http://lists.osgeo.org/mailman/listinfo/grass-user>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20120321/8854729e/attachment.html