[GRASS-user] Grass 7 and postgresql

2016-09-02 Thread Benoit ANDRE
Hi all, Our GIS infrastructure is based on Grass 6.4.4, postrgresql 9.x and Qgis. Those all together are perfectly working. We want to update from 6.4.4 to 7.0.4. But we are confronted to a problem with the database : connection to postgresql is no more possible for all our maps (but still

Re: [GRASS-user] Grass 7 and postgresql

2016-09-02 Thread Moritz Lennert
On 02/09/16 11:38, Benoit ANDRE wrote: Hi all, Our GIS infrastructure is based on Grass 6.4.4, postrgresql 9.x and Qgis. Those all together are perfectly working. We want to update from 6.4.4 to 7.0.4. But we are confronted to a problem with the database : connection to postgresql is no more

Re: [GRASS-user] Grass 7 and postgresql

2016-09-02 Thread Benoit ANDRE
Moritz, First, I move from 6 to 7 with /v.build/ or /v.build.all/ (depends on locations) Here, connections are already gone... I connect with : /db.connect driver=pg database="host=192.168.1.200,dbname=administration"/ /db.connect -p/ : driver: pg database: host=192.168.1.200,dbname=administ

Re: [GRASS-user] Grass 7 and postgresql

2016-09-02 Thread Moritz Lennert
On 02/09/16 12:51, Benoit ANDRE wrote: Moritz, First, I move from 6 to 7 with /v.build/ or /v.build.all/ (depends on locations) Here, connections are already gone... I connect with : /db.connect driver=pg database="host=192.168.1.200,dbname=administration"/ /db.connect -p/ : driver: pg databa

Re: [GRASS-user] Grass 7 and postgresql

2016-09-02 Thread Nikos Alexandris
Benoit ANDRE wrote: Moritz, First, I move from 6 to 7 with /v.build/ or /v.build.all/ (depends on locations) Here, connections are already gone... I connect with : /db.connect driver=pg database="host=192.168.1.200,dbname=administration"/ /db.connect -p/ : driver: pg database: host=192.168.

Re: [GRASS-user] Grass 7 and postgresql

2016-09-02 Thread Markus Neteler
On Sep 2, 2016 6:45 PM, "Nikos Alexandris" wrote: ... > GRASS 7.3.svn (wgs84):~ > db.tables -p > 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 "/r

Re: [GRASS-user] Grass 7 and postgresql

2016-09-02 Thread Nikos Alexandris
Nikos Alexandris: ... GRASS 7.3.svn (wgs84):~ > db.tables -p 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 "/run/postgresql/.s.PGSQL.5432"? Markus Nete

Re: [GRASS-user] Grass 7 and postgresql

2016-09-03 Thread Benoit ANDRE
When I tried grass 7.0.0 when it has been released, in 2015, I remember it was working. But it was only a test and I continued To work whit 6.4.4.   Le 2 septembre 2016 20:52:28 Markus Neteler a écrit : On Sep 2, 2016 6:45 PM, "Nikos Alexandris" wrote: ... GRASS 7.3.svn (wgs84):~ > d

Re: [GRASS-user] Grass 7 and postgresql

2016-09-05 Thread Benoit ANDRE
I confirm what I said saturday. I just recompile and reinstall 7.0.0. This version has no problem with postgresql and works fine. Can that help you to find the problem ? Benoit Le 03/09/16 18:43, Benoit ANDRE a écrit : When I tried grass 7.0.0 when it has been released, in 2015, I remem

Re: [GRASS-user] Grass 7 and postgresql

2016-09-05 Thread patrick s.
Running PG connection on grass70 works for me as well. Wild guess: 1.) Are the maps stored in Schemas? (see $INPATH below) 2.) Have you tested the change/removing of quotations? (see codeexample below) My (tested) code in BASH: GSCHEMA=grass_2015 INPATH="PG:dbname=$DB_NAME active_schema=$ISCHEM

Re: [GRASS-user] Grass 7 and postgresql

2016-09-07 Thread Benoit ANDRE
hi, I compile GRASS 7.3. Postgresql connection not possible too. Very annoying Benoit Le 05/09/16 09:35, Benoit ANDRE a écrit : I confirm what I said saturday. I just recompile and reinstall 7.0.0. This version has no problem with postgresql and works fine. Can that help you to find t