[GRASS-dev] db.login with postgresql and non standard port

[Luca Delucchi]

On 10 March 2016 at 09:10, Martin Landa <landa.martin at gmail.com> wrote:
> Hi,
>

Hi,

> 2016-03-10 9:01 GMT+01:00 Luca Delucchi <lucadeluge at gmail.com>:
>> db.login -p
>> sqlite|$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db|lucadelu|||
>> sqlite|/grassdata,nc_spm_08,lucadelu,sqlite.db|lucadelu|||
>
> well, the lines are duplicated after substitution. I don't know, your
> run command which defined db connection ones without and ones with
> substitution. Ma
>

No, I donit think so. I just run

db.connect driver=pg schema=public database=grassdata
db.connect -p

driver: pg
database: grassdata
schema: public
group:

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

sqlite|$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db|lucadelu|||
sqlite|/grassdata,nc_spm_08,lucadelu,sqlite.db|lucadelu|||
pg|host=localhost,dbname=pygrassdb_doctest|lucadelu|||
pg|grassdata|lucadelu|||

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>

So the port it is not stored, and also in db.login -p there is
something strange with

pg|host=localhost,dbname=pygrassdb_doctest|lucadelu|||

where dbname=pygrassdb_doctest should be dbname=grassdata


-- 
ciao
Luca

http://gis.cri.fmach.it/delucchi/
www.lucadelu.org