[GRASS-dev] [GRASS GIS] #2960: db.login port parameter

[GRASS GIS]

#2960: db.login port parameter
--------------------------------------------+-------------------------
 Reporter:  lucadelu                        |      Owner:  grass-dev@…
     Type:  defect                          |     Status:  new
 Priority:  major                           |  Milestone:  7.0.4
Component:  Datasets                        |    Version:  svn-trunk
 Keywords:  database, postgresql, db.login  |        CPU:  Unspecified
 Platform:  Unspecified                     |
--------------------------------------------+-------------------------
 It seems that PostgreSQL database library is not working correctly with
 port different from the standard 5432.

 Following the steps I did
 {{{
 db.connect driver=pg database=grassdata

 db.login driver=pg database=grassdata user=lucadelu port=5433
 host=localhost
 db.login -p

   pg|grassdata|lucadelu|||

 cat /home/lucadelu/.grass7/dblogin

   pg|grassdata|lucadelu||localhost|5433

 db.tables

   DBMI-PostgreSQL driver error:
   Connection failed.
   could not connect to server: No such file or directory
         Is the server running locally and accepting
         connections on Unix domain socket
 "/var/run/postgresql/.s.PGSQL.5432"?

   DBMI-PostgreSQL driver error:
   Connection failed.
   could not connect to server: No such file or directory
         Is the server running locally and accepting
         connections on Unix domain socket
 "/var/run/postgresql/.s.PGSQL.5432"?

   ERROR: Unable to open database <grassdata>
 }}}

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2960>
GRASS GIS <https://grass.osgeo.org>