[GRASS-dev] [GRASS GIS] #3167: db.connect: connection to remote database does not work

[GRASS GIS]

#3167: db.connect: connection to remote database does not work
--------------------------+-----------------------------------
  Reporter:  mlennert     |      Owner:  grass-dev@…
      Type:  defect       |     Status:  new
  Priority:  blocker      |  Milestone:  7.0.5
 Component:  Database     |    Version:  unspecified
Resolution:               |   Keywords:  postgresql db.connect
       CPU:  Unspecified  |   Platform:  Unspecified
--------------------------+-----------------------------------

Comment (by martinl):

 I tested settings bellow:

 {{{
 db.connect -p
 driver: sqlite
 database: /opt/grassdata/pgtest/pg/sqlite/sqlite.db

 db.login -p
 pg|grassremote|||myserver|
 }}}

 The commands bellow works in GRASS 73/72/70:

 {{{
 db.tables dri=pg data=grassremote | grep staty
 ruian.staty
 }}}

 `v.in.ogr` works in GRASS 73/72:

 {{{
 v.in.ogr in=PG:dbname=grassremote layer=ruian.staty out=staty --o
 }}}

 in GRASS 70 it fails with

 {{{
 ERROR 1: PQconnectdb failed.
 FATAL:  database "grassremote" does not exist

 ERROR: Unable to open data source <PG:dbname=grassremote>
 }}}

 See r67510, hard to backport. In GRASS70 you can still do

 {{{
 v.in.ogr in="PG:dbname=grassremote host=myserver" layer=ruian.staty
 out=staty --o
 }}}

 which works.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3167#comment:28>
GRASS GIS <https://grass.osgeo.org>